Thanks for your help.

"Per Jessen" wrote in message
...
Hi

=LEFT(C2,1)&LEFT(D2,1)&LEFT(E2,1)&LEFT(F2,5)

I assume you want 1st 5 digits in DOB.

Regards,
Per

"Michael Styles" skrev i meddelelsen
...
Here is my Data:

A B C D E F
GRADE Teacher LN FN MN DOB
KK Cain FlintstoneFred Bam-Bam02/22/04

I need to concatenate LN, 1st letter of FN, 1st letter of MN, and 1st 4
digits of DOB in MM/DD format.

Can anyone help? All the nesting is not working well in my brain so
early this morning.

Thanks in Advance.

Michael S.