How do i convert a date into 3 seperate columns?

T

Tone

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
 
M

Mike H

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
 
N

nr

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
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert text date to mmddyyy date 2
accepting most recent date across columns 10
Data to Date conversion with multiple formats 1
Spliting a cell with multiple entries into seperate rows 1
how to save a single column as a seperate file 2
counting blank cells within two columns 2
Convert 3 columns into 1, as text. 2
3 cells into 1 date? 3

Top