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

Thanks!

Try
=LEFT(B1,7) & LEFT(A1,1) & "

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


"Jody" wrote:

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

Thanks!

Hi,

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

So, all in one -

=LOWER(LEFT(B1,7) & LEFT(A1,1) & ")

Best wishes,

--
Milan Bortel

MCAS, MCTS
GOPAS Computer Training Center
Brno, Czech Republic


"Jacob Skaria" wrote:

Try
=LEFT(B1,7) & LEFT(A1,1) & "

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


"Jody" wrote:

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

Thanks!