Skip to content

Change the Case of Text

This article will show you how to change the case of text in a spreadsheet.

What does that mean? Here are a few examples.

  • Change “strong” to “STRONG”
  • Change “STRONG” to “Strong”
  • Change “Strong” to “strong”

Luckily, spreadsheets include built-in functions that make changing the case of any text very easy.

Change Any Text to All Capital Letters

You can use the UPPER function to change any word or sentence to include only capital letters.

The UPPER function is simple and easy to use.

This function requires one argument. The argument may be any typed text or a reference to a cell containing text.

The function returns the text with every letter capitalized.

Change Any Text to All Lower Case Letters

You can use the LOWER function to change any word or sentence to include only lowercase letters.

The LOWER function is simple and easy to use.

This function requires one argument. The argument may be any typed text or a reference to a cell containing text.

The function returns the text with each letter in lowercase.

Capitalize the First Letter in Each Word

You can use the PROPER function to capitalize the first letter in any word.

The PROPER function is also simple and easy to use.

This function requires one argument. The argument may be any typed text or a reference to a cell containing text.

The function returns the text with the first letter of each word capitalized.

This might be a good function to use when working with names!

And that’s how you can go about changing the case of text in a spreadsheet.

Thank you so much for reading. Leave a comment below if you have any questions or other ideas you would like to share. We always love hearing what you have to say!

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top