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!