Quote Originally Posted by tkaplan
two options:
If you have first name and last name in two different columns (A and B) then in C you can put:
=CONCATENATE(A1,".",B1,"@test.com")

if the names are currently in one column, you can do:
=CONCATENATE(SUBSTITUTE(A2," ","."),"@test.com")

hope this helps.
Worked a treat, thank you very much

Just for reference, how does the formula work? I havent seen CONCATENATE or SUBSTITUTE make up a formula before

Once again, many thanks

Colin