Forcing Uppercase

How do I force Uppercase text in a cell. For example, I want the data entry to be all caps even if the user types in lower case? Is there a formula I can put in the cells. I tried the following formula in cell A25: =Uppercase("A25") and it put #NAME? error in the cell. Please help.

If you don't want to use vba, you can force the user to type in upper case (if that is an option).

You can set up a data validation. Assuming you are working with cell A1, click on A1-Data-Validations-Custom- =EXACT(A1,UPPER(A1))=TRUE -- Set up an error message (saying "You must enter the information in Caps")

Admittedly, it does not do exactly what you want, but it is an option.

Originally Posted by VBA Noob

I would recommend VBA better as validation can be deleted

VBA Noob

Although protecting the sheet can prevent this, that is a very good point!

I just know that in some of the reports at my company we cannot apply VBA because the security settings for some employees are too high.

I tried using the vba code in the link. It worked but when I delete the data from the cell it gives me an error; "Type mistmatch on the line in red below"

Private Sub Worksheet_Change(ByVal Target As Range)

If (IsNull(Target.Value)) Then
Else
With Target
If Not IsNull(.Value) Then
.Value = UCase(.Value) Else

End If
End With
End If