| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I grab the date from a text string?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I grab the date from a text string?
Hi, Maybe you can use something along the line of: (String in A4) =DATEVALUE(RIGHT((A4),11)) Regards, Bondi |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I grab the date from a text string?
If there is never any digit in the string before the date substring at
the end: =REPLACE(A2,1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2& "0123456789"))-1,"")+0 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| How do I extract a date as text not the 1900 reference number | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| How to convert string to a date | Excel Worksheet Functions | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
