View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Styles[_2_] Michael Styles[_2_] is offline
external usenet poster
 
Posts: 3
Default Need Help With Writing Concatenate Function

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.