J
JBird11002
I copied a list of Hyperlink emails from a website onto an Excel sheet and
would like the emails to actually display as emails and not the name of the
individual. I know how to do each cell; I just delete the "friendly_text" in
the Hyperlink Set-up. What I need to do is change the whole column of several
Hyperlinks. Here is a sample of what I am asking:
Hyperlink displayed in the cell: "John Doe" <<this is the friendly_text
that's displayed in the cell>>
The actual Hyperlink is: mailto: (e-mail address removed)
I want the "mailto: (e-mail address removed)" to be displayed in the cell
As I said before; I know how to do one cell at a time but what about the
whole column at once? Is there a way to fix this when I have hundreds of
cells I need to change?
would like the emails to actually display as emails and not the name of the
individual. I know how to do each cell; I just delete the "friendly_text" in
the Hyperlink Set-up. What I need to do is change the whole column of several
Hyperlinks. Here is a sample of what I am asking:
Hyperlink displayed in the cell: "John Doe" <<this is the friendly_text
that's displayed in the cell>>
The actual Hyperlink is: mailto: (e-mail address removed)
I want the "mailto: (e-mail address removed)" to be displayed in the cell
As I said before; I know how to do one cell at a time but what about the
whole column at once? Is there a way to fix this when I have hundreds of
cells I need to change?