Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
daleman101
 
Posts: n/a
Default copy/convert column email addresses Hyperlink "mailto:" excel97

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   Report Post  
Michael
 
Posts: n/a
Default copy/convert column email addresses Hyperlink "mailto:" excel97

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   Report Post  
Anne Troy
 
Posts: n/a
Default copy/convert column email addresses Hyperlink "mailto:" excel97

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   Report Post  
Daleman101
 
Posts: n/a
Default copy/convert column email addresses Hyperlink "mailto:" excel9

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
Using CONCATENATE function to create email addresses from a list Almamba Excel Worksheet Functions 2 January 23rd 05 09:10 PM
Convert entire columns of text email addresses to hyperlinks TSA Excel Worksheet Functions 2 January 20th 05 04:31 PM
How do you sort a column of email addresses by domain name in Exc. Andy R Excel Discussion (Misc queries) 5 December 10th 04 09:26 PM
Can I create a dynamic email address in Excels hyperlink? ibrettferguson Excel Worksheet Functions 1 November 8th 04 02:24 AM


All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"