formulate email address based on last name & first letter of first

  • Thread starter Thread starter Jody
  • Start date Start date
J

Jody

I need to formulate an email address for hundreds of employees. The email
address is the first 7 letters of the name and first letter of first name
followed by @....com

Is there a formula that will take the last name column (only up to the first
7 letters), the first letter of the first name column and add the @.....com
to the end?

Any help would be greatly appreciated!

Thanks!
 
What happened to your previous post?

=LEFT(B1,7) & LEFT(A1,1) & "@dexterschools.org"

If this post helps click Yes
 
Back
Top