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

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

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

Change the cells to a01, a02... etc if possible.

--
Ian
--
"raypen" wrote in message
...
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

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

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. ToolsOptionsCustom Lists and either type them in
the order you want or import them from the sheet. Now go to
DataSort...Optionsfirst key sort order and select your list

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"raypen" wrote in message
...
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