In the example image below, the original list of names that we are going to change the case of, is even messier than the list of names in the last example. In this example, we will use the PROPER function to capitalize the first letter of every name (both first and last), that is listed in a column.

The formula: The formula below, is initially entered into cell C2, and then copied into the cells below it for this example The logic: Use the UPPER function to capitalize the letters in the text that is found in the range A2:A15 The task: Capitalize every letter in a list of names For example, you might need to display the names in this way for a financial record, or perhaps you are using case sensitive formulas to lookup/match information.īy using the UPPER function in a Google spreadsheet you can automatically change every letter into the capitalized format that you require. In the example image below, you'll see that the original unmodified list of names is shown in the normal format that you'd expect a name to be displayed in (with only the first letter of each word/name being capitalized).īut let's say that for whatever reason, your task/job requires you to have names in all capital letters. In this example we will use the UPPER function to capitalize all of the letters in a list of names.

Make all text uppercase excel