Excel Guides

Converting Cells to Proper Case in Excel

To convert cells to proper case in Excel, you can use the PROPER function. This function converts all letters in a cell to proper case, where each word is capitalized.

To use the PROPER function, you need to enter the following into a cell:

=PROPER(cell reference)

For example, if you wanted to convert the contents of cell A1 to proper case, you would enter the following into another cell:

=PROPER(A1)

You can also use the PROPER function on multiple cells at once. To do this, you would enter the following into a cell:

=PROPER(cell range)

For example, if you wanted to convert the contents of cells A1:A10 to proper case, you would enter the following into another cell:

=PROPER(A1:A10)

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.