Combine2 Name Colums to Create emails

[alu]

Hi all,

Column A is full of first names
Column B is full of surnames

I would like to combine column A and column B into a new column then add @companyname.co.uk after all of them.

e.g

A B C
Tom Jones tom.jones@company.co.uk
Sam Connor sam.connor@company.co.uk
Michelle Lovemunch michelle.lovemunch@company.co.uk

I dont know where to start with this one, thank you all in advance

[alu]

D'oh!

pretty easy actually, for the record just added a new column with @company.co.uk

the in another column just concatinated them with

=CONCATENATE(B2,".",C2,D2)

:p

[mdmackillop]

in C1 enter =A1 & "." & B1 & "@companyname.co.uk" and copy down