Excel's TRIM function removes extra spaces in cells

Use the =TRIM() Function to remove extra spaces in your cells.

How did you get those extra spaces? Possibly, when you combined multiple text strings into a combined cell.

Does it matter? You just want to remove the unwanted extra spaces.

Watch this video lesson to learn how to do it.

If you want to see all of my Excel Video Lessons, I invite you to visit my website -
http://thecompanyrocks.com/excels

Category:

Education

Tags:

• Excel
• Trim
• Function
• Remove
• Spaces

[ncvideoprimeinc]

Thanks just what I needed for one of my projects.

[DannyRocksExcels]

@ncvideoprimeinc

My pleasure. I am happy that I could help you with your project.

Danny Rocks

The Company Rocks

[Hydee126]

Thank you - this was exactly what I needed and had a few extras I'll hold onto.

[DannyRocksExcels]

@Hydee126

My pleasure! I am happy that I could help you to understand how to use these TEXT Functions in Excel.

Danny Rocks

The Company Rocks

[Surannhealz]

Thanks for the info! It helped me convert some numbers that were presented as "17 040 945" with spaces instead of commas for the 1000's places. Though I ended up having to do a text to column since the trim didnt work on single cells, so I split them out, then recombined using the trim(&&&) command you have shown here.