View Full Version : How do I change all lower case to caps in excel?

11-25-2008, 11:37 AM
I'd like to change all the letters in a column from lower case to capital letters. Is there a way to do this, short of doing it by hand? I can't find a route using help. Seems that there has to be a pretty easy way to do this. Any help, Dopers?
xo, C.

11-25-2008, 11:41 AM
One dirty way to do it: Copy and paste your column into MS Word. Highlight column. Format > Font > All Caps (checkbox under "Effects"). Copy and paste column back into Excel.

11-25-2008, 11:42 AM
How about this? (http://support.microsoft.com/kb/263580)

11-25-2008, 12:03 PM
Jeez, I guess I'll try Emily's fix, since that looks easier. But it's surprising that there isn't a function or something that you could just invoke to do that. On second thought, I probably won't even make that effort. Thanks, anyway.

11-25-2008, 12:08 PM
it's really easy, the function in Excel is
=UPPER(cell reference)

11-25-2008, 12:13 PM
insert an empty column next to the one you want to convert
next to the first cell you want to convert, type =Upper()
with the insertion point between the two brackets, click on the cell that should be converted.
Autofill down for the length of the column
select the cell containing the now uppercase text, copy and past special as "values"
now you can delete the column with the lowercase text.

11-25-2008, 12:17 PM
Are there formulas involved? If not, I would just do a text dump of the Excel spreadsheet (saving it as a CSV file), then upcase all the letters with a one-line Perl or tr script and read it back in to Excel.

perl -ne 'tr/a-z/A-Z/; print $_;' lowcase.csv > upcase.csv

You can download Perl for Win32 for free here (http://perl.com/download.csp).

11-25-2008, 12:24 PM
Why not just use the UPPER function in the top cell of an adjacent column then

copy that cell down equal to the end of the lowercase column then

Copy the entire new "UPPER" column and "Paste Special - values" back into the original column.

I'm not understanding why others don't want you to use the UPPER function.

11-25-2008, 12:34 PM
I can insert a blank column and get it to turn the other column into caps using the =Upper function. But I'm not finding the "paste special - values" function anyplace, which seems to be the last step I'd need, so I'm a bit stuck mid-process. This is Excel 2000, if that makes any difference.

11-25-2008, 12:39 PM
Paste-special is accessed under the Edit menu. You have to copy black of cells first, move your cursor if necessary, then click on Edit, Paste Special, and the radio button for values.

11-25-2008, 12:42 PM
CC - Do a right mouse click where you want to paste. Right below "Paste" is "Paste Special". Left click. click on the third selection down - "Values". If you have a formula which has given you a value in a cell (A2+B2), you can copy and Paste Special Values to make the cell vulue the actual number, rather than the equation.


11-25-2008, 12:44 PM
Man, thanks to all, I've figured it out. It reinforces for me, however, the idea that there's a step missing in a lot of Help manuals, etc., where a naif such as myself could use some regular talk in explaining things. I believe that the people who invent the processes also describe how to use them, forgetting that a lot of people are basically nitwits. They joke about the guys who call for help and have to be told to plug in the computer, but if you haven't used Excel much, for example, it's not easy to try to figure it out on your own. And it should be. Thank you, again. Now let me try to do it a few more times to be sure I have it. xo, C.

11-25-2008, 02:44 PM
I agree CC. I learned more from Google than have from the Microsoft Help feature.

I'm an experienced Excel user and VBA programmer and, for the life of me, most times I can't make heads nor tails out of anything in the Excel help menus.

11-25-2008, 04:26 PM
I agree CC. I learned more from Google than have from the Microsoft Help feature.

I'm an experienced Excel user and VBA programmer and, for the life of me, most times I can't make heads nor tails out of anything in the Excel help menus. I totally agree with this. I do not use Excel formulas that often so I often have to consult the syntax and it is very annoying. I feel I need a "Help" function on how to use the Help function.

Best Topics: domo arigato lyrics inable or unable little bill daggett knife handle finishes pimiento jar anne heche anus cinematographer vs director expelled iud symptoms cute opossum 5.8 hemoglobin a1c ebay combined shipping increasing nipple sensitivity define mofos mx medical despair sandman jesus nicknames pope berries sick squirrel behavior ihb blood pressure eating raw brain chicken keels morgues near me playing cards jack morocco porn lumpfish caviar choad or chode navy marriage david pelzer mother lava lamp stuck format trade cloth hotter than sayings wort archive visable bra why do dogs eat crayons is aleve good for cramps karate vs aikido real fight french word for earth is tom hulce gay antifreeze stop leak reviews what are male ballet dancers called garage door opener capacitor symptoms how to dry modeling clay fast how old can you be in high school the previous system shutdown was unexpected 6008 honda civic fuel gauge reading wrong hot weather jokes it's so hot selling auto parts on amazon how long does it take for something to freeze dog names ending in o first communion gift from godmother house smells like gasoline filing tax exempt for one paycheck man buried in piano case cirque du soleil language ezekiel 2517 the path of the righteous man gold bar weight pounds creme fraiche south park quotes how to get in and out of a kayak what happens if you write a bad check at walmart breaking in a new laptop battery bender now that is irony how much robitussin dm to get high how much nyquil is safe associates degree in mathematics how much is 2 bits worth what bank is open on saturday what happens when you mix an acid and a base torn bills legal tender why do pickles have 0 calories what time does fedex start delivering to homes