How To Remove Spaces In Excel Using
The Function TRIM (Step-By-Step)
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
When you import text into Excel, it often comes with extra spaces. And that can be very annoying.
Sometimes it can even prove problematic when you’re using that text in a function.
Fortunately, Excel has a very simple solution for that problem: the TRIM function!
We’ll be looking at what TRIM does and when you might use it in the rest of this post.
Read on to find out more…
*This tutorial is for Excel 2019 for Windows. Got a different version? No problem, you can still follow the exact same steps.