If I’m understanding correctly, you want to check if the first digit is an ‘8’? To do that, I would first create a template column that joins ‘@’ to the code. Then create an IF column that checks if that template includes ‘@8’. If it does, then it’s true that the first digit is an ‘8’.
Jeff_Hager
10
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Phone entry format validation | 25 | 3416 | September 4, 2025 | |
| RegEx challenge (or just seems that way) | 11 | 1144 | December 21, 2021 | |
| How can I get it MID() formula to show part of info before saving? | 8 | 561 | May 18, 2021 | |
| Text entry needs validation | 23 | 1303 | September 19, 2021 | |
| Regex Data Validation Needed | 22 | 2485 | August 4, 2021 |