4 articles String formulas

Count words in Excel using worksheet formulas

Count Words in Excel

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…


Insert a word in a string in Excel

insert word in a string

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 string “Growing a green apple tree in a green field.” before the word “apple”. Inserting a word in a string First determine…


Finding the position of the second appearance of a word in a string


Some times we need to use a formula in order to seek the position of a word in a string, in order to subtract a part of that string. In the following article I will show you the way to detect the position. Finding the position of the first occurrence Using the find() formula we…