About this tutorial:
Video duration: 00:02:11
Learn how to use the Trim function in Excel to clean up extra spaces in spreadsheets. #excel #exceltutoria
Extra spaces can become a headache in Excel. You’ll come across extra spaces when you will import data from another system or copy data from your email etc.
Each cell value ends up having spaces. Sometimes they can be removed easily with the TRIM function but sometimes TRIM doesn’t work! In this video I’ll show you how you can TRIM ALL Spaces
TRIM can only remove spaces with an ASCII character code 32. But there is another character code that represents a space. It’s commonly…