Sorting

J

joey5

I am trying to sort column
1-C-2
5-B-1
10-A-6
How can I sort and get 1-C-2 to show before 10-A-6. 10 is sorting ahead
of 1
Thanks
joey :rolleyes: :rolleyes:
 
D

Dave Peterson

I'd insert 3 additional columns to the right of that column.

Then select your column and do:
data|text to columns
choose delimited (by dash)
and plop it into those 3 new columns.

Then select your entire range and sort on those three "helper" columns.

Delete them when you're done (if you want).
 
B

Bob Phillips

Be careful, Text to Columns destroys the original data so copy column A to
column B first, and split that column.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Dave Peterson

There's an option on the Step 3 (of 3) to specify the destination cell so that
you can avoid overwriting that existing data.

(Heck, it doesn't have to even be adjacent to the original data--I just like to
put it there so I can see it easily.)

Bob said:
Be careful, Text to Columns destroys the original data so copy column A to
column B first, and split that column.

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top