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.
Does anybody has an idea?
You can see an example of the file attached - the green box shows the cell I am talking about.
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'.
