I've figured out how to use IndexOf() and it works great as long as my string is exactly the same as my IndexOf(str).
I am guessing there is a way to add in Left (text, count) to get the rest of this done...
Looking farther it doesn't seem there is an easy/elegant way to do this.
IndexOf("B"wildcard) would be ideal.
Without that option I have to pull each cell value individually, ForEach, truncate it, check it vs my conditions, reject or accept it, set a variable with its cell number, and move on.
That's a lot to do... No Wildcard??
No way to do like command line style "DIR B*.exe"?