Forum Discussion
Find wrong data in this specific case
Hi, sorry for bothering again. I was using a formula which got some errors because of some cells with multiple numbers in it. I want to find cells where multiple numbers are. Blank cells are fine. D...
Press Ctrl+F to activate the Find dialog.
Click in the 'Find what' box and press Ctrl+J
If necessary, click Options >> to display the search options.
Make sure that 'Match entire cell contents' is not ticked, and that Values is selected in the 'Look in' drop-down.
Click 'Find Next' or 'Find All'.