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.
- 3Type the "=proper(A1)".Alternatively, 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.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 Mar 25, 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 25 Mar 2017.
Chicago / Turabian VisiHow.com. "Capitalize First Letters of Words in Cells in Excel." Accessed Mar 25, 2017. http://visihow.com/Capitalize_First_Letters_of_Words_in_Cells_in_Excel.
Categories : Microsoft Suites
Recent edits by: VisiHow, Djinu