I need to take partial information from two columns and then add t

J

Jody

I have first name and last name columns in an excel spreadsheet. I need to
form a new column combining up to the first 7 letters of last name and the
first letter of first name and follow all by @dexterschools.org to compile
email addresses.

Can anyone help me with the formula for this?

Example:

First Name Last Name Email Address

Jody Malbon (e-mail address removed)

Thanks!
 
J

Jacob Skaria

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

If this post helps click Yes
 
M

Milan Bortel

Hi,

think about using function LOWER (converts all letters to lowercase)

So, all in one ->

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

Best wishes,

--
Milan Bortel

MCAS, MCTS
GOPAS Computer Training Center
Brno, Czech Republic
 

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

formulate email address based on last name & first letter of first 1
How do I separate first and last names into two columns? 2
Excel Excel - Two Database Formula extraction? 3
Find partial match from column A,B and fill partial match in C? 4
How Do I Add Commas To Columns And Remove Spaces In Excel?? 3
Move two columns to four columns 2
Search two columns in list for first and last name and return Id 4
concatenate 2 columns (A2+B2) and compare for duplicates 3

Top