How to sort numbers last?

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

If a column has some cells containing numbers and other cells containing
letters, is there a way to sort the column so the cells with numbers are
last? In other words, I need to sort A to Z, then 0 to 9.

Thanks, Robert
 
Hi Robert
one way (using a helper column, e.g. col. B)
Insert the following in B1
=IF(ISNUMBER(A1),1,0)
copy down

Now sort with this column AND column A (both in ascending order)
 
That works! Thanks, Frank
Robert

Frank Kabel said:
Hi Robert
one way (using a helper column, e.g. col. B)
Insert the following in B1
=IF(ISNUMBER(A1),1,0)
copy down

Now sort with this column AND column A (both in ascending order)
Click to expand...
 
Back
Top