Loading
Loading
  • Home

  • Productivity

  • App tips

App tips

3 min read

How to capitalize or change the case of text in any app

Automatically convert the case of your text in Word, Excel, Google Docs, and more.

By Matthew Guay · December 13, 2022
capitalize-text-titlecase primary img

Capitalization isn't something you have to think much about. The first letter of a sentence gets capitalized, along with any proper nouns—and you write in all caps when you're angry (or excited, depending on who you ask).

As long as you type with the capitalization you want, everything's fine. But when you go to write a long title and have to hold Shift for every first letter or when you write a few sentences without realizing caps lock was on, capitalization can suddenly get more frustrating. It can take seemingly forever to edit each letter back to the case you want—and it's so easy to miss the stray cApital letter in a long essay or blog post.

Here's how to automatically capitalize text properly in Word, Google Docs, and other text editors—and in thousands of other apps using Zapier's Formatter tool.

How to change case in Word

If you're working in Microsoft Word, it's easy to change the capitalization or case of text in your document.

  1. Select your text.

  2. In the Home section of the toolbar, click the Change Case option. (It's right next to your font options: a capital and lowercase Aa with a dropdown arrow.)

  3. Select the case you want.

Your options are: Sentence case., lowercase, UPPERCASE, Capitalize Each Word, or tOGGLE cASE to swap your writing's current case—perfect for the times you swap capital and lowercase accidentally.

Changing the text case in Microsoft Word

Or you can highlight the text and use Word's keyboard shortcut—Shift + fn + F3—to change selected text between lowercase, UPPERCASE or Capitalizing Each Word.

How to change case in Excel

It's a little more complicated in Excel—you'll need to use a formula to get the job done.

  • To make text uppercase in Excel, use the formula =UPPER(A1:A99), where A1:A99 is the cell range you want to change.

  • To make text lowercase in Excel, use the formula =UPPER(A1:A99).

  • To make text Title Case in Excel, use the formula =PROPER(A1:A99).

In every case, you'll need to put the formula in another cell, and the new text will show up in that cell or column.

Converting case in Excel

How to capitalize text in Google Docs

Google Docs also includes a capitalization tool, hidden in its menus.

  1. Select your text.

  2. Click Format > Text > Capitalization.

  3. Choose the case you want (lowercase, UPPERCASE, or Title Case).

Changing the capitalization in Google Docs

How to capitalize text on macOS

Change capitalization in TextEdit with the built-in macOS text transformations

Using a Mac? Lots of apps on your Mac already includes macOS's built-in spelling and grammar checks along with text transformations.

In most Mac apps:

  1. Select the text, and right-click on it to see the text options.

  2. Hover over the Transformations menu.

  3. Select the case you want (the Capitalize option will capitalize the first letter of every word).

The capitalization options in Messages on a Mac

If you don't see the options in the right-click menu, check the gear icon in the app's font settings—that's where Pages and other Apple apps put those same transformations.

How to capitalize text in Sublime Text

One of the most popular code and text editors Sublime Text also includes a capitalization tool.

  1. Select your text.

  2. Click Edit > Convert Case.

  3. Select the case you want.

Capitalize text in Sublime Text

In addition to the standard options, Sublime Text also includes snake_case (lowercase, with an underscore between each word) and kebab-case (lowercase, with a hyphen between each word).

How to convert case online

Convert Case

Another option is to use a web app to format your text. There are a number of simple web apps that can swap your case for you.

  • In TitleCase, type or paste in your text, and then choose the case you want to automatically convert your text to.

  • In Convert Case (pictured above), type or paste in your text, then choose each of the case options you want. It'll give you your text in all of those cases for a quick way to pick what looks best.

Automatically convert text case with Zapier

These tips work great for changing your capitalization within an app, like if you want to convert caps to lowercase in an article you're writing. But if you want to change capitalization as you send information from one app to the other, here's how to automatically convert text case with Zapier.

Related reading:

This article was originally published in September 2017. The most recent update was in December 2022.

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'