how do I sort a list a1 to a15, b1 to b15 etc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to sort a worksheet that has a column with a1 to a15 but normal sort
results in a1,a10,a11 not a1,a2 etc that I need
 
Raypen

Two things

1) Use a helper columns and separate the parts of the data and sort by these
helper columns. In your example

=Left(A1,1)
=Right(A1,1)

2) Set up a custom list. Tools>Options>Custom Lists and either type them in
the order you want or import them from the sheet. Now go to
Data>Sort...>Options>first key sort order and select your list

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
Back
Top