Removal of invisible Hexadecimal characters in an excel cell 1

[belstoy]

I received an external spreadsheet from a customer with a "First Name" and "Last Name" column. It appears at the end of each cell there are invisible Hexadecimal characters. How can I remove them?

Belstoy

 

[FXP]

If all the weird characters are all at the end of a string, write a maco that checks each cell by character (a-Z) and truncate the string at the first unacceptable character.

 

[Remou]

Hi
Somewhere is these fora there is a thread on this, but I can't remember the details . Alt 255 is an invisible space-like character that can be replaced, it could be that.

 

[Remou]

Hi
I found it! thread68-1014168.

 

[PHV]

You may consider the CLEAN WorksheetFunction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886