Remove Space Between Numbers In Excel

*Learn how to remove space between numbers in Excel quickly and easily.* If you're dealing with messy data — like phone numbers, account numbers, or values that won’t sort properly — unwanted spaces can get in the way. In this beginner-friendly tutorial, you’ll discover simple ways to **remove space between numbers in Excel**, whether the spaces are before, after, or between digits. Perfect for tidying up imported data or fixing formatting issues in your spreadsheets. ✅ You’ll learn how to: • Remove spaces between numbers. Great for mobile numbers, values, and codes. • Reset your numbers so that you can sort, filter and calculate without hassles! • Stop hidden spaces from messing up your work! 📥 *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 – Remove Space Between Numbers In Excel 00:10 – What happens when you try to use TRIM on numbers with inner spaces 01:10 – Introducing SUBSTITUTE to remove spaces between digits 02:10 – The difference between normal and hard spaces (non-breaking spaces) in Excel 02:36 – Formula to remove hard spaces in Excel 03:08 – Optional: Convert formulas to values for clean data ### Related videos: ⭐ *EXCEL 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 the TRIM function misses. No formulas required ! https://youtu.be/GaXpC6i_YtU ⭐ *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! https://youtu.be/AagoACqt7Nk 🔔 *WEEKLY SUPER TIPS* WEEKLY SUPER TIPS 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 Facebook: https://www.facebook.com/excelatworknz 🎬 *For super helpful tips and full tutorials, follow me on YouTube:* https://www.youtube.com/c/excelatwork 📣 Share this video with someone who's had enough of messy Excel numbers 🎉 #ExcelTips #ExcelShortcuts #CleanDataInExcel #ExcelTraining #ExcelatWork #SharynBaines