Sep 20 2021 07:39 AM
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
Sep 20 2021 03:04 PM
SolutionExcel 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.
Sep 21 2021 02:41 AM
Sep 20 2021 03:04 PM
SolutionExcel 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.