TRIM function


TRIM function is used to remove irregular spaces between words which may appear while importing data from another application.



where text (argument) means that any information in a worksheet from which you want to clean from unwanted spaces.


1. Select cell B2, next to the cell A1 with irregular space.

 2. Type =TRIM(address of the cell to clean unwanted space).

3. Press Enter.


Copyright © 2016 - 2018 | All Rights Reserved