Computer Science, asked by anushajain3691, 1 year ago

How to convert uppercase to lowercar text in cell excel?

Answers

Answered by Jazzyminnows
1
Type the following values in a worksheet: A1: ABCD A2: EFGH A3: IJKL A4: MNOP A5: QRST A6: UVWX A7: YZ To make these cells lowercase in Excel 2007 or Excel 2010, follow these steps:   Type the following formula in cell B1: =LOWER(A1)In column B, select all the cells to the right of the cells that contain data in column A. In this example, highlight cells B1 through B7.Click Home, click Fill, and then click Down.

Note The new column now contains the lowercase version of the text in column A.

Note You can also fill cells B2 through B7 by clicking cell B1, and then dragging the fill handle to cell B7.
Highlight cells B1 through B7, click Home, and then click Copy.Click cell A1, click Paste, click Paste Special, click Values, and then click OK to paste the converted values back onto column A.Delete column B. To do this, click Home, click column B, and then click Delete.
Answered by Anonymous
4
uppercase to lowercar text in cell excel
----------------------------------------------------------------------------------------------------------------



Just follow the steps

:-



===================================================



1) Go in Excel

2) Select the text to which you have to change case.

3) Now right click

4) At upper corner there is one option

5) click on that

6) Now click on lowercase



----------------------------------------------------------------------------------------------------------------



This is not done only in Excel this can be also done in Microsoft word.



----------------------------------------------------------------------------------------------------------------


Currently there is no shortcut key to change cases

Similar questions