![]() Method two is to click the Formulas tab and select the Text button in the Function Library group.Ī Function Arguments dialog box will pop up.įollow method one for the steps for the Function Arguments dialog box. Inside the dialog box, enter A2 in the Text box. In the Select a Function section, choose the Lower function from the list box.Ī Function Arguments dialog box will appear. Inside the dialog box in the Select a Category section, select Text from the list box. Method one is to click the fx button on the top left of the worksheet.Īn Insert Function dialog box will pop up. There are two other methods to use this function. To get the other results, drag the fill handle down. Type into the cell where you want to place the result, =LOWER(A2).Ī2 is the cell that contains the text you want to convert to lowercase. Write uppercase text into the cell or cells. Use Lower function to convert text into lowercase in Excel In this tutorial, we will explain how to use the Lower function to convert text into lowercase and the Upper function to convert text to uppercase. Text: The text that you want to convert to uppercase. Text: The text that you want to convert to lowercase. The formula for the Lower function is LOWER (text) and for Upper is UPPER (text). The Lower function’s purpose is to convert text into lowercase, and the Upper function converts text to uppercase. In Microsoft Excel, Upper and Lower functions are Text functions. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |