{"id":1265,"date":"2018-07-02T17:24:50","date_gmt":"2018-07-02T17:24:50","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1265"},"modified":"2023-11-03T11:18:08","modified_gmt":"2023-11-03T11:18:08","slug":"proper","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/proper\/","title":{"rendered":"PROPER function"},"content":{"rendered":"\n
Excel PROPER Function converts text to proper case, where the first letter of each word is capitalized and all other letters are in lowercase.<\/p>\n\n\n\n
PROPER(text)<\/strong><\/p>\n\n\n\n To use the PROPER function, follow these steps:<\/p>\n\n\n\n Let’s say you have the following text in cell A1: “hello world.”<\/p>\n\n\n\n Enter If you have the text “exCEL fuNCTIONs” in cell A1, entering Note:<\/strong> The PROPER function will capitalize the first letter of each word in the text and convert the remaining letters to lowercase.<\/p>\n\n\n\n The PROPER function is useful when you have text data that is not consistently in the proper case format, and you want to make it more readable or consistent. It’s commonly used in data cleaning and formatting tasks in Excel.<\/p>\n","protected":false},"excerpt":{"rendered":" Excel PROPER Function converts text to proper case, where the first letter of each word is capitalized and all other letters are in…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
text<\/strong><\/td> The text you want to convert to proper case.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
\n
Examples<\/h2>\n\n\n\n
=PROPER(A1)<\/code> in another cell, and it will display “Hello World.”<\/p>\n\n\n\n
=PROPER(A1)<\/code> in another cell will yield “Excel Functions.”<\/p>\n\n\n\n
Additional Information<\/h2>\n\n\n\n