| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting comma into date text
If I have a column of dates that look like
OCT 10 2007 OCT 10 2007 OCT 08 2007 NOV 07 2007 How can I insert a comma after the Days before the year in order to make excel recognize all three parts as one date. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inserting comma into date text
This formula will give you the date value, but it will be in a different
cell. You could then copy the value back to the original cell. =DATEVALUE(LEFT(A1,6) & "," & RIGHT(A1,5)) Tom |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inserting comma into date text
Data Text to Columns Next Next select Date MDY
Format cells as: mmm dd, yyyy "RyanR8881" wrote: If I have a column of dates that look like OCT 10 2007 OCT 10 2007 OCT 08 2007 NOV 07 2007 How can I insert a comma after the Days before the year in order to make excel recognize all three parts as one date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| Locating the First Comma in a Text | Excel Worksheet Functions | |||
| Inserting a space after a comma | Excel Worksheet Functions | |||
| Change Text Imprt from TAB to Comma | Excel Discussion (Misc queries) | |||
| To only get all text after a comma | Excel Worksheet Functions | |||
Hybrid Mode
