View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
YanYan
 
Posts: n/a
Default Delete text in cells but keep formula

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)