It sorted fine for me, but not as you wanted perhaps. What results are you
looking for?

--
__________________________________
HTH

Bob

"zxcvbnm6000" wrote in message
...
I have a Excel sheet with various data that I want to sort by A-Z, the
problem is I have equations the do not sort correctly.

Example:
Befo
A1 - Mouse B1 - (=A3)
A2 - Dog B2 - ***
A3 - Cat B3 - (=A2)

After A-Z Sort:
A1 - Cat B1 - (#REF)
A2 - Dog B2 - ***
A3 - Mouse B3 - 0

Please help. This should be simple, but I just can't make it work.