Ok..after playing around with the users file...I have discovered why it
won't sort...which opens a new problem. This data was an export from
elsewhere. Not obvious at first glance is that these values all have a
random number of spaces before them. When I goto the cell and delete
the space that precedes the actual data...then resort...that particular
cell then falls in place where we want in a sort. Now...how do we delete
a random number of spaces before each piece of data. Looks like there's
2-4 of them.
--
couriced
------------------------------------------------------------------------
couriced's Profile:
http://www.excelforum.com/member.php...o&userid=26900
View this thread:
http://www.excelforum.com/showthread...hreadid=475956