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) & "

If this post helps click Yes
---------------
Jacob Skaria


"Jody" wrote:

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!