Find in Excel using special characters

[David28]

Hi,

I am to search an excel spreadsheet for a series of ID's. these IDs are alphanumeric. In MS Word, I used the ^$^$^$^#^#^# for ABC123. Is there something similar to use for similar searches in Excel?

Thanks

[#2 · Accepted solution]

@David28 

Excel does not have built-in support for this - it only allows for simple wildcards * and ? in searches.

You could use VBA, but that will be much slower.

[#3]

Many thanks Hans, just thought I checked.