- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2007 August
- Sorting numbers in a row from small to large

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.

- RE: Sorting numbers in a row from small to large posted by barnabel on Fri, 10 Aug 2007
- RE: Sorting numbers in a row from small to large posted by JLatham on Fri, 10 Aug 2007