Mysterious characters I can't get rid of!

Hi All,

Helping a friend at work with a macro, but am finding that there are some unprintable, unseen characters that appear after we load data into the spreadsheet that we can't seem to scrub.

When I paste the string into MS Word, it looks like the attached. I'm not sure what those characters are, but I need to replace each one with a space (the number of spaces before the text in each cell is an important part of the macro.)

So the question is, what are those characters, and how can I replace them with spaces?

Thanks, as always, for any assistance.

a sheet would be useful here, the characters are probably control characters, we can identify them and give a solution from a posted sheet!

Try using the CODE function to return the character code

=CODE(A1)

then try using the SUBSTITUTE function to replace the character with spaces

=SUBSTITUTE(A1,CHAR(126)," ")