How to sort data by number in ascending order - within specific ranges

[Marcos Miguel]

This is what I have:

CITY Total
London 5
London 3
London 4
London 1
London 2
NYC 40
NYC 30
NYC 50
NYC 70
NYC 60

This is the end result I need:

CITY Total
London 1
London 2
London 3
London 4
London 5
NYC 30
NYC 40
NYC 50
NYC 60
NYC 70

Does anyone know a formula that sorts the data like that? Thank you!

[guy038]

Hi, @marcos-miguel and All,

well…, just use the built-in N++ sort feature !!

So, select your text :

CITY Total
London 5
London 3
London 4
London 1
London 2
NYC 40
NYC 30
NYC 50
NYC 70
NYC 60

Use the Edit > Line Operations > Sort lines Lexicographically Ascending option

And you get your expected text :

CITY Total
London 1
London 2
London 3
London 4
London 5
NYC 30
NYC 40
NYC 50
NYC 60
NYC 70

Best regards,

guy038