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.
(Is the equivalent of 'Lowercase' in the Change Case list.In this example we will use the UPPER function to capitalize all of the letters in a list of names. \* Lower : Transforms all letters to lowercase. (Is the equivalent of 'Uppercase' in the Change Case list.) (Is the equivalent of 'Sentence Case' in the Change Case list.) \* FirstCap : Only the first letter of the first word is capitalized. (Is the equivalent of 'Title Case' in the Change Case list.) \* Caps : Capitalizes the first letter of each word. Tip: Here's a list of the different text format type codes: Now you can continue with the other steps to perform your mail merge.Type Shift+F9 and you will see the text displayed with the entered formatting.Now you need to add the desired format to this field, e.g.In this case, the original table Field Header in our Recipients list is called ""Name"".The code of your Merge field is now shown.Select the text field you wish to change and press Shift+F9.Perform the first different steps of the Mail Merge as usual (Start Mail Merge, Select Recipients and insert Merge Field).In this one I will explain how you can apply a lowercase, uppercase, … format to your text mail merge fields. In a previous blog post we saw how to change the Date format of Word Mail merge fields.
0 kommentar(er)
