Column will not sort/filter low to high

%3CLINGO-SUB%20id%3D%22lingo-sub-2088646%22%20slang%3D%22en-US%22%3EColumn%20will%20not%20sort%2Ffilter%20low%20to%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2088646%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20anyone%20could%20help.%20For%20some%20reason%20my%20excel%20will%20not%20sort%20my%20columns%20low%20to%20high.%20it%20skips%20from%201%20to%2010%20and%20does%20not%20include%202%2C%203%20%2C4%20etc.%20See%20the%20attached%2C%20I%20have%20read%20other%20posts%20and%20tried%20the%20CLEAN%20function%20but%20to%20no%20avail.%20Does%20anyone%20have%20any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22del.jpg%22%20style%3D%22width%3A%20264px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248829i9D54EFF9536DFF3C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22del.jpg%22%20alt%3D%22del.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2088646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089829%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20will%20not%20sort%2Ffilter%20low%20to%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089829%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20thanks%20for%20the%20response.%20What%20i'm%20trying%20to%20do%20is%20have%20both%20the%20numbers%20and%20the%20letters%20in%20sequential%20order.%20So%3A%201A%2C%201B%2C%201E%202C%2C%202D%20etc.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

Del.jpg

3 Replies

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

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 

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