Hi,

I am at a lost on how to do this and sorry if I do not get it straight away, anyhow here goes:

Cell Value (This is how it is spaced out within the cell) = DTL 5123456 Change 2000012010030920130206 51234567 Platinum

I am wanting to find a formula that will:
1. Separate each data into a single cell (e.g A1=DTL 5123456, A2=Change, A3=2000...etc)
2. Retrieve the date(s) within the large 2000...#

Any help will be greatly appreciated, apologies if I have not explained well.

Cheers