HomeMicrosoft OfficeExcelHow to Change the uppercase string to title case in Microsoft Excel ?

How to Change the uppercase string to title case in Microsoft Excel ?

Microsoft Excel 2016 provides you with the PROPER function that lets you change the uppercase letters to title case. Let’s see an example of this.

How to Change the uppercase string to title case in Microsoft Excel ?

Assume that you have a text in cell A1 “THIS IS A DEVELOPER PUBLISH DEMO” and you wish to display it in title case in the cell B1.

Enter the following formula in A2 and press enter key

=PROPER(A1)

The cell A2 should display the string in title case.

image

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021