| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i convert a date into 3 seperate columns?
I have a spreadsheet with dates shown as DD.MM.YYYY in text in a single
column but I would like this to be represented as 3 seperate columns. One for day, one for month and one for year. Does anyone know a formula or command to do this? Many thanks, Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| First name, Last name in seperate columns | Excel Discussion (Misc queries) | |||
| how to seperate into columns? | Excel Worksheet Functions | |||
| Need to convert text string to seperate cells | Excel Worksheet Functions | |||
Threaded Mode
