CHANGE WHOLE EXCEL worksheet TO UPPERCASE LETTERS?
 

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.

Your boss must be thinking of using a macro. Take a look he

http://www.mvps.org/dmcritchie/excel/proper.htm#upper



In article ,
"mineralgirl" wrote:

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.

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.

How many worksheets is the data in?

It's possible to just create a new worksheet and use
=UPPER(Sheet1!A1) and copy it down and across to match the rows and column
count of the original worksheet.

Steve

"Jim Rech" wrote in message
...
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.

Hi Steve and mineralgirl,
She did not say, but if you look in the subject title it indicates one
because it says a whole Excel worksheet.

So I didn't add to Jim's reply. But since you have kind of brought
it up, if one did wants to convert the
entire workbook there is also one of those on my page, and you
can perhaps tell from the topic title what I think of converting to
and looking at all capitals whether it is an entire workbook, or
and entire worksheet.
http://www.mvps.org/dmcritchie/excel/proper.htm#kindy

For one worksheet, I can't see having a separate macro, because
it is so easy to select all cells and run the same macro as you would
use to simply change a column or other selection.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Steve McBride" wrote in message ...
How many worksheets is the data in?

It's possible to just create a new worksheet and use
=UPPER(Sheet1!A1) and copy it down and across to match the rows and column
count of the original worksheet.

Steve

"Jim Rech" wrote in message
...
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.