Function help

[Guest]

Column A - First Name
Column B - Last name

I would like to creat a formula that would take the first
character of col. A + col. B + "@example.com"

So
A B C
Tom Smith (e-mail address removed)

Any suggestions, i can't figure it out.

Thanks,

 

[drabbacs]

Try
= concatenate(lower(left(A2,1)),B2,"@example.com")

 

[Peo Sjoblom]

=LOWER(LEFT(A1)&B1)&"@example.com"

copy down and, copy the whole range and paste special as values in place