Removes Unwanted Spaces Leading, Trailing And Between Words From The Text String.

In Excel spreadsheet, if you have typed some extra spaces between words. Therefore, you can use TRIM(text) function in order to get rid of those unwanted spaces. This function will erase all extra spaces but except for single spaces between them.

In addition the formula =TRIM(text) function will remove leading and trailing spaces from the text as well.

Syntax

TRIM(text)

How to use formula:

To type:

1] =TRIM into any cell.
2] (
3] Select the cell wanted to be trimmed. (See the image below as example by putting cell A1)
4] )

It's done.

Text: the text in any cell from which you want spaces deleted.

See an image example below for understanding easily.

Did you find this article useful?

See more another tips:

• VLOOKUP Searches For Value From Table Array In The First Column Return Value The Same Row
• Formula “LOOK UP - Array Form” Automatically Looks Approximate Match Values First Row/Column
• Formula “LOOK UP” For Using Approximate Match Values Sorted Ascending Order In a List
• Method of Extract the Specified Characters from the End of Text String Content
• How To Extract The Specified Characters From The Left Of The Text String In Active Cell
• Delete Unwanted Characters and or Blank Space From The Left Side Of Contents In Active Cell
• Removes Characters and Blank Space From The Right Side Of Contents In Cell | Xcel-Guru
• Excel Trick Expand Excel Column Width Fit To The Longest Data Entered
• [Ctrl] + [-](minus sign) Excel Shortcut Open Dialog Box Menu of Delete Cells, Row and Column Function
• 4 Cool Ways To “Sum” Values Of Number In An Excel Worksheet – ExcelTip2day

You might like my another blogs:

• Learn Thai Free Online [LTFO] | Michael Leng
• Just Sing Along Blog | Song Lyrics In English-Thai Language
• Book-Hub | Best Seller Book Review
• [C+] Cell Phone and Accessory Review
• [1English-1Thai] English – Thai Dictionary Learning Blog