Excel and capitalization

Hello,
I wonder if it is possible in Excel simply switch a cell containing text in lowercase text to uppercase (in something like Word with the Shift + F3). I know that you can not ask a spreadsheet to have all the features of a word processing. Is there any way I can set a column to have the first letter of each word capitalized no matter how the user types it?

Thank you

hello
Your Microsoft Office program can make your work easier by automatically correcting capitalization errors. The default options usually work well for most people, so you may not need to modify these options. However, if it is necessary, you can easily customize the automatic capitalization options. for more details see this

1. Click the Microsoft Office ButtonButton image, and then click Excel Options at the bottom of the window.
2. Click Proofing.
3. Click the AutoCorrect Options button.
4. On the AutoCorrect tab, select or clear any of the following check boxes:

• Correct TWo INitial CApitals
• Capitalize first letter of sentences
• Capitalize names of days
• Correct accidental use of cAPS LOCK key

You can have another column which has =PROPER(A1), but that's not quite what you want. You need an event macro. Right-click the sheet tab, select View Code, enter this, which applies to column C (3): -- change the colulmn accordingly.

Code:

---

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Column = 3 Then
      Application.EnableEvents = False
      Target.Resize(1, 1).Value = Application.Proper(Target.Value)
      Application.EnableEvents = True
  End If
End Sub

---

Hello,

Thank you for those explanations, it works well. By against, is there a way to cancel the execution of Macro, unless I Executive step in the right cell ?

Thank you

Hello,

I joined this forum just to answer your question!

I just encountered the same problem at work and there is a much easier and quicker way!!

1. Click on a blank cell.
2. Type this text: =UPPER
3. Click on the first cell in the column that you want to change to upper case.
4. Drag the corner of the blue box that appears so that it has all the cells you want changed, inside.
5. Go to the formular bar with the equation and add a bracket to the end.
6. The formular should look something like this: =UPPER(E2:E13)
7. Press enter.
8. All the text will now be in the blank columns/cells. If not, drag the corner of the black box and drag down, and the rest of the data will appear).
9. Copy all the new data. Right click on the first cell to be replaced and click, 'paste special' and then click 'values'.
10. Paste this data over the top of the original lower case data.
http://support.microsoft.com/kb/263580 :ohyeah:

Hope this helps!

Mandy:thumbup1: