Fixed Capitalization

[Kathryn Domres]

How do I automatically program a cell to change all text typed into it to begin with a capital letter and all other letters to be lower case? Ex. I type HELLO in upper case and the cell automatically converts it to Hello once you press enter.

Look forward to hearing from you.

Thanks

 

[NARAYANK991]

Hi Kathyrn ,

The only way this can happen automatically is if you use VBA ; you can make use of the Worksheet_Change event procedure to convert anything that you type into a cell ( as long as it is text ) , using an Excel function called PROPER ; this is also a worksheet function ; so if your text is in cell A1 , if you enter the formula =PROPER(A1) in any other cell , that cell will display the same text in Proper case.

Narayan

 

[Sam Mathai Chacko]

In case you are finding it hard to figure out Narayan's VBA suggestion, this is what he meant

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim rng As Range
    For Each rng In Target
        If Not IsEmpty(rng) Then
            rng.Value = Application.Proper(rng.Value)
        End If
    Next rng

End Sub

 

[Kathryn Domres]

Thanks, Narayan. The VBA is what I would be looking for but have no idea how to do it. For the time being your suggestion has worked just great. Thanks for getting back to me so fast!

Also, Sam, thanks for the info......but I am still not sure how to use it. Need to do a little research there for sure. Thanks for your response too!

 

[Sam Mathai Chacko]

All you need to do is copy and paste it to the code window of the sheet in which you need this done.