| 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 |
| 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) | |||
Threaded Mode
