Formatting number in a text output to show thousands separator
Formatting number inside text output in Excel will save the aspect of the report generated. Sometimes you need to optimize the time taken to update a excel spreadsheet report by using formulas which output text and numbers. If you use only the concatenating operator the result will be that the number inside the text is […]
Split text into sentences in Excel
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 the formulas in the image below. If the text is too large for a single cell you […]
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 […]