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...
With permission from everyone, even if I still think that a file (without the syllable data) can present a clear picture for everyone, I now add a quick and easy solution.
Mark data (incl. Blank lines) - auto filter - do not show empty
then sort the same marking and then auto-filter off.
Without formula 🙂
Is just a thought, if it suits you I'll be happy. If it doesn't fit, just ignore it.
Nikolino
Mark data (incl. Blank lines) - auto filter - do not show empty
then sort the same marking and then auto-filter off.
Without formula 🙂
Is just a thought, if it suits you I'll be happy. If it doesn't fit, just ignore it.
Nikolino