Excel Guides

Converting Text Case in Excel

You can convert the case of text in Excel using the UPPER, LOWER, or PROPER functions. For example, to convert a column of text to all uppercase, you would use the following formula:

=UPPER(A1)

To convert a column of text to all lowercase, you would use the following formula:

=LOWER(A1)

To convert a column of text to proper case (i.e. the first letter of each word is uppercase), you would use the following formula:

=PROPER(A1)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.