Question

How to convert small case to capital case in excel?

Answer 1

Answer:

In cell B2, type =PROPER(A2), then press Enter. This formula converts the name in cell A2 from uppercase to proper case. To convert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference.

Answer 2

Answer:Here are some steps

:-

1. Open M.S word

2. Select the text.

3. Now go in home tab .

4. now there is at upper side there is one symbol of A .

5. click on that.

6. When you click there are 4 options.

7. click here UPPERCASE.

===================================================

If you want to do direct then while typing, first click on caps lock and capital each letter.