Excel/UPPER CASE

Advertisement


Question
I IMPORTED DATA TO AN EXCELL 2007 WORKSHEET. THE LETTERS ARE A MIX OF UPPER AND LOWER CASE, I WANT TO CHANGE ALL LETTERS TO UPPER CASE. I WANT TO CHANGE THE ENTIRE SHEET, NOT 1 CELL AT A TIME. HOW CAN I DO THIS

Answer
Mary:

If you are looking for a solution to change the entire sheet with just one click of a button, it doesn't exist; however, here are some options:

1) Excel has an UPPER() function.  If you have text in cell A1, then you can use this, =UPPER(A1), to convert that text to all uppercase.  Thus, if you have text in A1:C1000, then place this in cell D1: =UPPER(A1) and then copy that formula from D1 through F1000.  If you catch what I'm doing here, it is just duplicating your original data immediately to the right of the old data...just all in upper case.  Once you have done this, you can copy the new data, and then choose "edit->paste special->values" to clear out the UPPER formulas and you will simply be left with the text.

2) If possible, you could copy the data in Excel to Word (or import data into Word First).  Microsoft Word has a "change case" feature that will change all the text to Upper case.  Once that is done, if possible, you can copy the data back into Excel all at once (this option may not work very well, but I wanted to present it anyway since it could work in certain situations).

I'd go with #1 - it will actually be pretty quick and shouldn't take more than a few minutes.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

All Answers


Answers by Expert:


Ask Experts

Volunteer


Nathan Head

Expertise

Microsoft Excel questions related to advanced formulas, Pivot Tables, filters, forms, graphs, and just about anything else (EXCEPT Visual Basic Coding/Programming and Macros, I don't have any expertise there).

Experience

I have been using spreadsheets since Lotus 1-2-3 was released. As a CPA, I use spreadsheets every day at work.

Education/Credentials
CPA, Texas

©2010 About.com, a part of The New York Times Company. All rights reserved.