Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel, capital letter entry
Name: Pugwash (by John Gregory) Date: July 8, 2007 at 09:53:22 Pacific OS: XP Pro CPU/Ram: P4 2.5GHz / 512MB
Comment:
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.
Name: DerbyDad03 Date: July 8, 2007 at 12:41:15 Pacific
Reply:
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!
0
Response Number 2
Name: Jennifer SUMN Date: July 8, 2007 at 12:48:27 Pacific
Reply:
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.
Summary: I don't know if it is possible but i would like to edit a text that was typed in capital letter to normal and vice versa.all answers will be appreciated. ...
Summary: Hello, Is there any way in MS Excel or OpenOffice Spreadsheet to do the following: I have a spreadsheet looking like this mother father father father father sister sister sister brother brother and I ...
Summary: Dear Everyone, If I hv a long list of data in Sheet1 & Sheet2 & I need to know if any data in column C of Sheet2 duplicates those in column C of Sheet1, how can I use conditional formatting to highlig...
0 
