Need Help With Writing Concatenate Function
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.
|