[www.keralites.net] Excel Function: PROPER

 

PROPER
		Original Text	Proper
		alan jones	Alan Jones	=PROPER(C4)
		bob smith	Bob Smith	=PROPER(C5)
		caRol wILLIAMS	Carol Williams	=PROPER(C6)
		cardiff	Cardiff	=PROPER(C7)
		ABC123	Abc123	=PROPER(C8)
	What Does It Do ?
	This function converts the first letter of each word to uppercase, and all subsequent letters
	are converted to lower case.
	Syntax
	=PROPER(TextToConvert)
	Formatting
	No special formatting is needed.

M Junaid Tahir

---

www.keralites.net

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 54

Visit Your Group

KERALITES - A moderated eGroup exclusively for Keralites...
To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: www.keralites.net

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___