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.
3. Press Enter.