How to count words? There is no longer a need to send telegrams, and the need to count words seldom arises. However, this is a nice opportunity to try out how to use the TEXTSPLIT function in combination with some other Excel functions. Who knows, maybe this will be useful to you one day? In honor of Pink Floyd, let’s count the words in the song “Shine On You Crazy Diamond”.
A few years ago, I attended a panel discussion on whether artificial intelligence will be able to replace humans when it comes to creative writing. Some participants claimed yes, others no, and my position is that it is not so much who will write and how, but who will such materials. Gloomy vision, isn’t it? In this text, I will show you how to fill in the pre-prepared text with your own values and thus create fake news using the SUBSTITUTE function.
By implementing business software we usually retrieve Master data from the previously used application, primarily the Partners and Items. Data is usually exported from old software to Excel, it is processed, and imported into a new application. When processing, there is often a need to “cut” the text in one of the columns from the left, from the right or from the given position, or to find a part of it in order to use it to generate some new content …