Can you validate that only the first letter is capitalized?

[Bob]

I am trying to validate that users only capitalize the first letter of their
first and last names. I know in Excel I can go in and correct it but I'd
like to give an error message to the person entering the data.

 

[S.Y.M. Wong-A-Ton]

You have to add Data Validation on the fields with a "does not match pattern"
condition and a "Custom Pattern" such as [A-Z]{1}[a-z]*

 

[Bob]

Thanks a bunch!.......

You have to add Data Validation on the fields with a "does not match pattern"
condition and a "Custom Pattern" such as [A-Z]{1}[a-z]*
---
S.Y.M. Wong-A-Ton

I am trying to validate that users only capitalize the first letter of their
first and last names. I know in Excel I can go in and correct it but I'd
like to give an error message to the person entering the data.