To convert text in a specific cell to proper case, you simply enter the PROPER function followed by the cell reference in parentheses. The PROPER function is particularly useful for formatting names or titles in your spreadsheet to ensure consistency in how text is displayed.
The basic syntax for the PROPER function in Google Sheets is:
=PROPER(text)
Where text refers to the text string that you want to convert to proper case, or the reference to the cell containing the text.
To convert the text directly within the formula:
=PROPER("hello world")
If you want to convert the text in cell A1 to proper case, you would use the following formula:
=PROPER(A1)
Tip: After entering the PROPER function in the first cell (e.g. B1 as =PROPER(A1)), you can drag the fill handle (the small circle at the bottom right corner of the cell) down or across to quickly apply the same formula to adjacent cells, adjusting the cell references automatically.
You can also combine the PROPER function with other functions for more complex transformations. For instance, to trim leading and trailing spaces before converting to proper case, you could use:
=PROPER(TRIM(A1))
Below is an example:
This combination ensures that extra spaces are removed before the text is converted to proper case.
We hope that this article has helped you and given you a better understanding of how to change text to proper case in Google Sheets. If you enjoyed this article, you might also like our articles on how to set up a foreach loop in Google Sheets and how to switch to view-only mode in Google Sheets.
