Insert a word in a string in Excel
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 […]