Hi
I have a column (Column T) with a list of different names in it (For example - Joe Bloggs) i need the cell along side it to be his email address (Columns U)
Is there a formula that would see the name then add a dot between the first and last name and the add @h-tmail.com
Email Capture.PNG
Bookmarks