How to extract characters from alphanumeric excel cell?

Good Morning,

I am trying to extract out any instances of dates in the below examples. There are usually characters in between the dates and the dates can be in different places as well. The dates are also in different formats but most are six digits. XXXXXX. Sometimes five. I was thinking to using LEN to separate the five digit and six digit cells. I would like to be able to pull out these dates for comparison. I would prefer a formula but if necessary, I can go the macro route. Sometimes there are other numbers in the cells, which make the pulling of the dates more difficult. The common date theme is the number "11" since these are all 2011 dates.

% AB CDEFGHK 11711

% ABCD AB ABCDEFG ABCDE AB FHK 11291
%,$12.34 110311DC/ABC
%082911 277 ABCDEFGH
%ABC DEF GH74 HIJ ABCDEFGH 112311


Thank you,
Adam

This question is also posted at this site:
http://answers.microsoft.com/en-us/o...1-16bde322b9df

Welcome to the forum.
This forum is moderated so please click the Forum Rules link at the top of the page and take a few minutes read the rules.
You'll see that there's rule pertaining to posting the same question to multiple websites. We insist that you provide a link to the other websites so we can monitor progress at them and stop attempting to help you once your issue is resolved.

Since you're new, I'll post the link for you...this time