E-Mail Hyperlinks in Excel

If an e-mail address is entered in a cell, Excel
automatically creates a hyperlink. How can this automatic
hyperlink creation feature be disabled?

(After entry, the hyperlink can be deleted, but I do not
want it created in the first place.)

Thanks for any help.

Ray

You will lose the hyperlink if you copy a General formatted cell and use
Format Painter to reformat. This means you could do a column at a time.

Andy.

"Ray" wrote in message
...
If an e-mail address is entered in a cell, Excel
automatically creates a hyperlink. How can this automatic
hyperlink creation feature be disabled?

(After entry, the hyperlink can be deleted, but I do not
want it created in the first place.)

Thanks for any help.

XL2002 has that option. For ways to automatically eliminate
hyperlinks, see

http://www.mcgimpsey.com/excel/nohyperlinks.html


In article ,
"Ray" wrote:

If an e-mail address is entered in a cell, Excel
automatically creates a hyperlink. How can this automatic
hyperlink creation feature be disabled?

(After entry, the hyperlink can be deleted, but I do not
want it created in the first place.)

Thanks for any help.

I have a different requirement. I have 1000 email names and embedded
hyperlinks in Excel that I pasted from a webpage I want to import into
Outlook somehow. But the Copy paste does not allow pasting the hyperlink


How can I extract only the email hyperlinks?
Other than one at a time.

I thought of using Macro Recorder but that failed to use relative addressing
like the old win3.1 macro recorder once did.


Tony


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.518 / Virus Database: 316 - Release Date: 11-Sep-03

You could use a userdefined function that extracts the link/email address:

Option Explicit
Function GetLink(Rng As Range) As String
Application.Volatile

Set Rng = Rng(1)

If Rng.Hyperlinks.Count = 0 Then
GetLink = ""
Else
GetLink = Rng.Hyperlinks(1).Address
End If
End Function

So if cell A1 contained a link to
then =getlink(a1) would return this:

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

TONY wrote:

I have a different requirement. I have 1000 email names and embedded
hyperlinks in Excel that I pasted from a webpage I want to import into
Outlook somehow. But the Copy paste does not allow pasting the hyperlink


How can I extract only the email hyperlinks?
Other than one at a time.

I thought of using Macro Recorder but that failed to use relative addressing
like the old win3.1 macro recorder once did.

Tony

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.518 / Virus Database: 316 - Release Date: 11-Sep-03

--

Dave Peterson