You are here:

Excel/Changing font to all caps

Advertisement


Translation-Now wrote at 2007-07-20 12:37:59
Well, you could also simply copy the text from Ecel into Word, switch font to 'All caps', the copy back into Excel using Right click -> Paste special -> Text.

Not exactly fast, but easier for formula illiterates like me :-)


Yemi wrote at 2007-11-09 20:24:39
Just paste into Word, click Format, Change Case, then Uppercase, and then paste back into Excel. simple.


Goodz wrote at 2008-05-16 18:15:55
Whoever you are that came up with this formula, all of my coworkers thank you very much!  This is a piece of cake to use and only takes about 15 seconds!!!  THANKS!!!


Bryan wrote at 2009-07-21 16:18:10
Thank you, it runs a little slow, but this has been a most helpful formula.  I really appreciate this simple posting!


diky wrote at 2010-10-27 16:37:30
TO get proper answer to convert case in excel 2007 visit following link (Microsoft site). This has proper way of conversation cases.

http://support.microsoft.com/kb/263580  


Captainpailfull wrote at 2012-06-12 18:20:40
highlight control - Shift - A   

Simple as it gets


Fionna wrote at 2012-08-06 19:36:34
Thank you, Translation-Now!!!  This is a real solution that is simple and works quickly!  I spent far too many hours trying to do it "correctly" according to the support experts and wound up in an endless errors loop. I also tried Captainpailfull's "highlight control - Shift - A" which also did not work. It's left to me to format spreadsheets that have had entries made by multiple people, none of whom care about consistent formatting.  Again, Thank you for your simple solution to a problem that has been plaguing me.


tre wrote at 2012-12-13 20:06:17
diky has the best answer for upcasing. Enter =upper(A1) in an empty field and hit enter, the value in that field is now the data in A1 in uppercase. Do this for whatever area you like. Then highlight whatever area has your new values (the cells with the formulas), right click, copy, click another cell, right click, paste special, click values, voila. Thanks, diky!


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

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Adelaide carvalho

Expertise

I will be able to answer any question on Excel and Visual Basic for Applications - class modules, recursive procedures and functions are my favourite

Experience


Past/Present Clients
Several readers of my Books think they are useful.

©2016 About.com. All rights reserved.