TRIM function

Use

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

Syntax

=TRIM(text)

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

Example

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