extract data from a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top