Excel Basic Function TRIM | Trim Function in Excel




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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads