Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split date in cell into 2 separate cells
I have Oct 4 in cell K1 (the cell is custom formatted using mmm d). I would
like cell L1 to display Oct and M1 to display 4. I tried using the left and right commands but they give me 389 and 94. How can I do this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split date in cell into 2 separate cells
=TEXT(K1,"mmm") will return Oct
=DAY(K1) will return 4 Vaya con Dios, Chuck, CABGx3 "Jambruins" wrote: I have Oct 4 in cell K1 (the cell is custom formatted using mmm d). I would like cell L1 to display Oct and M1 to display 4. I tried using the left and right commands but they give me 389 and 94. How can I do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I split 1 cell into 2 cells in Excel? | Excel Discussion (Misc queries) | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
split combined Time Date cells | Excel Discussion (Misc queries) |