Hi Chalky

I'm not sure exactly what you are after. Perhaps you are wanting to sort
using just part of a cell contents. If so a previous response by Jim Cone
may help

"Jim Cone" wrote in message
...
Mike,
My Excel add-in "Special Sort" - rel 1.30, should do what you want.
It adds 11 sort features not found in Excel, including sorting by..
Prefix, Suffix or Middle (where you specify the length/position).
Will also sort by color, dates, number group, length, reverse,
random and others.
Comes with a 2 page install/use Word file.
It is available - free - upon direct request.
Remove XXX from my email address.
Regards,
Jim Cone
San Francisco, USA
XX

Jim was kind enough to send me a copy and it works very well. I am sure that
if you mail him, he would send you a copy also.

If this is not your problem, post back with more details.

Regards

Roger Govier


Chalky wrote:
Thanks for your reply James. That doesn't really do the trick, maybe because
it is only one cell or maybe because I am trying to put a formula into the
cell I want to split.

Chalky

"James Hamilton" wrote:


Try this....

Highlight the required cells you want to split and DATA TEXT TO COLUMNS
NEXT then enter the parameter that you want to split by (colon, space, etc)
FINISH

"Chalky" wrote:


I am working in a spreadsheet where I frequently use the filter and sort
functions. I want to split one cell into two in one column, I don't want to
use two columns and merge the rest of the cells as this upsets the
filter/sort functions.