spliting a cell into more cells

R

RowzeRiot

is it possible to split up a cell, if i have a date '11.12.09' and i want the
day, the month, and the year to be in seperate cells is it possible if so
how? and does it work if i want to do this for a whole collum of dates?
 
M

Mike H

Hi,

With your date in A1 put these in b1, c1 & d1 then select all 3 and drag down

=DAY(A1)
=MONTH(A1)
=YEAR(A1)

Mike
 
D

David Biddulph

If it is there as text, use Data/ Text to columns, and use the full stop as
delimiter.
If the 11.12.09 is a real date, use =DAY(A1) =MONTH(A1) and =YEAR(A1) and
copy down.
 

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

splitting a cell in to three 4
Spliting a cell 3
Spliting a cell with multiple entries into seperate rows 1
Is there any way to split contents of a cell into more cells. 2
Excel Vba to change displayed year automatically. 14
VBA Excel partial cell compare to another cell 0
Single Cell To more cells 1
Spliting a cell into two parts 2

Top