Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

how to Quick Capitalize the First Letter or Each Word in Excel

Date:2019-10-4 Author:Cordelia

When entering some specific information like company names or employee names into an Excel sheet, you may want to capitalize the first letter of each word in each cell. But instead of changing the text case one by one, can you do it in batch?

1. First of all, you can create a new column as assistant.

how to Quick Capitalize the First Letter or Each Word in Excel

2. Input the formula in B2: =proper(A2)

“A2” refers to the cell you want to change the text case.

how to Quick Capitalize the First Letter or Each Word in Excel

3. Press [Enter] to check the result.

how to Quick Capitalize the First Letter or Each Word in Excel

4. Then you can use Fill Handle to apply this formula to cells under B2.

how to Quick Capitalize the First Letter or Each Word in Excel

5. Now you’ve got the text with each word capitalized in column B.

how to Quick Capitalize the First Letter or Each Word in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *