Jan 22 2021 01:43 PM - edited Jan 22 2021 11:40 PM
Hi,
I was wondering if anyone could help. For some reason my excel will not sort my columns low to high. it skips from 1 to 10 and does not include 2, 3 ,4 etc. See the attached, I have read other posts and tried the CLEAN function but to no avail. Does anyone have any suggestions?
Any help would be greatly appreciated!
Jan 22 2021 11:21 PM
@Gav89 You seem to be sorting texts, so the sorting makes perfect sense. A text like "10 A" comes before a text like "2 X".
Jan 23 2021 07:32 AM
Hi, thanks for the response. What i'm trying to do is have both the numbers and the letters in sequential order. So: 1A, 1B, 1E 2C, 2D etc. @Riny_van_Eekelen
Jan 23 2021 07:42 AM
@Gav89 I understand, but 1A, 10A and 2B are recognised as texts, not numbers. So, when you sort them they get sorted as text in that order. You could use 001A, 002B and 010A. Then the sorting will work as expected. Otherwise, split the numbers from the characters. and Sort numbers first, then by character.