This should be easy but somehow it just escapes me how to do this. I need to
extract a birthdate from a text string. For example, the text string
12VEC1461001 parses left to right into 12= month, VEC = not required, 14 =
day, 61= year, 001 = not required.

Column/Row C2 is 12VEC1461. In Column/Row D2 I need 121461 in date format
12/14/61.

Thanks, Jim