Capitalize Only the First Letter of the First Word Only Once you have the desired result, you can copy the cells that have the formula and paste it as values so it’s no longer linked to each other. This would capitalize the first letter of each word in the referenced cell. Suppose you have a dataset as shown below and you want to quickly convert the first letter of each word into upper case.īelow is the formula you can use: =PROPER(A2) The PROPER function, whose purpose of existence is to capitalize the first letter of each word. This one is fairly easy to do – as Excel has a dedicated function for this. Only the first letter of the first word.There can be two scenarios where you want to capitalize:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |