Sorting text

Copper Contributor

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.