Forum Discussion
Question related to sort letters and numbers
Hello Everyone, I have a Data like - After sorting, it come Person 1, Person 101, Person 3, Person 4 and Person 5 like - It will not sort ascending order like Person 1, Perso...
You may add helper columns extracting numbers only and sort range by it.
- How can we do it sir?
Slightly depends on your Excel version and actual data.
Helper column could be added as
when select both and Data -> Sort. Result is
