Thanks so much! I used FILTER to do the same thing. Using Text Value = Z
Then using text value = R##### which uses # as the wildcard for numbers. Saved me hours upon hours! Maybe 100 hours?
These other wildcards I found useful.
# (Pound)
Matches any numeric digit
@ (At)
Matches any alphabetic character
. (Period)
Matches any nonalphanumeric character
* (Asterisk)
Matches any string and can be used anywhere in the search string
? (Question mark)
Matches any single character; for example, ?BC matches ABC, 3BC, and so on
~ (Tilde)
Matches anything but the pattern; for example; ~*AB*matches all strings that don't contain AB
[ ]
Matches any one of the characters enclosed; for example, [AB]C matches AC and BC
[~]
Matches any character not enclosed; for example, [~AB]C matches XC but not AC
[-]
Specifies a range for a single character; for example, [A-G]C matches AC, BC, and so on to GC, but not HC
` (Reverse quote)
Reads the next character literally; for example, `~AB matches ~AB
Thanks for the tip!