Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Simple fix when TRIM function doesn't work (no formula required). That video is uploaded by Excel at Work at 2020-10-14T06:00:03-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [GaXpC6i_YtU]
| Name | Simple fix when TRIM function doesn't work (no formula required) |
| Video Uploader | Video From Excel at Work |
| Upload Date | This Video Uploaded At 14-10-2020 13:00:03 |
| Video Discription | Sometimes the TRIM function doesn’t remove ALL unwanted spaces. If you are having this problem, you might like to try this quick fix. No formulas required Timestamps: 00:00 Remove spaces that the TRIM function misses 00:52 Remove spaces from a number 01:50 Remove hard spaces from a cell in Excel 02:10 What is the difference between a normal space and a hard space or non-breaking space? 03:00 Replacing hard spaces with normal spaces so that TRIM will work Topic #80 in the ‘Steps to becoming Proficient in Excel’ workbook. 👀 Read the full blog here: https://www.excelatwork.co.nz/2021/04/19/when-the-trim-function-doesnt-work/ 🔔 Become an Excel at Work Insider (100% free) and grab your copy of the ‘Steps to becoming Proficient in Excel’ workbook today: https://excelatwork.co.nz/subscribe/ 🔔 ❤ VERSION FRIENDLY ❤ Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 (a.k.a Office 365). Sharyn’s using the desktop version of Excel for Microsoft 365 as part of the Microsoft 365 Business Standard subscription. #ExcelTutorial #ExcelTips #ExcelIntermediate #ExcelFunctions #ExcelatWork GaXpC6i_YtU |
| Category | Howto & Style |
| Tags | trim function will not work | trim function doesn't work | excel trim isn't removing all spaces | when trim function doesn't work | when the trim function doesn't work | remove spaces the trim function does not catch | why trim function doesn't work | trim function does not work in excel | trim function does not work | trim function won't work | trim function not working | why is the trim function not working | why does trim function not work | excel remove non breaking space |
