Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Remove ALL Unwanted Spaces in Excel (TRIM ALL Function?). That video is uploaded by Leila Gharani at 2020-01-30T02:00:06-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [ZKgosgTo38I]
| Name | Remove ALL Unwanted Spaces in Excel (TRIM ALL Function?) |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 30-01-2020 10:00:06 |
| Video Discription | Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses Stubborn spaces can become a headache in Excel. You'll come across extra spaces when you copy data from your email or import data from another system. Each cell value ends up having trailing or leading 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 - also the stubborn ones. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/trim-spaces-file TRIM can only remove spaces with an ASCII character code 32. But there is another character code that represents a space. It's commonly referred to as a Non-Breaking Space and its ASCII character code is 160. Such spaces commonly occur when we copy text from Outlook or a website to Excel. With the Excel function CODE() we can identify which character code we are dealing with. To remove a non-breaking space in Excel we can use the SUBSTITUTE function. With this function we can look for character code 160 in a cell and replace it with a regular space. For numbers that are not recognized as numbers by Excel we can use the VALUE function. If the number contains non-breaking spaces use it in combination with the SUBSTITUTE function. 🔎 Video Insights: - Understand why the TRIM function might fail to remove certain types of spaces. - Learn about the non-breaking space (ASCII character code 160) often encountered in data from external sources. - Master the SUBSTITUTE function to eliminate pesky non-breaking spaces. - Discover how to use the VALUE function effectively when Excel fails to recognize numbers. 💡 Key Takeaways: - Tackle common but tricky Excel challenges with confidence. - Learn how to clean and format your data correctly, saving time and reducing errors. - Enhance the reliability of your data analysis with these expert tips. 00:00 What To Do When VLOOKUP Does NOT Work 01:01 What to Do When TRIM Does Not Remove Spaces 03:36 Use SUBSTITUTE to Remove Spaces Between Words 04:49 What To Do When Excel Does Not Recognize Numbers 07:20 Wrap Up Check out other Excel tips and tricks in this playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxVeel8DFjewBSlZYdfd38A ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel ZKgosgTo38I |
| Category | Education |
| Tags | XelplusVis | Leila Gharani | Advanced Excel tricks | Excel online course | Excel tips and tricks | Excel for analysts | Microsoft Excel tutorials | Microsoft Excel | Excel 2016 | Excel 2013 | Excel 2019 | XelPlus | Excel TRIM function | excel trim doesn't work | excel remove spaces | excel remove unwanted spaces | excel remove nonbreaking space | remove non-breaking space | Excel Trim ALL | Excel substitute function | character code 160 | remove leading spaces in excel | remove trailing spaces |
