You need to know what the tilde (~) does in Excel

Picture this: you need to find or count cells containing asterisks (*) or question marks (?) in Excel, but you’re getting incorrect results. This is because asterisks and question marks are wildcard characters. The solution? Excel’s essential escape character, the tilde (~).

Source: You need to know what the tilde (~) does in Excel