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

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!
 
J

Jacob Skaria

What happened to your previous post?

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to take partial information from two columns and then add t 2
Find the first letter in a cell 5
Capitalisation of First Letter in Name 4
Access to split First and Last name 0
how to arrange list by first or last name 1
cell reference 1
Merge address in XL to Word letter template 1
FIRST letter of the names, mi and the whole last name. 11

Top