how to use an ampersand in a search

Occasional Visitor

When extracting data from a database, I have some data that shows up as "LEI & EI" and when I try to search it using a countif formula it doesn't allow me. Is there a way to state in the criteria box for it to recognize the "&" sign with the word?

0 Replies