View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default How can I advanced sort into a Collum

Well, why not separate out the two characters you need, i.e. enter:

= LEFT(B1,2)

in cell C1 and copy down. Now sort your data (plus column C) using
column C - you can always delete this column if you have no further
need for it.

Hope this helps.

Pete