How do I grab the date from a text string?
Hi!
"I need your help 2 jun 2006"
"I have no idea what I'm doing 2 jun 2006"
Are the quotes part of the string?
If not:
=DATEVALUE(SUBSTITUTE(A1,LEFT(A1,MIN(SEARCH({0,1,2 ,3,4,5,6,7,8,9},A1&"0123456789"))-1),""))
Biff
wrote in message
oups.com...
Hi,
How would I grab the date out of a string where the date text is
located at the end of the string? The string is of variable length. IE
"I need your help 2 jun 2006"
"I have no idea what I'm doing 2 jun 2006"
I'll need to convert the date string into a integer date value.
Thanks for your help
|