how to use an ampersand in a search

%3CLINGO-SUB%20id%3D%22lingo-sub-2047361%22%20slang%3D%22en-US%22%3Ehow%20to%20use%20an%20ampersand%20in%20a%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047361%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20extracting%20data%20from%20a%20database%2C%20I%20have%20some%20data%20that%20shows%20up%20as%20%22LEI%20%26amp%3B%20EI%22%20and%20when%20I%20try%20to%20search%20it%20using%20a%20countif%20formula%20it%20doesn't%20allow%20me.%20Is%20there%20a%20way%20to%20use%20to%20state%20in%20the%20criteria%20box%20in%20order%20for%20it%20to%20recognize%20the%20%22%26amp%3B%22%20sign%20with%20the%20word%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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