TRIM Function in Excel 2010


In the following tutorial we will describe to you the syntax and the usage of TRIM Function in Excel 2010 Application. The TRIM function is used to remove all spaces from the Text except the single word spacing between words in the text. The TRIM Function comes in handy when you want to remove irregular spaces from the Text that you have imported from some other application.

Syntax

The Syntax of the TRIM Function is as follows

=TRIM(“text”)


Where, the ‘text’ is the text from which you want the spaces to be removed. The text argument should be enclosed within the double quotes.


Example


Figure 1


Let’s say that, you want to remove blank spaces from the Text “Itechtalk Forum Tutorials”. Then, the formula for the TRIM function should be written as follows

=TRIM(“Itechtalk Forum Tutorials”)

Now, if you observe your worksheet, the irregular spaces from the text would have been removed with only one word spacing between the words in the text.

You can also supply cell references as an argument to the TRIM Function. For example, if you intend to remove the irregular spaces from the text present in cell B9, then the formula for the TRIM function can be written as

=TRIM(B9)

So, this is how you can use the TRIM Function to remove irregular spaces from a particular text in the Excel 2010 Application.


Read Other Applications