| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide date into separate columns
It depends on if you want to keep the original date and just parse the year
from it, if so it won't work since text to columns will split it into 3 columns, the OP's subject maybe sounds like that is what she wanted but the body of here message might be interpreted to get the year -- Regards, Peo Sjoblom (No private emails please) "wjohnson" wrote in message ... easiest way is to got Menu Bar - Select "DATA" - "TEXT TO COLUMNS" and then put two dividers where you want the text to split and follow the direction on the pop-up menu -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.hightechtalks.com/m390 View this thread: http://www.hightechtalks.com/t2306725 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I concatenate two columns when one is in date format? | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| How to compare the lists in two columns & separate odd one ? | Excel Discussion (Misc queries) | |||
| split a single column into 2 separate columns | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Threaded Mode
