Quote:
One more question: how do I then tell Excell that I want the cell to contain the resulting text instead of the equation?

Without using VBA to programatically do this then I can't think of a way that this can be achieved automatically.

A right-click, Copy then Paste Special -> values will manually get you the literal text.

Not that it would achieve much but you could use the Val(ue of) operator e.g. for H7 =val(G7) That would hide the more complicated formula but you're still left with a formula!


Edited by AndrewT (23/08/2006 19:05)