Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel contents cells on different worksheet like a comment | Excel Discussion (Misc queries) | |||
How can I protect a worksheet yet allow editing in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel worksheet display #### | Excel Discussion (Misc queries) | |||
Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions |