Use TRIM with SUBSTITUTE Function in Excel (Remove Extra Spaces)
Use TRIM with the SUBSTITUTE Function in Excel to fix those stubborn spaces the TRIM function can’t remove! 💡 If you’ve ever used the TRIM function in Excel and found it’s not working — leaving hidden or non-breaking spaces behind — this tutorial will help. I’ll show you exactly how to combine the TRIM and SUBSTITUTE functions in Excel to clean up messy text and imported data. In this beginner-friendly video, you’ll learn: ✅ Why the TRIM formula sometimes doesn’t work in Excel ✅ How the SUBSTITUTE function replaces non-breaking spaces with regular ones ✅ The exact formula to fix TRIM not working issues Whether you’re tidying phone numbers, cleaning up text from external sources, or dealing with data where the *TRIM function in Excel* won’t work on its own, this quick fix will leave your spreadsheet neat, accurate, and ready to use. Perfect for beginners, admin staff, and anyone working with imported Excel data. 📥 Practice file download: https://www.excelatwork.co.nz/2025/07... In this Excel tutorial, you'll learn: 00:00 – Use TRIM with SUBSTITUTE Function in Excel 00:24 – Introducing the TRIM function in Excel and what it’s meant to do 00:59 – Remove spaces using Copilot 02:50 – When the TRIM doesn’t work (hard/non-breaking spaces) 03:13 – Step-by-step breakdown of the SUBSTITUTE function with CHAR(160) and CHAR(32) 03:55 – Use TRIM with the SUBSTITUTE function to remove spaces Related videos: * ⭐ Remove Space Between Numbers In Excel Learn how to remove a space between numbers in Excel quickly and easily. • Remove Space Between Numbers In Excel ⭐ Remove Spaces Before and After Text Remove spaces in Excel cells quickly using Find and Replace and the TRIM function. • EXCEL Remove Spaces Before and After Text ⭐ Simple fix when TRIM function doesn't work (no formula required) Remove unwanted spaces that the TRIM function misses. No formulas required! • Simple fix when TRIM function doesn't work... 🔔 JOIN MY INSIDER GROUP! For WEEKLY SUPER TIPS + Tutorials delivered directly to your inbox!: https://www.excelatwork.co.nz/subscri... 🔔 👨💻 Online Excel & Word Courses https://www.excelatwork.co.nz/self-pa... 📱 SOCIAL Let’s connect on social: / excelatworknz 🎬 For super helpful tips and full tutorials, follow us on our YouTube Channel: / excelatwork 📣 Share this with someone who would enjoy this tip 🎉 #Exceltips #MicrosoftExcelTutorial #ExcelShortcuts #ExcelTraining #ExcelatWork #SharynBaines
