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; (30693.75, « »)

How can I format the cells to capitalize ALL letters in a word?

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

      www.cpearson.com

      "lgb542" <lgb542.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:5064830E-0FBC-4A6B-9177-F7DFDC8AFD17.excel.todaysummary.com.microsoft.com...

      >

      #1; Sat, 07 Jun 2008 22:09:00 GMT