Extract date from string

I have this string........actually its the contents of a cell..........I want to extract the date part of this string and then save it back onto itself.

i am enclosing a file with the example strings.

exactly what i was looking for.....thanks.

Here is the code i ended up with. I combined code from several different threads i have posted...........i keep learning about how to more efficiently do things........this code is cool because it puts values into array efficiently and then extracts them from the array very efficiently.

Please Login or Register  to view this content.

Just thought i would share.

one question i did have about the array that someone might answer is.........why is the array two dimensional........not sure why the creator of the code did it this way but it works.

ok, that is just too cool. but what about if the number of rows in col A is variable and could be more than 100?

very cool !

thanks! Had a few questions.

1) What is c00?

2) what is this doing exactly?

Please Login or Register  to view this content.