Hi - Hope someone can help.

I have a set of numbers, eg

00012
00013(2)
00014
00010(2)

I need to be able to sort these, ignoring the numbers in brackets. At
the moment, the numbers with brackets appear at the end of the list,
and this is causing me problems as I need the numbers themselves to be
in order, but I still need the brackets to stay there.

I have tried changing the format of the column, but cant get there.


Any advice/help welcome

Thanks


--
Itsy
------------------------------------------------------------------------
Itsy's Profile: http://www.excelforum.com/member.php...o&userid=26005
View this thread: http://www.excelforum.com/showthread...hreadid=393660