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

R

raypen

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
 
N

Nick Hodge

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
[email protected]
www.nickhodge.co.uk
 
Top