Is it possible to sort numbers inside a cell that are separated by a comma. We have customers that call and provide the numbers for their jerseys in random order by size. Our print staff needs the number array in numerical order, so we have to order it for them manually. I can only find ways to sort by column and row, but not within a cell.
I've attached a sample of how data comes in and how we're trying to output it.
Thanks.
Hi,
I dont think what you are asking is possible to do inside a cell.
But there is a work around... You can use the "Text to column" from the data menu. Choose "delimited data" by "comma". This will seperate ech value inside the cell into a single one.
If you copy all rows with data and paste special (click transpose!) you will have the data bySize number in columns. You can now sort each column ascending.
Last edited by Portuga; 03-14-2008 at 11:18 AM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks