Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to convert a column of e-mail addresses to hyperlink "mailto:".
I am still using Excel 97 and, so far, cannot find a way to get it done without having to type each address again, cell by cell, in the "Insert Hyperlink" drop-down. The same addresses are in Word 97 in a table and the "mailto:" hyperlink works well there. I have tried copying from Word to Excel but it looses the hyperlink on transfer. Can anybody, please, come up with a simple answer to this? About 300 addresses are involved! |
#2
![]() |
|||
|
|||
![]()
In 2003 you can select the cell with the hyperlink, press F2 and Enter and it
will automatically insert the hyperlink. I'm not sure about 97 though. HTH -- Sincerely, Michael Colvin "daleman101" wrote: I am trying to convert a column of e-mail addresses to hyperlink "mailto:". I am still using Excel 97 and, so far, cannot find a way to get it done without having to type each address again, cell by cell, in the "Insert Hyperlink" drop-down. The same addresses are in Word 97 in a table and the "mailto:" hyperlink works well there. I have tried copying from Word to Excel but it looses the hyperlink on transfer. Can anybody, please, come up with a simple answer to this? About 300 addresses are involved! |
#3
![]() |
|||
|
|||
![]()
Try this, Daleman: =HYPERLINK("mailto: "&A1)
************ Anne Troy www.OfficeArticles.com "daleman101" wrote in message ... I am trying to convert a column of e-mail addresses to hyperlink "mailto:". I am still using Excel 97 and, so far, cannot find a way to get it done without having to type each address again, cell by cell, in the "Insert Hyperlink" drop-down. The same addresses are in Word 97 in a table and the "mailto:" hyperlink works well there. I have tried copying from Word to Excel but it looses the hyperlink on transfer. Can anybody, please, come up with a simple answer to this? About 300 addresses are involved! |
#4
![]() |
|||
|
|||
![]()
Thank you Anne Troy. It works - yipee. Just an observation; the cell looks
different by this method i.e. it shows "mailto:" in the cell whereas when using the "Insert hyperlink" method only the address shows. In the Insert method the cell also shows as hyperlink in Properties - but not so by this solution. This of course is not a problem, just an observation! Again, many thanks. Daleman101 "Anne Troy" wrote: Try this, Daleman: =HYPERLINK("mailto: "&A1) ************ Anne Troy www.OfficeArticles.com "daleman101" wrote in message ... I am trying to convert a column of e-mail addresses to hyperlink "mailto:". I am still using Excel 97 and, so far, cannot find a way to get it done without having to type each address again, cell by cell, in the "Insert Hyperlink" drop-down. The same addresses are in Word 97 in a table and the "mailto:" hyperlink works well there. I have tried copying from Word to Excel but it looses the hyperlink on transfer. Can anybody, please, come up with a simple answer to this? About 300 addresses are involved! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
Convert entire columns of text email addresses to hyperlinks | Excel Worksheet Functions | |||
How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) | |||
Can I create a dynamic email address in Excels hyperlink? | Excel Worksheet Functions |