Home

Sorting text

%3CLINGO-SUB%20id%3D%22lingo-sub-262489%22%20slang%3D%22en-US%22%3ESorting%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-262489%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20about%2010000%20rows%20of%20data%20that%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E05%2F01%2F2018%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E15E10%3C%2FTD%3E%3CTD%3ETheft%3C%2FTD%3E%3CTD%3EApartment%3C%2FTD%3E%3CTD%3E8900-8999%3C%2FTD%3E%3CTD%3ECHIMNEY%20ROCK%3C%2FTD%3E%3CTD%3ERD%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E05%2F01%2F2018%3C%2FTD%3E%3CTD%3E16%3C%2FTD%3E%3CTD%3E15E10%3C%2FTD%3E%3CTD%3EBurglary%3C%2FTD%3E%3CTD%3EResidence%20or%20House%3C%2FTD%3E%3CTD%3E4800-4899%3C%2FTD%3E%3CTD%3EIMOGENE%3C%2FTD%3E%3CTD%3EST%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20third%20column%20is%20text%20(istext%20reports%20TRUE).%26nbsp%3B%20I'm%20trying%20to%20sort%20by%20that%20column%20but%2015E10%20sorts%20before%2001A10.%26nbsp%3B%20Why%20would%20it%20do%20that%3F%20And%20how%20can%20I%20make%20it%20sort%20normally%3F%26nbsp%3B%20The%20sheet%20is%20attached.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-262489%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-262510%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-262510%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGoto%20Sort%20%26amp%3B%20Filter%20-%26gt%3B%20Sort%20-%26gt%3B%20Column%20Precinct%20-%20Sort%20on%20Values%20-%20Order%20A%20to%20Z.%3C%2FP%3E%3CP%3EClick%20OK%20and%20you%20get%20a%20warning.%20Select%20the%20second%20option.%20Click%20OK.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Bert Onstott
Occasional Visitor

I have a spreadsheet with about 10000 rows of data that looks like this:

 

05/01/2018915E10TheftApartment8900-8999CHIMNEY ROCKRD-1
05/01/20181615E10BurglaryResidence or House4800-4899IMOGENEST-1

 

The third column is text (istext reports TRUE).  I'm trying to sort by that column but 15E10 sorts before 01A10.  Why would it do that? And how can I make it sort normally?  The sheet is attached. 

 

Help would be appreciated.

1 Reply

Hi

 

Goto Sort & Filter -> Sort -> Column Precinct - Sort on Values - Order A to Z.

Click OK and you get a warning. Select the second option. Click OK.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies