If there is an entry in that column then it will always be an X. It needs to
be capitalized. If there a way to just enter X and not shift X?
Microsoft Office 2007

Not without using VBA event code for an in-cell change or a helper column
and the UPPER function.

Event code for in-cell-as-you-enter change..................

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column 1 Then Exit Sub 'adjust column number to suit
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

Helper column..................

In an adjacent column enter =IF(A1="","",UPPER(A1))


Gord Dibben MS Excel MVP


On Tue, 19 May 2009 09:16:01 -0700, Lynda
wrote:

If there is an entry in that column then it will always be an X. It needs to
be capitalized. If there a way to just enter X and not shift X?
Microsoft Office 2007