The solution for this problem is simple. The words are separated by spaces and these spaces need to be counted in order to find out how many words there are inside the text. Worksheet formula to count words in a text If we eliminate the spaces with the Substitute formula and count how many eliminations […]

# Category: String formulas

The formulas to split text in Excel are very simple. All you need to use is Left(), Right() and Find(). Spliting text First you have to store the whole text into a cell and from there start writing th

If you need to insert a word in a string using Excel formulas the position where this should happen must be determined first. Let’s say the word “fresh” must be inserted in the strin