Re: convert hyperlink to email address

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Seemore <langcorey@xxxxxxxxxxx>
Date: Tue, 29 Jan 2008 17:26:25 -0800 (PST)

On Jan 29, 3:25 am, "Nigel" <nigel-...@xxxxxxxxxxxxxxxxx> wrote:

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

--

Regards,
Nigel
nigelnos...@xxxxxxxxx

"Seemore" <langco...@xxxxxxxxxxx> wrote in message

news:38ff19d3-42d0-4be1-8035-745e218348d6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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?
.

Follow-Ups:
- Re: convert hyperlink to email address
  - From: Conan Kelly

References:
- convert hyperlink to email address
  - From: Seemore

Prev by Date: Re: Essbase Add-in
Next by Date: what is wrong with my fun ,thanks
Previous by thread: convert hyperlink to email address
Next by thread: Re: convert hyperlink to email address
Index(es):
- Date
- Thread