Excel - data validation to ensure capitals

Posted by Constantly Confused PM | on Tue, 20/03/2012 - 09:33 1698 11 comments | report

I have a tracker. People putting lower case letters in codes is not cool, so I want to make it so my spreadsheet either rejects them, or better yet, corrects them.

I've found the 'data validation' button, but it doesn't seem to have 'ensure capitals' as an option.

Comments

There are 11 comments. Login or register to view them.

Any one could invalidate data

Cantona1 | Tue, 20/03/2012 - 09:37

Skip that then

Constantly Confused | Tue, 20/03/2012 - 09:55

If you don't mind using macros

leestevens | Tue, 20/03/2012 - 09:56

Thanks

Constantly Confused | Tue, 20/03/2012 - 10:07

asap utilities

stevie | Tue, 20/03/2012 - 13:11

Data validation - limit to list

shurst | Tue, 20/03/2012 - 16:03

Or...

shurst | Tue, 20/03/2012 - 16:09

UPPER?

SashaOJ | Fri, 13/04/2012 - 15:53

Data validation

jndavs | Fri, 13/04/2012 - 19:07

If you do not mind using VBA

jndavs | Tue, 17/04/2012 - 08:42

Events are also

paulwakefield1 | Sat, 14/04/2012 - 09:23