| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
date
I have date in CSV as 9122005(09 Dec 2005) and 13122005(13 dec 2005)..
when I do text to column.. the only fields that get converted are 13122005 ( the ones with 2 digits date... any solution? |
|
#2
|
|||
|
|||
|
date
Use two steps assuming that your two values are in A1 and A2.
In B1 enter: =IF(LEN(A1)=8,A1,0&A1) and copy down This will make the dates all 8 digits long by putting a zero in the front if needed. In C1 enter: =RIGHT(B1,4) for the year In D1 enter: =MID(B1,3,2) for the month In E1 enter: =LEFT(B1,2) for the day -- Gary's Student "flow23" wrote: I have date in CSV as 9122005(09 Dec 2005) and 13122005(13 dec 2005).. when I do text to column.. the only fields that get converted are 13122005 ( the ones with 2 digits date... any solution? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| search for latest date | Excel Worksheet Functions | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Linear Mode
