| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
