[ms office - 2010] Formula Help on Excel

[Tesla]

I have a list of cells for first name, a list for second name, in the last one i want it to bring across the details from those two sets and put it in an email

 

eg

 

firstname (a2)

lastname (b2)

"firstname"."lastname"@school.sch.uk

 

I cannae remember the trick for it. Any pointers?

[sparkeh]

=a2&"."&b2&"@school.sch.uk"

[Tesla]

=a2&"."&b2&"@school.sch.uk"

Beautiful, thanks! I blame Easter brain....