using the delimited function

R

Richard Mahan Sr

I have an example where a date is listed as: 01/17/2005 and would like to
be able to display the information into separate columns. so that I can use
the sort data function in a desending order. Is this possible and if so, how
to do it? thanks
 
D

David McRitchie

Hi Richard,
A bit ambiguous but if you were trying to use text to column that
won't work, and this would.

A1: 01/17/2005 representing a format of mm/dd/yyyy
C1: =Year(a1)
D1 =Month(a1)
E1: =day(A1)

It is refreshing to see the word separate spelled correctly
in a newsgroup.
 
D

Dave Peterson

If it's a real date, you can use three separate formulas:

=year(a1)
=month(a1)
=day(a1)

But if they're real dates, you should be able to sort in descending order of the
date.
 
G

Gord Dibben

Richard

You can do this if you change the data format at step 3.

Data>Text to Columns>Delimited>Next>By>Other "/" >Next>Column Data Format>Text
and Finish.

The question I have is.........why won't the dates sort in descending order if
they are real dates?


Gord Dibben Excel MVP
 
Top