Question related to Sort

[Excel]

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 i write formula which sort in ascending order Person 1, Person 3, Person 4, Person 5, Person 101?

Please help..??

[#2]

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

[#3]

Thank you for giving a solution sir.
Can you please explain example please?

[#4]

@Excel 

In your example "Person 1" is in cell A2. You can manually enter "1" in cell B2 and then flashfill range B2:B6. Flashfill can be done by pressing ctrl+E when cursor is in cell B3 in this example. 

Then you can apply sort of range A2:B6 in ascending order by column B as shown in attached pdf file.

[#5]

I 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