Hey guys!
This is my first time posting so I apologize if this is in the wrong section. I am trying to "clear contents" (not delete) every other cell in Excel 2007. I don't want to do it manually because there is a large amount of data.
I attached a picture to show what I am trying to do. The fields that have incorrect formatting (they show as a bunch of #####) is what I want to clear the contents of as we would not need that data in our report. But as you can see, I don't want to affect any other cell in the worksheet.
If additional images are needed, let me know.
Any help is greatly appreciated!
Thanks!
Nik
excel chart.JPG
Bookmarks