Learn Excel Episode 299: Replace Malfunction

Posted in Companies, Podcasts on July 02, 2008


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.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel