Forum Discussion

Gav89's avatar
Gav89
Copper Contributor
Jan 22, 2021

Column will not sort/filter low to high

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!

excel
office 365

3 Replies

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jan 23, 2021

    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".

    • Gav89's avatar
      Gav89
      Copper Contributor
      Jan 23, 2021

      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 

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Jan 23, 2021

        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.

Resources