Thread: Sorting Columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Sorting Columns

Produce a helper column with =MID(A1,2,1), and sort by that column.
Of course, if the first letter is the same, a normal sort would sort by the
second letter.
--
David Biddulph

"Curious Educator" <Curious wrote in
message ...
Can I sort by the second letter in a column? The first letter is the same
but
the second letters are different and I need the sort to the second level..

Thansk,