extract data from a cell
 

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

extract data from a cell
 

=DATEVALUE(LEFT(C2,2)&"/"&MID(C2,6,2)&"/"&MID(C2,8,2))
--
- K Dales


"Jim Dunlap" wrote:

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

extract data from a cell
 

Jim

Try this:

=VALUE(LEFT(A4,2)&"/"&MID(A4,6,2)&"/"&MID(A4,8,2))

Actaully this do not wotk on my PC as I am in the UK and the default format
is dd-mm-yy whereas for US it would be mm-dd-yy (as far as I know).

Try it out...see how it goes...

Alex

"Jim Dunlap" wrote:

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