Converting text to an email address hyperlink

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

Attachment 1121

I think I've solved this one. It's always the way... as soon as you post asking for help, the answer appears as if by magic.

It seems that using the HYPERLINK/Mailto function works perfectly.

Attachment 1122

Thanks for sharing the solution !