Sorting data by a value within a number - excel

  ShorN 11:00 12 Apr 06
Locked

Hi,
Looking for some assistance.

Have a column of data and each row contains a unique id such as "XX XXX XX" (where each X represents a number)

I want to sort this by the 4th and 5th numbers.
For example

XX X01 XX
XX X02 XX
XX X03 XX

Also in the next column is relevant data to that ID so that would need to be kept in the same row when it is sorted.

Any help would be really appreciated!
Thanks!

  John B 11:16 12 Apr 06

Probably too fiddly but you could copy and paste to a new column and use Data, text to columns, fixed width, to split the number into the desired 'bits' and sort on that?

Keep a copy first!

  stlucia 12:50 12 Apr 06

If you create a new cell B1 with the formula =MID(A1,5,2) in it, it will return the 5th and 6th character of the string that's in A1 (i.e. "01" from "XX X01 XX"). Then you can sort the whole lot on column B.

  ShorN 14:04 13 Apr 06

I used the last method, thanks for the help!

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…