How to Capitalize the First Letter of Text in Excel

Is there an easy way to format cells in Excel to automatically capitalize the first letter of text in a cell?
by

Excel makes it easy to capitalize the first letter of every word in a cell.  To capitalize each word you simply need to use the formula =PROPER().   For instance, if you have data in the cell A1, then you would want to enter the following formula in cell B1: 

=PROPER(A1)

This would capitalize each word in A1, and output the text in the cell B1.

 


0
0

Add your comment

by Anonymous - Already have an account? Login now!
Your Name:  

Comment:  
Enter the text you see in the image below
What do you see?
Can't read the image? View a new one.
Your comment will appear after being approved.

Related Posts


This tutorial will teach you how to use the SUM function in Microsoft Excel to add column values together in order to calculate a total amount.  more »

Learn how to add two or more cells together in Microsoft Excel.  more »

The following is a step-by-step example of how you can easily import delimited text files into Microsoft Excel. You can use the Excel Text Import Wizard to quickly import files delimited by Tab, Semicolon, Comma (also known as Comma Separated Value (CSV) file format), Space or Other (you choose), or divided by fixed width columns.  more »

Often times when using formula's in Excel, you want to keep just the text values that a formula outputs while deleting the actual formula from the cells. To keep a value in a cell while removing the formula that produced the value try the following: Type...  more »