Kenneth,
Great suggestions…I love the LEN() hack! I agree that is close enough for government work. (No disrespect to our hard working bureaucrats!) Thanks for taking the time to help.
…the VLOOKUP() will mostly work, except for the Scoutbook bug that replaces my upload ID’s with alternatives that Scoutbook won’t accept as input. (I grudgingly admire that bug.) It means I have to retain the upload ID’s each time…but there are only 3 out of 790, I can live with that.
…still hoping for direction on the six ID’s that are ScoutNet-valid but not accepted or replaced by Scoutbook. These volunteer MBC’s languish in the 20th century world of paper blue cards, peering hopefully into the Scoutbook future.
YiS,
Michael
