PROPER function is used for changing the format of any text or string to PROPER or SENTENCE Case.
=PROPER(text)
Syntax Description:
text argument, is used to give the cell reference of the string or value that needs to be changed to Proper Case/ Sentence Case
text argument, “A2” is the cell reference for text that is to be changed to “PROPER CASE”
– Output in Cell “B2” is showing that the string is changed to Proper Case
– Output in Cell “B5” is including text and number and no impact in “Numbers” are shown
– Output in Cell “B8” has only Special Characters and there is no impact of “PROPER Case” function
– Number/ Punctuation/ Space/ Special Characters will not have any impact of Function
– If cell reference is not correctly provided in the function, then it will give output as “#VALUE!” (Error)
– Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us
In this tutorial, learn how to merge columns using Power Query. Follow this step-by-step guide to convert data into a table, merge columns seamlessly, and customize separators. Whether you’re a beginner or an advanced user, this tutorial will enhance your data manipulation skills and streamline your workflow. Master Power Query and optimize your data management processes effortlessly.
LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell
SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
Print Row Header on Each Page in Excel means that when you print your worksheet, the selected row (often the top row with column headers) will repeat at the top of every printed page. This ensures…
Add new line in Excel cell lets you type on multiple lines within the same cell. Instead of having all the text in one long line, you can split it up to make it easier…