Thread: [Solved] Aplha Numeric Sorting
View Single Post
 
Old 06-05-2020, 04:27 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 874
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
You must have the column with alphanumeric values formatted as text. Then it'll sort exactly as you wanted.

Simply changing column format is not enough! When you format the column as text, it will behawe as all entries are texts, but really they remain numbers - you have to edit all entries to convert them really (select entry, press F2, Press Enter for every entry).

To convert all entries at one go:
Into some empty column enter formula like ="" & A2, and copy it down for all entries in column A;
Format column A as Text;
Copy the range with formulas;
Replace old entries in column A with values of copied formulas (PasteSpecial.Values);
Delete column with formulas.
Reply With Quote