Breaking down Unique customer code.

Hi all,

I have all my customers stored in an unique customer code which looks like
L-F-12/10/1967-M, this is First name-Surname-DOB-Gender.

This was going great guns, until someone asked me a few questions like how many customers are male & Female.

Is there a way I can break this or extract the DOB into one cell and the Gender into another cell?

Thanks

If they all end with YYYY-G then

DOB =MID(A1,LEN(A1)-5,4)

*** = RIGHT (A1,1)