| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to date
Try this
=--MID(SUBSTITUTE(A1,".",""),5,99) Format cell as m/dd/yy hh:mm "Arun2902" wrote: Hi, Hope someone can help me with this. I am trying to convert "Wed. Sep. 20, 2006 14:16" into a format recognized by excel (9/30/06 14:16). Have tried to extract and collate the data using "=CONCATENATE(VALUE(RIGHT(LEFT(B3,12),2))," ",RIGHT(LEFT(B3,8),3)," ",RIGHT(LEFT(B3,18),4)," ",RIGHT(B3,5))", but all my efforts are in vain when I try to convert it to a date and time format recognized by excel. The lenght of the text that I'm trying to convert is exactly 24 characters. Hope someone can help me with this. Thanks Arun |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| turn off convert text to date (i.e. 4-9 to April 9, 2006) | Excel Worksheet Functions | |||
| How do I grab the date from a text string? | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Macro to convert text to date | Excel Worksheet Functions | |||
| EXTRACT TEXT FROM A DATE | Excel Worksheet Functions | |||
Threaded Mode
