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/29/use-trim-with-substitute-function-in-excel/ 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. https://youtu.be/hCTKYRhGbhE?si=IGOz2MXKCqeOhQ0B ⭐ *Remove Spaces Before and After Text* Remove spaces in Excel cells quickly using Find and Replace and the TRIM function. https://youtu.be/Qg8kBTFtZ2Q *⭐ Simple fix when TRIM function doesn't work (no formula required)* Remove unwanted spaces that the TRIM function misses. No formulas required! https://youtu.be/GaXpC6i_YtU 🔔 JOIN MY INSIDER GROUP! For WEEKLY SUPER TIPS + Tutorials delivered directly to your inbox!: https://www.excelatwork.co.nz/subscribe-eawi-weekly-tips/ 🔔 👨‍💻 Online Excel & Word Courses https://www.excelatwork.co.nz/self-paced/online-excel-courses-nz/ 📱 SOCIAL Let’s connect on social: https://www.facebook.com/excelatworknz 🎬 For super helpful tips and full tutorials, follow us on our YouTube Channel: https://www.youtube.com/c/excelatwork 📣 Share this with someone who would enjoy this tip 🎉 #Exceltips #MicrosoftExcelTutorial #ExcelShortcuts #ExcelTraining #ExcelatWork #SharynBaines