hyperlinking email addresses

  • Thread starter Thread starter CharlesZ
  • Start date Start date
C

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?
 
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
 
Back
Top