View Single Post
  #3   Report Post  
Jim Rech
 
Posts: n/a
Default

JE's right about having to use a macro. I would just point out that this
will take a long time to run because of the amount of data in the sheet.
You might want to run it overnight. Also the macro requires you to select
all the cells to convert first. If you want to convert all the text entries
without selecting use this:

Sub Upper_Case()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim Cell As Range
On Error Resume Next
For Each Cell In Cells.SpecialCells(xlConstants, xlTextValues)
Cell.Formula = UCase(Cell.Formula)
Next
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub

--
Jim
"mineralgirl" wrote in message
...
| My boss wants me to change a whole excel document to uppercase letters. It
| has like 43,000 records. How do I do that? He says it's possible, but I've
| never seen it done. I'm Using Excell 2003.