Explainry Tutorials to Expert in IT

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 - 2020 Explainry.com | All Rights Reserved