Forum Discussion
Excel
Nov 18, 2021Iron Contributor
Question related to Sort
Hello Everyone, This is my data like - After sorting, it will come like this - I want to come like this : Person 1, Person 3, Person 4, Person 5, Person 101 So, what should ...
hansleroy
Nov 18, 2021Iron Contributor
Hi,
Strings (letter series) are sorted as strings, that is, alphabetically. I see two solutions:
- using leading 0 in the number
Person 001, Person 002 etc
- or use just numbers (without "Person ")
Kind regards
Hans
- ExcelNov 18, 2021Iron ContributorThank you for giving a solution sir.
Can you please explain example please?- hansleroyNov 18, 2021Iron ContributorI don't know what else I can explain...
You gave
Person
Person 1
Person 3
Person 101
Person 4
Person 5
Make that
Person
Person 001
Person 003
Person 101
Person 004
Person 005