Excel Sort - Alternate Sequence

  • Thread starter Thread starter Stan
  • Start date Start date
S

Stan

I would like to alter the sequence that excel uses to sort
the data in a spreadsheet. Does anyone know how to do
this?

Typically, I would like to put SPACES first, then ALPHA A
to Z, then numerics 0 to 9.

Thanks.
 
Hi
this can only be achieved with a helper column. Not
possible to change Excel's sorting algorithmn
 
Back
Top