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