| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to parse a string with a date?
Hi,
Thanks for the help in advance. I have several cells with the date located at the end. However there are spaces at the end of the string of variable unknown length usually anywhere from 5-15 spaces. For example the string in quotes are "I need your help 12 JUN 2006 " "Thanks for your help 12 JUN 2006 " Someone earlier suggested using =Datevalue((Right((Cell#),11))) However this only works if the spaces were not there. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to parse a string with a date?
=DATEVALUE(RIGHT(TRIM(A1),11)) " wrote: Hi, Thanks for the help in advance. I have several cells with the date located at the end. However there are spaces at the end of the string of variable unknown length usually anywhere from 5-15 spaces. For example the string in quotes are "I need your help 12 JUN 2006 " "Thanks for your help 12 JUN 2006 " Someone earlier suggested using =Datevalue((Right((Cell#),11))) However this only works if the spaces were not there. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format issue | New Users to Excel | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
| Q: parse string | Excel Discussion (Misc queries) | |||
| Lookup the month in a date string 01/03/05 | Excel Worksheet Functions | |||
| How to convert string to a date | Excel Worksheet Functions | |||
Linear Mode
