Assuming your DOB column contains *real* Excel dates (and not just text that
looks like a date)...

=C2&LEFT(D2)&LEFT(E2)&TEXT(F2,"mm/dd")

And this formula will be copied down through blank rows...

=C2&LEFT(D2)&LEFT(E2)&IF(F2="","",TEXT(F2,"mm/dd"))

--
Rick (MVP - Excel)


"Michael Styles" wrote in message
...
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.