Change Text Into UPPER/LOWER/PROPER CASE in Google Sheets 

Do you want to quickly convert text to lower case, upper case or proper case in Google Sheets? Then simply use the “lower function”, “upper function” or “proper function”. Just write =lower/upper/proper() and select the range of the data you want to convert.
Then if you want to save this data permanently, copy it by pressing ctrl/cmnd + c and paste values only by pressing ctrl/cmnd + shift + v.