
How to make small letter to capital letter
1. Insert a new column next to the text which you want to convert.
2. Type “=upper(select column for ex. A)” and press “Enter”
3. To apply all columns hold and drag
4. Now select and copy converted upper case column and click on “Paste” click “Paste Special” select “Values” and “Ok”
5. Keep course in your original column and press “Enter” and now you can delete the previous upper case column. (watch below video tutorial…)
How to Make Capital letter to Small letter
1. Insert a new column next to the text which you want to convert.
2. Type “=lower(select column for ex. A)” and press “Enter”
3. To apply all columns hold and drag
4. Now select and copy converted lower case column and click on “Paste” click “Paste Special” select “Values” and “Ok”
5. Keep course in your original column and press “Enter” and now you can delete the previous lower case column. (watch below video tutorial…)
The same method will work for “proper case” just change in “=proper(select column for ex. A)”
Watch video tutorial…. Please like, share and subscribe
No comments:
Post a Comment