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:


This will return:

Boston Red Sox

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




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>