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.

2 responses to “how to Quick Capitalize the First Letter or Each Word in Excel”

  1. J. Windon says:

    That fabulous and fast. But when I no longer need column A and want to delete it, everything disappears from the column with al the Capitalization corrected. Now what?

    • skylar says:

      copy the corrected column, then when you go to paste into the wrong column, right click then click “paste values”

Leave a Reply

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