Stubborn space in Excel- Remove space not working to 'see' numbers скачать в хорошем качестве

Stubborn space in Excel- Remove space not working to 'see' numbers

When Excel tells you it cannot see spaces in a cell that you can see, it is probably a special space that is NOT generated by clicking the space bar on your keyboard. How to easily remove these 'spaces' in order for Excel to recognize numbers ------------------------------------------------------------------------------------------------------------------------------------------------------ ✅- Free check of your Excel Skill Level-https://excel-skills-assessment.com/s... 🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e... 🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex... 🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/ ------------------------------------------------------------------------------------------------------------------------------------------------------ Time Stamps 00:00 Numbers that work when you delete space but you can't FIND/ REPLACE the spaces 00:32 Excel does not see spaces that we can see 00:40 Understanding character 160- non breaking space in Excel 00:56 Quick fix- copy the 'space' and use it in FIND/ REPLACE or formula 01:10 Use the special space in the SUBSTITUTE function 01:42 May still need to use VALUE function