Sean wants to find all street addresses that have the number 1 8 in them. There are so many numbers in the dataset though, when

Question

81 users unlocked this solution today!

Sean wants to find all street addresses that have the number $18$ in them. There are so many numbers in the dataset though, when he uses the default search settings, he gets $441$ results and they are mostly in the columns with currency in them. Can you help him reduce the number of search results to get to his answer more easily?

$($One or more answers are possible$)$

He can tick the box Match entire cell contents.

He can select Column D $($Address$)$ before he does his search. Now, Excel will only look in this particular column.

He can open the Find dialogue box and change the Format settings to General.