Solve formatting Problem While Importing Data.

TRIM function is used to remove unwanted spaces from text. When importing data from other applications into Excel, there will be lot of spaces formed in between words.

This function helps to remove all the spaces except for single spaces between words.

Syntax for TRIM function

=TRIM(cell reference)

Here cell reference is the cell that has the text to be trimmed. You can either directly type the cell reference or select the cell using your mouse. Remember that only one cell can be selected to perform this function.

Go through the below examples to get a clear idea about the syntax.

Assume that in cell E11 we have the following text.

‘Global       Marketing      Company     -     Tokyo’

=TRIM(E11)

The result we get after using the TRIM function will be the following

‘Global Marketing Company - Tokyo’