Forum Discussion
David28
Sep 20, 2021Copper Contributor
Find in Excel using special characters
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 Ex...
- Sep 20, 2021
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.
HansVogelaar
Sep 20, 2021MVP
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.
- David28Sep 21, 2021Copper ContributorMany thanks Hans, just thought I checked.