In that case I would select column C range of formulas and EditReplace.

What: =

With: XXXX

Replace all.

Copy Column C to Column D then reverse the EditReplace process with both
columns selected.


Gord

On Thu, 20 Jul 2006 21:44:07 -0400, littleps
wrote:


Gord,

What if formulas in Column C are mixture of referenced cells from
various sheets? Can't do type everything manually, or cell by cell
copying cell contents...

Tks.