Forum Discussion
How to sort numbers with a space in the one cell
Hi - Have been searching online but can't find the correct formula. Is there a way to sort numbers in order i.e. lowest to highest within one excel cell as per below when there is a space between val...
JMB17 Hi - Thanks for trying. I have the cell in A1. But neither formula worked and comes up with a value error.
Though I really think it would work, I don't have the sort function so can't confirm it. But, I can confirm the second one should work, provided you have those functions:
- It worked, There was a space after my last digit in the data cell that I was trying to sort. Is there something that can be added to the formula to ignore that space as I have over 1000 cells of data to sort with that space. Thanks for your help.