Find date in a excel column

**iswariak** · 06-19-2009, 12:31 AM

Hi,

In excel, a column contains 2 dates in between the text. I want to extract these two dates and put in the next succedding columns.

For example: cell will contain

The user account was created on 5/2/2008 and the user is contract/temporary. The account will be expired on 5/3/2009

So I have to retrieve the dates 5/2/2008 and 5/3/2009

Is there any function / regular expression to find the dates?

Thanks,
Iswaria

**JBeaucaire** · 06-19-2009, 12:46 AM

This is one way, just to get you started. This just takes your sentence out of A4 and puts the values in A5 and A6...

Please Login or Register  to view this content.

**iswariak** · 06-19-2009, 02:03 AM

I have completed the same using VB regular expressions.

**iswariak** · 06-19-2009, 02:05 AM

Originally Posted by JBeaucaire

This is one way, just to get you started. This just takes your sentence out of A4 and puts the values in A5 and A6...

Please Login or Register  to view this content.

Thanks for your help!!!

**JBeaucaire** · 06-19-2009, 02:26 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

**venkat1926** · 06-19-2009, 02:45 AM

try this macro . your string is in A1 and the two dates are in a2 and a3.

Please Login or Register  to view this content.

**DonkeyOte** · 06-19-2009, 02:47 AM

I think RegExp is an elegant approach, would you care to share your solution iswariak ? I think other members would find it beneficial.

You may find morefunc.xll of interest, it contains a number of REGEXP functions.