hyperlinking email addresses

[CharlesZ]

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?

 

[Gord Dibben]

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

CLEAN and TRIM will not pick it up.

Try Edit>Replace

What: Alt + 0160(on numpad)

With: nothing

Replace all.


Gord Dibben MS Excel MVP