Find and replace blank characters

Originally Posted by ContaminatedWitExcel

dont wanna arque but but i made by my own way and got the same results?!...

CHAR160 <> CHAR32 as Apple <> Banana...

List of ANSI codes: http://www.alanwood.net/demos/ansi.html

If you ever want to get a list for yourself...

A1: =CHAR(ROWS(A$1:A1))
copy down to A255