Function help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
=LOWER(LEFT(A1)&B1)&"@example.com"

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