Most likely a non-breaking space...........char 160

CLEAN and TRIM will not pick it up.

Try EditReplace

What: Alt + 0160(on numpad)

With: nothing

Replace all.


Gord Dibben MS Excel MVP

On Sat, 9 Jan 2010 13:44:01 -0800, CharlesZ
wrote:

I have a list of email addresses that have hidden text before the first
letter of the email address. I tried all the functionalities to get rid of
this spacing/hidden text, but, it does not work. Now I am trying to
hyperlink the email addresses, how do I do that?