View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brendan Brendan is offline
external usenet poster
 
Posts: 23
Default Can't figure out a certain column sort

I have the following in a colum:

256
128
148(a)
299
301

The I would like the order to end up with a numeric sort but everytime I try
it, the 148(a) ends up at the bottom. Is there a way to get the column to
sort with the 148(a) where it should be... after the 128 and before the 256?
I can't remove the parenthesis as it is part of the data.