View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter Herman Peter Herman is offline
external usenet poster
 
Posts: 10
Default Sorting numbers in a row from small to large

Hi there,
I have a column of numbers separated by commas that is about 45,000 rows
long. I would like to sort the numbers in each individual row from small to
large.
In other words my data looks like this:

column A
17,1,36,98,62
56,94,12,24
and so on...all the way down and I would like it to look like this:

Column A
1,17,36,62,98
12,24,56,94

Thanks to anyone who helps me.