My requirement is to validate a column values using a validation formula for following format: <<Prefix>>-<<Suffix>>
The field should type of "Single line of text" where Prefix should be 3 uppercase letters, i.e., PRC, and middle character should be a hyphen (-) and suffix should be 3 numeric, i.e., 001. For example, PRC-0001
I tried this:
But, no luck.
How to do this?
Thanks a lot for your support.