Can you insert a couple of helper cells and put formulas in them to extract the
numbers?

Then sort the entire range based on those two columns?

If you can, then is that the only kind of non-numeric in your data?

Brendan wrote:

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.

--

Dave Peterson