On Jan 29, 8:57*pm, "Conan Kelly"
wrote:
Seemore,

1. *Make sure the file you want to change is active (you are working in it).
2. *Make sure the sheet that has the hyperlinks is active.
3. *Press the [Alt] + [F11] key combination to open the Microsoft Visual
Basic editor (VBE)
4. *If it is not already showing, press the [Ctrl] + G key combination to
open the Immediate window (usually it spans the lower part of the VBE).
5. *Paste that line of code (Columns("A:A").Hyperlinks.Delete) into the
Immediate window and press enter (make sure the blinking cursor is on the
same line as the code before you press enter).

Hopefully that will accomplish what you are trying to do.

HTH,

Conan

"Seemore" wrote in message

...
On Jan 29, 3:25 am, "Nigel" wrote:





Columns("A:A").Hyperlinks.Delete

--

Regards,
Nigel


"Seemore" wrote in message

...

I have an entire column of email addresses which are in ahyperlink
format. I want to convert thehyperlinkto the actual email address
text. How can I do that?- Hide quoted text -

- Show quoted text -

I appreciate the help. *I am unfortunately a novice when it comes to
this stuff and I don't understand what to do with the
Columns("A:A").Hyperlinks.Delete. *where do I type this in?- Hide quoted text -

- Show quoted text -

I appreciate the help. Still having problems though. I got the code
into the immediate box and hit enter but nothing seemed to happen. Is
the window supposed to close or somehow get saved? Also, how do I run
this? As a novice I really appreciate your help.