Thread: [Solved] Sort alphanumeric data using SORTBY
View Single Post
 
Old 04-10-2021, 10:21 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Sort alphanumeric data using SORTBY
Hi. The SORTBY formula sorted the data in a column as follows:

GLUE, all purpose, 130 grams
GLUE, all purpose, 200 grams
GLUE, all purpose, 40 grams

I would like the sort result to be:

GLUE, all purpose, 40 grams
GLUE, all purpose, 130 grams
GLUE, all purpose, 200 grams

The usual help would be much appreciated. Thank you.
Attached Files
File Type: xlsx SortByAlphanumeric.xlsx (15.3 KB, 10 views)
Reply With Quote