How to convert letters to capital in excel?

Follow Icon
Edit IconEdit
Message IconMessage
Report IconReport

Available Answers: 1

Answer #1#
Subodh zxgwj
Mumbai, India

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.

(0)
Edit IconEdit
Comment IconComment
Report IconReport


Related Questions

Disclaimer

  1. Phone number or email id included in the answer(s) are not verified by us. Before calling on the mentioned number or sending an email do your own research and be confirm you calling or sending mail to right person or company.
  2. Answer(s) may contain affiliate links. By clicking such link, you will be redirected to third party website. If you make any purchase then the answer publisher or we may earn little amount of commission.