The good thing about this formula is that it will work with text that has lesser words as well.It’s an easy job to change the case of the text you are currently typing into a Word document. If your text has 4 words (4 spaces), it will be spread in 4 columns (A, B, C, D) and you have to add one more &upper(left(D1,1)) to the formula.
Your formula will be in column D as "=upper(left(A1,1))&upper(left(B1,1))&upper(left(C1,1))" Taking the example you have provided, there would be three columns - A, B, C - where the text would be. Based on the number of spaces, your text would be sitting in multiple columns and you can enter the formula in an empty column to add all the first characters of the different columns. But for the first one, we can solve it using the Text to column function to split the text at each space. For example, if there are two cases where the characters are same RWR, you might want to adjust one of them to differentiate. Second, there should not be any cases where you would want a different logic of shortening. So the number of spaces should be definable. First, how many spaces will be there in each of the text? Excel does not have a looping function to keep running for several times. There are a couple of challenges with this. The logic for your case is to find all the "spaces" and then convert the next character to uppercase and add them all into one string. Pick one of 5 case options from the drop-down list.Move to the Font group on the HOME tab and click on the Change Case icon.Highlight the text in your table where you want to change the case.
Feel free to discover how this method works. If you don't want to mess with formulas in Excel, you can use a special command for changing text case in Word. Use Microsoft Word to change case in Excel You'll see that changing case with the use of Excel functions is not difficult at all. Take it easy and try to go through all these steps yourself. This theory might look very complicated to you. Pick Entire column in the Delete dialog box and click OK.Right-click the selected helper column and choose the Delete option from the menu.Since you need only the text values, pick this option to avoid formula errors later. Click on the Values icon under Paste Options in the context menu.Right-click on the first cell in the original column.Highlight the cells that contain the formula and press Ctrl + C to copy them.Let's copy the values from the helper column and then get rid of it. I suppose you'd like to leave only the correct one. So you have two columns with the same text data, but in different case. Note: If you need to fill the new column down to the end of the table, you can skip steps 5-7 and just double-click on the fill handle. Insert a new (helper) column next to the one that contains the text you want to convert.Let's take the Excel uppercase function as an example.
The proper() function makes the first letter of each word capitalized and leaves the other letters lowercase (Proper Case).Īll three of these options work on the same principle, so I'll show you how to use one of them. The lower() function helps to exclude capital letters from text. The upper() function allows you to convert all lowercase letters in a text string to uppercase. Microsoft Excel has three special functions that you can use to change the case of text.