Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exporting contacts to excel
I am exporting my contacts folder to an excel file. I then copy info from
this file into a fresh excel document. When I do this I am not able to "click on" to the email address in the excel file. When I go to the cell where the address is it looks okay but when I look in the formula box there is some sort of apostrophe ('). When I take it out (manually) I can then to the email address and send. I have hundreds of these ' to take out. How do I do this? |
#2
|
|||
|
|||
How about just using a helper column that inserts a hyperlink:
=hyperlink("mailto:" & a1) And drag down. Ipswich wrote: I am exporting my contacts folder to an excel file. I then copy info from this file into a fresh excel document. When I do this I am not able to "click on" to the email address in the excel file. When I go to the cell where the address is it looks okay but when I look in the formula box there is some sort of apostrophe ('). When I take it out (manually) I can then to the email address and send. I have hundreds of these ' to take out. How do I do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Exporting to Excel | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Exporting numbers into Excel | Excel Discussion (Misc queries) |