Episode 299 - Replace Malfunction

I have this data and I am trying to replace the spaces. Every time I use Edit - Replace, it tells me there are no spaces to replace. What the heck is going on? You might have run into this, if you've ever copied data from a web page. Episode 299 shows you how to deal with these. Learn the CODE, CHAR, and SUBSTITUTE functions.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!