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 exampleXX X01 XXXX X02 XXXX X03 XXAlso 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!
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!
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.
I used the last method, thanks for the help!
This thread is now locked and can not be replied to.
OnePlus 5 review
50 best online Adobe XD tutorials
iPad Pro 10.5in (2017) review
Comment connecter un MacBook à une TV ?
© Copyright 2017 IDG UK. All Rights Reserved.