Sort column containing different data types
 

Can anyone help, I have a column with project codes in the following format

123
146/5
1246
1344
102/3


Is there any way to sort the column by the numeric values to the left of the
character symbol only, so that it reads:

102/3 and not 123 result with normal sort
123 102/3
146/5 1246
1246 1344
1344 146/5

Is there any way round this other than separating the code into separate
columns ??

Sort column containing different data types
 

p,

My Excel add-in Special Sort will sort by the first group (or last group)
of numbers in the cell entry. It sorted your numbers as follows...
102/3
123
146/5
1246
1344

The add-in has over twenty different sort methods not easily accomplished
in Excel, including sorting by color, date, reverse, length, random, prefix, suffix.
It has an option to include cell borders with the sorted data.
Works and looks somewhat like the normal Excel sort utility.
Comes with a Word.doc install/use file.
It is - free - just email me and request it.
Remove XXX from my email address.

Jim Cone
San Francisco, USA
XX


"pavlosbat"
wrote in message

Can anyone help, I have a column with project codes in the following format

123
146/5
1246
1344
102/3


Is there any way to sort the column by the numeric values to the left of the
character symbol only, so that it reads:
102/3 and not 123 result with normal sort
123 102/3
146/5 1246
1246 1344
1344 146/5
Is there any way round this other than separating the code into separate
columns ??