I decided to write a macro for my plugins. It is below. I do not know if the hex Ao space copied in this paste, but it did when I recorded this snippet of code.
Before you use this please virify using the function Moo outlined above.
I will use this on the entire worksheet when I get data in.
Thanks and marking this Solved.
Sub Replace_Hex_A0_Space()
'note the apparent space in the equation below is actually a Hex A0 and not the usual hex 20
'
Cells.Replace What:=" ", Replacement:=" ", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub
Bookmarks