| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i convert a date into 3 seperate columns?
Try,
Data|Text to Coilumns Delimited Next Enter your delimiter in the box (.)? Click finish You may be making problems for your self if you want them to continue to be dates Mike "Tone" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i convert a date into 3 seperate columns?
On Jul 24, 4:38 am, Tone wrote:
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 Why not use the DAY, MONTH, and YEAR functions, in three new columns. You could hide the original date column if you don't want to see it. |
| Reply |
| 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 | |||
Hybrid Mode
