If the text is the result of formulas, you are stuck, unless you re-write
all the formulas in the form

=IF(SomeFlag=specific value,old formula,"")

HTH,
Bernie
MS Excel MVP


"YanYan" <YanYan@discussions.microsoft.com> wrote in message
news:DE97D435-3D9C-4EDC-A102-6860D042EB39@microsoft.com...
>I currently have an excel grid with headers in rows and columns. Within the
> cells there is data that I dont need, but I do need the formulas in those
> cells, how do I clear the data in the cells without deleting the formulas?
>
> ( I have tried GO TO - Special - Constants but this clears all of my
> headers
> rows and additional info that I need, I only want to clear the text in the
> cells that currently contain formulas)