Excel - Capitalize First Letted in each cell


Is there way to capitalize the first letter in each cell of Excel? (with and without the use of a formula).

Who is Participating?
Orion NewmanConnect With a Mentor Director of Data ServicesCommented:
yes the formula is called PROPER

add a column next to the column you want to capatalize and use the =proper() formula.

Not sure about doing it without a formula.
pauloaguiaConnect With a Mentor Commented:
Or, if you just want to capitalize the very first letter, instead of the first letter of every word:
=UPPER(LEFT(A1,1)) & MID(A1,2,9999999)
SANTABABYConnect With a Mentor Commented:
I assume that you want to just capitalize the first letter for the whole cell (not each word in the cell).
Try the following:
If your orginal content is in Coulmn A, Use the following formula in the target cell (i.e. where you want to see the content with first letter capitalized):
This formula applies to the first row, however you can copy paste for other rows (i.e to convert A2, A3.... etc.)
tahirihAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.