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.