Articles

Excel, capital letter entry

July 8, 2007 at 09:53:22
Specs: XP Pro, P4 2.5GHz / 512MB

I should know this & can't easily find the answer, help please.

In Excel 2007 I want to make Text entries in a column that should always be in capital letters, I can't for the life of me remember / think how to set this up, done it before, but .... it's an age thing!

John

It's not that I can't remember things as I get older, it's just that my hard drive's full.


See More: Excel, capital letter entry

Report •


#1
July 8, 2007 at 12:41:15

I can think of 3 options:

1 - Use the Caps Lock key
2 - Use =UPPER(A1) in another column
3 - Use a Worksheet_Change macro as follows:

Right click the sheet tab and choose View Code. Paste the following code into the window. After text is entered anywhere in column A, it will be converted to upper case.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then Target = UCase(Target)
End Sub

Hope that helps!



Report •

#2
July 8, 2007 at 12:48:27

I can think of two ways: Press the Caps Lock key before typing, or use the =UPPER Formula to copy the data as all caps to another cell/sheet.


Life's more painless for the brainless.


Report •

Related Solutions


Ask Question