![]() ![]() Drag the selected area to fill the sequence, now you know the method of how to capitalize the first letter in Microsoft Excel. The first letter of original data has been capitalized in the first row. What is a mail merge Mail merge is a computer term describing the production of multiple (and potentially large numbers of) documents from a single template form and a structured data source. New text: the text that will replace characters in Old text. Num chars: the number of character in Old text that you want to replace. Start num: the position of the character in Old text that you want to replace with New text. Old text: text in which you want to replace some character. Note: the function LEFT(B2, 1) takes the first letter from cell B2, and UPPER(LEFT(B2, 1)) capitalizes the first letter. Then the Function Arguments pop-up window appears, use formula to make the change. When the Insert Function pop-up window appears, select Text in the box of Or select a category.Īnd select REPLACE in the box of Select a function, simply click OK. ![]() Next, find Formulas tab, click Insert Function in Function Library section. But do you know how to capitalize the first letter? The method is also simple.Įnter all data and select the first row of which you want to capitalize. When working with Excel, sometimes the data may not be very consistent when it comes to upper and lower case letters. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |