Sorting

  • Thread starter Thread starter joey5
  • Start date Start date
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:
 
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).
 
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)
 
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...
 
Back
Top