Capitalize First Letters of Words in Cells in Excel
Edited by Djinu, VisiHow, Eng
You're watching VisiHow. In this video, we're going to show how to capitalize the first letters of words in Microsoft Excel.
- 3Alternatively, you can click the "A1" cell instead of typing it. Now, you'll see that Excel will have capitalized the name. In cell "B1", "Mike Holmes" appears with the first letters capitalized.Type the "=proper(A1)".Advertisement
That was how to capitalize just the first letter of each word in a cell using the Microsoft Excel "PROPER" function. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!
Video: Capitalize First Letters of Words in Cells in Excel
Referencing this Article
If you need to reference this article in your work, you can copy-paste the following depending on your required format:
APA (American Psychological Association)
Capitalize First Letters of Words in Cells in Excel. (2016). In VisiHow. Retrieved Apr 27, 2017, from http://visihow.com/Capitalize_First_Letters_of_Words_in_Cells_in_Excel
MLA (Modern Language Association) "Capitalize First Letters of Words in Cells in Excel." VisiHow, visihow.com/Capitalize_First_Letters_of_Words_in_Cells_in_Excel Accessed 27 Apr 2017.
Chicago / Turabian VisiHow.com. "Capitalize First Letters of Words in Cells in Excel." Accessed Apr 27, 2017. http://visihow.com/Capitalize_First_Letters_of_Words_in_Cells_in_Excel.
Categories : Microsoft Suites
Recent edits by: VisiHow, Djinu