Delete text in cells but keep formula
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" wrote in message
...
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)
|