Thread
:
How do I grab the date from a text string?
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Aladin Akyurek
Posts: n/a
How do I grab the date from a text string?
I'd go with Bondi's suggestion, unless you have substrings like 4Jan06
or 2 aug 99.
wrote:
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
Reply With Quote