I have a column of names which are in the format firstname.surname

Is there a quick way to add @domainname.com onto the end to create a valid email address?

I tried using a wildcard character find and replace i.e. find ?.? and replace with ?.?@domainname.com but that didn’t work.

any ideas?

if firstname.surname in cell A1

in B1 for example you could write =A1&”@domainname.com”

if you didn’t want any formula in the cell, you can always do a cut and Paste Special afterwards to replace it with the value only.

Do a =(A1&”@domainname.com”) . Where A1 is the cell with the first.last data. Copy it down all the cells you need.

blimey, that was quick! – ta, chaps – saved me a big headache.

May your wheels spin freely this weekend!

I hope you’re not sending out lots of penis enlargement offer emails. I’ve not found one yet that works.