It is to delete the space at the beginning and/or at the end of a word and phrase, so not the spaces between.
When I use the formula ?
In many times, when I extract data into excel, cells with word have an empty space before or after the word and I need to delete it for other formulas referencing those cells to work.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How are the formulas ?
The first formula should work:
If it doesn’t work, so I use the combination: