Hi Nigel,

=ADDRESS(ROW(INDIRECT(A1)),COLUMN(INDIRECT(A1)))
copy the result as values
text to columns using the "$" character
sort on two levels

Let me know if this helps.

Peggy

"Nigel Molesworth" wrote in message
...
On Wed, 14 Oct 2009 14:11:18 +0100, joel
wrote:

I use auxilary columns and split the B10 into two columns putting the B
in one column and the 10 in a second column and then sort on the two new
columns

I can see how that would work, but how would I split the data?