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: drinking chloroform jew ovens six foot bathtub down by contact short horror poems magician gift ideas vamanos translate wintergreen toothpaste physical attributes definition hantavirus pennsylvania kiss cards value acceptable gpu temp bourne identity ending coca plant seed bridge rectifier breadboard long dagger aes 4096 geo prizm corolla brahmin accent incredimail spyware clean laser printer playlist ideas investigator vs detective denise milani breasts yankee white clearence pearl harbor sucks i got promoted iris puns alarm clock earplugs medieval 2 guilds iggy pop weight dial tone app unlicensed daycare rates acrostics online midget birth if my cousin has a baby what am i dilbert tv show episodes groups of 7 things carrying a pocket watch my oil light comes on when i stop west coast chopper symbol why did flat feet military disqualification is there penetration in soft core porn what does *82 do how to keep fitted sheets on tick tock by dean koontz dr strange amazon release date how many pixels is 8.5 by 11 mexican at home depot nfl redzone online comcast phrases that sound like accents remedy for bitten tongue heater coil replacement cost sauce for the goose mr saavik can you flip a tempurpedic mattress myspace music wont play how do i get a receipt from amazon 5w 30 vs 5w 20 black women with natural red hair why is dominos so bad what does towel dried hair mean is drowning a peaceful way to die caught masturbating at work sack on a stick how to replace parts in toilet tank b and h photo hours when were garbage disposals invented ck2 demesne too big penalty kalo hair inhibitor walmart sheltered how to get water