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’

Want To See Possible Results Of CONCATENATE Function?

CONCATENATE is a function used to join text in one cell to another. You can find ‘concatenate‘ in paste function dialog box.

Click the ‘Paste Function’ icon in standard tool bar to open function dialog box. Select concatenate function from Text category.

A formula wizard appears in your screen that assists you in building the formula properly. You can drag it in case it covers your working area. Using mouse select the cells from which you want to join text. You can select several cells to form a long chain.

Tip: Use Shift and F3 keys at the same time to open Paste function dialog box.

If you want to type directly the formula please go through the following examples.

=CONCATENATE(G17,G18)

This formula simply joins text in the two cells G17 and G18

=CONCATENATE(G17," ",G18)

This formula joins text in the two cells G17 and G18 with a gap in between.

=CONCATENATE(G18," April’ 05")

This appends text ‘April’ 05’ with the value in G18.

Tips: You can even join texts that are in different cells using a simple method. Go through the previous examples using this easy way.

=G17 & G18

It joins text in the two cells G17 and G18

=G17&" "&G18

It joins text in two cells G17 and G18 with space in between.

=G18&" April' 05"

It appends text April’ 05 with the value in G18

Try yourself and simply your day to day task. This function is very easy to use.

:-)