Can you validate that only the first letter is capitalized?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 04 Mar 2006 21:11 GMT

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.

Reply to this Message

S.Y.M. Wong-A-Ton - 05 Mar 2006 16:27 GMT

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.

Reply to this Message

Bob - 07 Mar 2006 04:40 GMT

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]*
[quoted text clipped - 4 lines]
> > 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.

Reply to this Message