0
It can be done using a function called Upper. This is how you would do it:
Say the cells you wanted to capitalise were in the cells A1, B1, C1 and so on. In a blank cell, with free cells beside it type in the formula =Upper(A1) and it will show the text in A1 as all capitals. Copy it across into the corresponding cells so you get the capitalised versions of the other cells. Then select all the cells that you have put those formulas into. Do a copy, using the edit menu or Ctrl-C or clicking the copy icon on the toolbar or whatever your preferred method is. Then click on cell A1. Go to the Edit menu and select Paste Special. In the dialog box that pops up, click on the radio button beside Values and then click OK. The cells from A1 onwards will be replaced with the capitalised values of their initial values. Using this approach you could do this for any of the text in the sheet.
A word of warning: Just do it for plain text cells and not for any cells with other formulas as you may disrupt your calculations and formulas that are in them.
Wiki User
∙ 14y ago
Wiki User
∙ 14y ago=UPPER(A1)
where A1 is cell number which contains lower case
use the above formula in different cell where u get the upper case of A1 word
Add your answer:
Earn +20 pts
How can change small letter text to capital letter text viz virsa in word excel?
Highlight what you want to change, press Shift+F3 to switch between "all small letter", "all caps" and "only first letter of words caps".
How do you convert font lower case to uppper case in excel sheet?
You use the Upper function. So if the text is in A1, then in another cell put the formula: =UPPER(A1) The Lower function will change from upper case to lower case. The Proper function will give you a capital letter at the start and small letters for the rest. =LOWER(A1) =PROPER(A1)
How to change the width of a bar to automatically fit words in excel?
Open the sheet which you want to adjust the width. Click on the small triangle (located on top left above 1 and to the left of A) This will select the entire sheet. Now place your cursor between two columns until you see a cross. Double click and your cell width will be adjusted based on the content.
How does small business's capital structure change over time?
because they suck !!!
How can you change capital letters to small letters in MS Office 2007?
If they have already been typed, in Microsoft Word and Powerpoint select them all and then press Shift-F3 and you can change between the different case options, including upper, lower and sentence case. In Excel, you need to use the LOWER function.
How convert small letter in capital later?
In Excel you can use the UPPER function. You can put a cell reference into it or even specific text. =UPPER("change this") This will result in CHANGE THIS. =UPPER(A3) This will display the content of cell A3 in uppercase in the cell that the formula has been typed into.
How do you encrypt a single worksheet in Excel 2003?
From my recolection you cannot encrypt a single worksheet. You can password the sheet, and you can hide the data There is a small programme that's does encrypt called NCrypt XL
How can you change small letters to capital letter in Microsoft word?
There are various options of changing small letters to capital letters in Microsoft Word. You can use the task bar to change to upper case or press shift and f3 on your computer keyboard.
How can text transfer from capital to small in excel?
You need to use the LOWER function and put the cell reference or text in the brackets: =LOWER(A1) =LOWER("I WANT THIS TO BE IN LOWER CASE")
How could you change the sheet names that appear on your sheet tabs at the bottom of each worksheet in excel?
left mouse click on the tab that you want to rename (this is called setting the focus). Then Right mouse click on it and a small menu appears - left mouse click on the RENAME option and the tab will trun from white background and black text to black background and white text. Type in the name you wish the worksheet to be called then left mouse click on the work sheet anywhere to keep that name in the tab
What does the cell pointer change to when pointing at the small black square at the bottom right corner of the active cell in Microsoft Excel?
thin black cross
Does cell references in formulas have to be entered in uppercase?
No. You can type in lower or upper case and you can include spaces. When the formula has been entered Excel will change cell references and function names to uppercase and remove unnecessary spaces.
