Learn Excel 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.