Tags: capitalize, cells, excel, format, microsoft, msdn, software, word
How can I format the cells to capitalize ALL letters in a word?
On Microsoft » Microsoft Excel
1,143 words with 1 Comments; publish: Sat, 07 Jun 2008 22:08:00 GMT; (30646.88, « »)
How can I format the cells to capitalize ALL letters in a word?
http://excel.itags.org/q_microsoft-excel_218157.html
All Comments
Leave a comment...
- 1 Comments
- You can't do that with formatting. There are two ways to do what
you want. The first is to use a formula in another column. Enter
the formula =UPPER(A1) in the first cell of the new column and
copy down as far as you need to go, then copy those values and do
a Paste Special Values over the original data. The second way is
to use VBA code, something like the following:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Application.Intersect(Range("A1:A10"), Target) Is Nothing
Then
If Target.HasFormula = False And Target.Cells.Count = 1 Then
Target.Value = UCase(Target.Value)
End If
End If
Application.EnableEvents = True
End Sub
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"lgb542" <lgb542.excel.itags.org.discussions.microsoft.com> wrote in message
news:5064830E-0FBC-4A6B-9177-F7DFDC8AFD17.excel.itags.org.microsoft.com...
>
#1; Sat, 07 Jun 2008 22:09:00 GMT