If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
E-Mail Hyperlinks in Excel
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. |
#3
|
|||
|
|||
E-Mail Hyperlinks in Excel
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. |
#4
|
|||
|
|||
E-Mail Hyperlinks in Excel
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 |
#5
|
|||
|
|||
E-Mail Hyperlinks in Excel
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 |
Thread Tools | |
Display Modes | |
|
|