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. |