Excel not recognizing a space

Please sign up for the course before starting the lesson.

Occasionally when you try some of the methods mentioned in this course, you may come across situations where Excel does not seem to be seeing what you see. This is most common with spaces. If you try and replace a 'space' with nothing you may find that Excel tells you there are no spaces even though you can clearly see a space. Excel is seldom wrong and if it says there are no spaces then there are no spaces (i.e. no spaces generated by clicking the space bar on your keyboard). However we need to understand what Excel sees as a space. The video below shows the issue and how to address it...

Back to: Data cleanup in Excel > Convert 'Text' fields into usable numbers