- Trim ( )
It removes all extra spaces from the target cell.
e.g. all spaces before and after the text and more than one space in between words. - Clean ( )It removes wild and non-printable characters from the target cell.
e.g. non-readeable characters that come from extarnal data copying or opening a non-recognizable file.
Formula - How to clear extra spaces or wild characters in text?
Two formulas can be used for this purpose:
Said
I was not aware about these formulas and these are good to use. Specially the 1st one, i.e., Trim(). As while doing RCA, sometime I use space bar key more than once in between. So, it’s a best way to remove those extra spaces.
Pooja