help sorting with commas

  • Thread starter Thread starter arkum
  • Start date Start date
A

arkum

Yes.
Each cell contains anywhere from 1 to 12 numbers seperated by commas.
 
If you just sort normally, how does the result differ from what you want? I
notice that you want the item with 5 parts (an "e" term) to come before one
with only 4 parts. Normal sorting would put them the other way around.

If the result isn't what's wanted, then you'll have to separate the data into
separate columns (use Data/Text to Columns, Delimited, with Comma) and sort
the individual columns.
 

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

Commas in Excel 3
Seperating information in a cell 1
.csv Commas ? 2
csv files 1
contents of cells to rows 6
Add a comma following a series of numbers 1
For Claus From OP: 1
Creating an email list 2

Back
Top