How to convert uppercase to lowercar text in cell excel?
Answers
Answered by
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.
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
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
----------------------------------------------------------------------------------------------------------------
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
Social Sciences,
8 months ago
Geography,
8 months ago
Economy,
8 months ago
Science,
1 year ago
Science,
1 year ago