Hi,
I have a column with worker id eg 1234. Then I need a column with their email address which is 1234@company.com. Is there a formula that will copy the cell (1234) and automatically add the text at the end?
Also is there a way to make this formula a mailto? As excel will not read a formula as a hyperlink?
Finally I cannot search this forum, when I click on the GO button with a search topic entered it stays on search.php, any ideas?
Thanks in advance.
JP
You can concatenate like this
=A1&"@company.com"
I don't think you can make it into a mailto but you can use a column of addresses for a mail merge.
Ed
_____________________________
Always learning, but never enough!
_____________________________
Thankyou EdMac,
With your help I have nearly managed both parts. I have created this formula:
=IF($A1>0,HYPERLINK("mailto:"&$A1&"@company.com"),"")
This works but now has a mailto: in front of the email address. Is there anyway this can be removed whilst retaining the mailto function?
Thanks,
JP
Last edited by jpruffle; 07-01-2008 at 06:58 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks