force input data to be uppercase

Hello,
I need to enter surnames in a column and they all have to be recorded in uppercase. Is there any way I can enforce this condition ? I'm trying to apply the UPPER function to the column but with no success. I could not find a validation criteria that matches what I want, as well.

Thanks for the help,
Abraham

An easy way to do this is with VBA.

Right-click on the sheet tab, select View Code, and copy the following procedure:

Please Login or Register  to view this content.

If you are using a column other than A, just change the column reference above. This will not require the user to enter upper case; rather, it will automatically change it to upper case.

HTH

Jason

Not sure I did it right, Ron, but it did not work for me.
Thanks Jason, that's exactly what I needed.

Good to know this things are achievable through VB, I thought I could get along with the functions itself. Time to start learning some VB.

Thanks !

The advantage of Ron's method is that it does not use VBA to modify the sheet contents, which flushes the Undo buffer. From that perspective, it would be worth trying again.