Forum menu
I have a column of names which are in the format [i]firstname.surname[/i]
Is there a quick way to add [i]@domainname.com[/i] 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 [b]firstname.surname[/b] in cell A1
in B1 for example you could write [b]=A1&"@domainname.com"[/b]
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 [i]=(A1&"@domainname.com")[/i] . 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.