Sorting data by a value within a number - excel

  ShorN 11:00 12 Apr 2006
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 2006

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 2006

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 2006

I used the last method, thanks for the help!

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

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?