Sorting numbers with brackets

[Itsy]

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

 

[Max]

One play to try ..

Assuming the data is in col A, from row1 down

Put in B1:
=IF(ISERROR(LEFT(A1,SEARCH("(",A1)-1)),A1,LEFT(A1,SEARCH("(",A1)-1))
Copy down

Then sort both cols A & B, by col B (ascending or descending)

 

[Itsy]

This works perfectly.

Thanks Max - I would never have got there!!!

Cheers

 

[bigwheel]

Formatting as text worked for me, I ended up with:

00010(2)
00012
00013(2)
00014

 

[Max]

Glad to hear it worked for you !
You're welcome