Sorting numbers in a row from small to large

Giganews Newsgroups
Subject: Sorting numbers in a row from small to large
Posted by:  Peter Herman
Date: Fri, 10 Aug 2007

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.

Replies