TRIM Formula with Example MS Excel

TRIM Formula Excel / How to use Trim Function in MS Excel / Use of TRIM Formula in Microsoft Excel Spreadsheet / TRIM Example Excel.

There is a Formula in Microsoft Excel Software, TRIM Formula. TRIM Formula is a very interesting and useful formula in MS Excel. Here we will learn how to use TRIM Formula with Example? In this Formula we will use LEN Formula for the better understanding of TRIM Formula.

Where we use TRIM Formula, How to use TRIM Formula in Excel and What is the TRIM Formula Syntax in Microsoft Excel Software?

TRIM Formula Syntax:-  =TRIM(text) or =TRIM(cell reference)

Sometimes we get double spaces in our data and we wants to get rid of any double space in a cell, except for single spaces between words. There are some situations when you pull data from a database or you get data from other sources and for some reason extra spaces are put in behind or in front of proper data, in that case TRIM formula is extremely useful. So, to remove extra spaces (more than one space in a cell), spaces after the data or spaces before the data TRIM function is used.

Example of TRIM Formula:-

We have a sentence in cell B2 (Just for an example) and sentence has more than one space in between the sentence and once space before the starting of the sentence and one space after the sentence, so to remove all more than 1 space in between the sentence, spaces before sentence and spaces after the sentence, we will use TRIM formula in cell D3 and Result in D4.

TRIM Formula Image

To know how TRIM Formula works in Excel worksheet, we will use LEN Formula to know the character count before the TRIM Formula and to know the character count after TRIM Formula.
Know about LEN Formula in MS Excel, CLICK HERE.