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 Like

This?

(
  MID([_THIS], 3, 20)
  = CONCATENATE(
    RIGHT(("0000000000" & NUMBER(MID([_THIS], 3, 10))), 10),
    RIGHT(("0000000000" & NUMBER(MID([_THIS], 13, 10))), 10)
  )
)
2 Likes

Sorry Steve but would this be placed in the Valid If?

Yep, in an AND() expression with what you already have.

1 Like

Interesting, ok will see what happens and report back

Thanks Steve!

1 Like

That worked perfectly! Amazing stuff! Thanks Steve

3 Likes