| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting a cell in to three
i have a list of dates 'DD,MM,YYYY' and i need to split the cells so that in
a new collum it has 'DD' 'MM' 'YYYY' i can understand how to put the day and year into a new collum =left(A1,2) & =right(A1,4) but i cant work out how to seperate the middle should i delete the commas? thanks in advance Rose |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting a cell | New Users to Excel | |||
| splitting cell | Excel Worksheet Functions | |||
| splitting a cell | Excel Discussion (Misc queries) | |||
| Splitting a cell into two... | Excel Discussion (Misc queries) | |||
| Splitting a Cell | Excel Worksheet Functions | |||
Threaded Mode
