Aerodynamix
08-09-2013, 06:52 PM
I am trying to take a name in a cell & convert it into an email address hyperlink (example attached)
The steps I have taken so far are:
1) In cell A1 of the attached example sheet the name appears with a space between the firstname & lastname.
2) In cell B1 I am using the SUBSTITUTE formula to remove the space between the first name & lastname and replace it with a period (.).
3) In cell C1 I am taking the contents from cell B1 & adding "@xyz.com" to the end of it
4) I then try to show the contents of C1 in D1 but what I am actually seeing is John.Doe@xyz.com in the cell itself but the formula bar is displaying "=C1" making it useless to me.
I wouldn't be the slightest bit surprised if there is a far easier way of achieving this and any help is greatly appreciated
1121
The steps I have taken so far are:
1) In cell A1 of the attached example sheet the name appears with a space between the firstname & lastname.
2) In cell B1 I am using the SUBSTITUTE formula to remove the space between the first name & lastname and replace it with a period (.).
3) In cell C1 I am taking the contents from cell B1 & adding "@xyz.com" to the end of it
4) I then try to show the contents of C1 in D1 but what I am actually seeing is John.Doe@xyz.com in the cell itself but the formula bar is displaying "=C1" making it useless to me.
I wouldn't be the slightest bit surprised if there is a far easier way of achieving this and any help is greatly appreciated
1121