How to capitalize the first word in a cell

For example, you have the following the text in a cell “A1″:

boston red sox

If you’d like to capitalize all the words in ths cell, use this simple formula:

=PROPER (A1)

This will return:

Boston Red Sox

However, if you’d like to capitalize only the first word and not all words, use this formula:

=UPPER(LEFT(A1,1))&RIGHT(A1,LEN(A1)-1))

or

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

This leaves the rest of the string unchanged and capitalizes only the first word.

This will return:

Boston red sox

This entry was posted in General tips. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*