Replace with help

Topic

New Reply

I would like to clean up some spreadsheets and remove empty cells (empty being showing the number Zero).  Using Replace 0 with “nothing” seemed to work but then I realised that it also affected figures like 120 and turned them to 12.  I am sure there is an easy solution to make it clear that only cells should be changed if the whole cell is Zero?

Reply | Quote

Replies

Click Options in the Find & Replace box.

Check box next to Match entire cell contents as in attached example.

 

HTH, Dana:))

HTH, Dana:))

1 user thanked author for this post.

beethoven

Reply | Quote

thank you very much

Reply | Quote