Convert text to Initial-Case (Capitalizes the first letter in Text) in Excel

PROPER function
Capitalizes the first letter and any other letters in text that follow any character other than a letter in a text string. Converts all other letters in lowercase.


The PROPER function syntax has the following arguments:

  • Text    Required. Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.


Type your data in C3 cell

and then type the proper function in cell G3

Here is the result

Helpful Resources of PowerBI & DAX

Video: VLOOKUP: When and how to use it

Video: VLOOKUP: When and how to use it

Microsoft introduces Microsoft Dynamics CRM updates 2016

Microsoft today announced new capabilities that will be delivered later this year in Microsoft Dynamics CRM 2016. The updates are designed to make the software easier to use and include even deeper integration with other Microsoft business applications such as Office 365, Word, Excel, onedrive, Cortana and Delve.

Excel Templates Free Download : Employee Attendance Record

This visual tracker will allow you to track the attendance of each of your employees at a glance

 Click here to download Employee Attendance Template

Recommended for You


Related Posts Plugin for WordPress, Blogger...