Compare two cell texts the way a spreadsheet would: numbers (with thousands separators or a trailing %) numerically, everything else with a locale-aware, case-insensitive collation; blanks sort last either way.
Compare two cell texts the way a spreadsheet would: numbers (with thousands separators or a trailing %) numerically, everything else with a locale-aware, case-insensitive collation; blanks sort last either way.