I have a text field where I’d only want to allow alphanumeric characters - no symbols. I wasn’t able to find anything here on it. I have a field that should contain only 22 characters of which the first two must be “RS” and the last 20 should be numeric.
Can someone assist with how to validate the last 20? Thanks so much
This?
(
MID([_THIS], 3, 20)
= CONCATENATE(
RIGHT(("0000000000" & NUMBER(MID([_THIS], 3, 10))), 10),
RIGHT(("0000000000" & NUMBER(MID([_THIS], 13, 10))), 10)
)
)
Sorry Steve but would this be placed in the Valid If?
Yep, in an AND() expression with what you already have.
Interesting, ok will see what happens and report back
Thanks Steve!
That worked perfectly! Amazing stuff! Thanks Steve
User | Count |
---|---|
15 | |
11 | |
9 | |
8 | |
4 |