How can I capitalize the smaller words in Excel ?

Question added by Imtiaz Ahmad
Date Posted: 2016/03/09

Upvote (0) Views (3) Followers (1) Answers (1) Report Question

Write an Answer
Register now or log in to answer.

by Mohammed Bin Salmah , Procurement and Sales Engineer , Yemen Equipment & Supply - YES

Normally we use caps lock for capitalize the words but as I believe you are looking for different thing so that will help

https://support.office.com/en-us/article/Change-text-to-upper-lower-or-proper-normal-font-c4056aab-8053-498f-a764-c23c6ad1c244

Upvote (0)

Downvote Reply () Report

If you want to change small characters to capital characters in excel, which formula you will use if u want to change the first letter only?
Top Answer: there are many ways and solutions: =UPPER(LEFT(A1;1))&RIGHT(A1;LEN(A1)-1) =REPLACE(A1;1;1;UPPER(L ... See More

Answers (4)
How to change small letters to capital letters in excel?
Top Answer: Suppose you have text in A1 cell of the sheet please write in any other cell of the sheet below mentioned ... See More

Answers (1)
What kind of Computer skills does an HR require to know other than MS Office ( MS Word, Excel, Outlook and Powerpoint)?
Top Answer: They might need to know about some integrated HR systems for example : MENA ME ..... etc to facilitate ... See More

Answers (1)
How can we install word, excel and outlook via active directory?
Top Answer: Yua have to use scripts that can install office. and you can use Group policy for this. for more informat ... See More

Answers (2)