How can I sort the contents of one cell
Thank you for your help. I di step one which worked great but when I did step
two the first number in the column is left justify and the other numbers are
right. When I sort the left number is always on top and the other numbers do
sort. Also, will I be able to use this method with 1400 rows?
Thanks again..
"Gary''s Student" wrote:
1. use Text to columns to copy the cell into a row of single items
2. use copy and pastespecial transpose to put the row into a column
3. sort the column
4. use the CONCATENATE function to re-combine the values
--
Gary''s Student - gsnu200860
"GLeeds" wrote:
I want to sort a cell with text numbers. Example. Cell B3 equals 12 54 36 01
17 23 07 and I would like to sort it low to high. 01 07 12 17 23 36 54. Each
number is two digits with a space between each number.
|