displaying underlying code

C

ChiefBlogster

I have a column that shows peoples names and the names link to thei
email address. How do I go about separating the email address out s
they are in a separate column. I have tried all the paste specials bu
I just can not get the underlying code to display.

Any suggestions would be appreciated.

Thanks,

Arthu
 
C

CyberTaz

It sounds like the cells actually contain hyperlink email addresses and
that the names have actually been caused to appear by using them as
display text. Assuming this to be the case...

First select & copy the column of names & in another column use
Edit>Paste Special--Values so you won't have to retype the names.

Next, cmd+click each hyperlink cell in turn & use Edit Hyperlink to
delete the display text one at a time. There may be a way to automate
the process, but I haven't a clue how to write the code.

HTH |:>)
 
Top