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

Problem with SET & REF function 0
Merging from an Excel file with graphics 1
Improving Macro That Keeps First Letter 0
Keep First Letters, with exceptions 0
Outlook Backup issues 0
I need to take partial information from two columns and then add t 2
VBA - exporting serial letters to single documents 0
Word isn't capitalizing the first word of each sentence 2

Top