I need to take partial information from two columns and th..

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 malbonj.TakeThisOut@dexterschools.org

Thanks!

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

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 malbonj DeleteThis @dexterschools.org
>
> Thanks!