Introduction to Strings
Strings are blocks of text that appear in Excel, like names of people, names of cities, e-mail addresses, or names of items sold in a store. When we type strings into Excel, we always use quotation marks around them to tell Excel that what it’s about to read is one coherent block of text.
What are String Functions in Excel ?
In Excel, there are multiple string (text) functions that can help you to deal with textual data. These functions can help you to change a text, change the case, find a string, count the length of the string, etc. In this post, we have covered top text functions.
Download Practice files for Text Functions
Download Excel Text Sample Files to move along with the tutorial and master the skill of using LEN Function in Excel.
What is PROPER Function in MS Excel ?
The PROPER function returns the text string into a proper case. In simple words, with a PROPER function where the first letter of the word is in capital and rest in small (proper case).
Syntax of PROPER Function
PROPER(text)
Arguments of PROPER Function in MS Excel
- text: The text which you want to convert to the proper case.
Example of PROPER Function
In the below example, we have a proper case that has the first letter in the capital case in a word and the rest of the letters are in the lower case compared to the other two cases lowercase and uppercase.
In the below example, we have used the PROPER function to streamline first name and last name into the proper case.
