E-mail addresses in Excel

Hi,

I am trying to insert e-mail addresses into a column using the forename and surname from other columns but am not sure how to tell Excel to use the names and add the domain name itself

For example, if I have Joe Bloggs in Column A, Row 1 and his e-mail address is joe.bloggs@test.com and I have John Smith in Column A Row 2, how would I tell Excel to use the info from column A (Joe Bloggs) and add @test.com and then put that info into Column B

Hope that makes sense

Thanks in advance for any help.

Colin

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.

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