Finally you need to remove the first column with messy text. Please add Shift+F3 which cycles/toggles to change selected text from/to all caps, all lower case or initial caps. Nothing will seem to happen but in fact all your formulae have been deleted and replaced with the resulting corrected text.ħ. Right Click again on the same column header and select Paste / 123 (Value) see below)

Now Right Click on the new column header (in this case letter 'B') and select Copy (you should see 'marching ants' arround your selection. is there a way to have Word give each of the first words, i.e., run, walk, and talk, initial caps Now, I have to manually make each first letter. Tip: Just Double click the tiny black box (called the handle) at the bottom right corner of the cell with your formula in like this:Ħ. I am using Win 98 and Word 2000 When I set up a numbered listing, e.g., 1. And then drag the fill handle down to the cells that you want to apply this formula. Enter this formula: PROPER (A2) into a blank cell next to your data, B2 for instance, see screenshot: 2. Now you can easily copy the formula down the new blank column To make the first letter of each word within a cell capitalize, you can use the Proper function or a simple VBA code. You should find the first letter of each word is capitalised and the rest is lower caseĥ. Now click in the empty cell right of the first name and type in the following command: =PROPER(A2) then press the Enter Key (see this example)Ĥ. Here is an example of a dreadful muddle of text cases in column A.Īs you can see some names are in CAPITAL LETTERS some in lower case and some All jUMbLeD uP!Ģ. Add a column to the right (Right Click on 'B' and select Insert)ģ. With the instructions below, you can develop easy-to-use forms in Microsoft® Word 2003, 2007, and 2010. Microsoft Excel has some handy functions to change case - this is what you can do:ġ. Note: There is another formula as well for changing the case of words, like ‘PROPER’ however, we will be discussing only ‘UPPER’ in this article as ‘PROPER’ changes only the first alphabet of a word. When you check the Correct TWo INitial CApitals box, AutoCorrect examines each word you type in an Microsoft 365 program if it detects a word that starts with two consecutive capitals and that word appears in the dictionary, Word changes the second letter to lowercase.

However you can use this method So what do you do if you have a column of Names all typed in CAPITAL LETTERS?

Unlike Word, Excel does not have a change case facility.

Initial caps in word 2010