How to remove leading and trailing spaces in Microsoft Excel 2016 ?

There are times when you would have the cell that contains the blank spaces before or after the text. You can easily remove it using the TRIM function in Microsoft Excel 2016.

How to remove leading and trailing spaces in Microsoft Excel 2016 ?

Assume that the cell A1 contains the text ” GINKTAGE  ” which contains the trailing spaces.

In the cell B1 , enter the formula =TRIM(A1) and press the enter key. This would display only GINKTAGE without leading and trailing spaces in the cell B1.

image

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...