How to set validation to allow only alphanumeric characters - no symbols etc

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

1 5 2,485
5 REPLIES 5

Steve
Platinum 4
Platinum 4

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

Top Labels in this Space