Numerical Sort Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-357693%22%20slang%3D%22en-US%22%3ENumerical%20Sort%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357693%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20small%20worksheet%20that%20has%20first%20name%2C%20last%20name%2C%20address%2C%20phone%20and%20email.%20I%20am%20trying%20to%20sort%20numerically%20by%20the%20address%2C%20i.e.%202899%20East%20144th%20Avenue%20%23101%20Brighton%20MD%2004001.%20All%20entries%20in%20that%20column%20are%20NUMBERS.%20When%20I%20sort%20A-Z%20I%20get%20a%20column%20sorted%20different%20than%20the%20original%20but%20still%20not%20correct.%20I%20have%20tried%20changing%20the%20entries%20in%20that%20column%20to%20TEXT%20instead%20but%20get%20the%20same%20exact%20results.%20All%20cells%20are%20the%20same%20height.%26nbsp%3B%20I%20can%20go%20to%20different%20worksheets%20with%20basically%20the%20same%20layout%20and%20they%20sort%20correctly.%26nbsp%3B%20This%20one%20has%20me%20more%20than%20baffled.%20Even%20changed%20the%20%22%23%22%20to%20%22Unit%22%20but%20that%20did%20not%20help%20either.%20Any%20clues%20for%20me%20to%20try%20now%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-357693%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1607177%22%20slang%3D%22en-US%22%3ERe%3A%20Numerical%20Sort%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607177%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F291681%22%20target%3D%22_blank%22%3E%40Pattycake%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20seeing%20the%20spreadsheet%2C%20it's%20a%20little%20hard%20to%20identify%20the%20problem%2C%20but%20I%20understand%20why%20you%20might%20not%20want%20to%20share%20confidential%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20issue%3A%26nbsp%3B%20You've%20said%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3EI%20am%20trying%20to%20sort%20numerically%20by%20the%20address%2C%20i.e.%202899%20East%20144th%20Avenue%20%23101%20Brighton%20MD%2004001%3C%2FP%3E%3CP%3Eand%20then%20you've%20said%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3EAll%20entries%20in%20that%20column%20are%20NUMBERS%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E2899%20East%20144th%20Avenue%20%23101%20Brighton%20MD%2004001%3C%2FSTRONG%3E%20can%20not%20be%20represented%20as%20a%20number...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20the%20full%20address%20like%20this%20in%20a%20single%20cell%2C%20then%20it%20must%20be%20TEXT.%26nbsp%3B%20Having%20said%20that%2C%20it%20should%20still%20sort%20correctly...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20can't%20send%20a%20spreadsheet%2C%20could%20you%20send%20us%20a%20screenshot%20with%20anything%20confidential%20blurred%20out%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

I have a small worksheet that has first name, last name, address, phone and email. I am trying to sort numerically by the address, i.e. 2899 East 144th Avenue #101 Brighton MD 04001. All entries in that column are NUMBERS. When I sort A-Z I get a column sorted different than the original but still not correct. I have tried changing the entries in that column to TEXT instead but get the same exact results. All cells are the same height.  I can go to different worksheets with basically the same layout and they sort correctly.  This one has me more than baffled. Even changed the "#" to "Unit" but that did not help either. Any clues for me to try now? Thanks.

1 Reply

Hi@Pattycake 

 

Without seeing the spreadsheet, it's a little hard to identify the problem, but I understand why you might not want to share confidential data.

 

First issue:  You've said

I am trying to sort numerically by the address, i.e. 2899 East 144th Avenue #101 Brighton MD 04001

and then you've said

All entries in that column are NUMBERS

 

2899 East 144th Avenue #101 Brighton MD 04001 can not be represented as a number...

 

If you have the full address like this in a single cell, then it must be TEXT.  Having said that, it should still sort correctly...

 

If you can't send a spreadsheet, could you send us a screenshot with anything confidential blurred out?