Hello,
I have a spreadsheet with data, some of the cells contain a single zero. My reason for wanting to delete 0’s is so that I can perform an average calculation where the cells with a single zero is not included in the calculation.
Is there a way to do this with find & replace rather than to use a formula and replicate the dataset?
Thank you.
Oliver