With this, we covered how to convert data a lower-case text to upper case and upper-case text to lower case. ![]() Then apply this to all other cells by dragging the formula until data is available.Īs the text is converted to lower case, copy text and paste the data as similar to how we did in the upper case and delete the formula cells. In place of text, we will input the Cell Address of text that we want to convert to lower. Observe the below screenshot for reference. The syntax of lower is also similar to upper that is =LOWER(Text). Now we will convert the same months to lower case. This is also quite similar to the upper case function still we will see one example of how to convert to lower case.Ĭonsider the example which we already converted to upper case. Now we will see how to convert an upper-case text into lower case text. Up to now, we have seen how to convert small case to upper case. Then click on OK.Īfter deleting the column with formulas, we will get results as shown below. ![]() So, copy the data that is converted in uppercase and select cell A1 and right click then, the below pop up menu will appear.Ĭhoose the Paste Special option and select Values. Now data is converted to Upper case, but it is not in the required place of a spreadsheet. Then double click on the right bottom corner of the square.
0 Comments
Leave a Reply. |