Re: [KM] Keep_Mailing Excel Function: PROPER

thank you sir.,

how can i convert the small letter of the first word of  a list of names in xl. sheet

On Mon, Apr 8, 2013 at 12:25 PM, Junaid Tahir <mjunaidtahir@gmail.com> wrote:

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.DailyTenMinutes.com

     

--
--
To post to this group, send email to keep_mailing@googlegroups.com
---
You received this message because you are subscribed to the Google Groups "keep_mailing" group.
To post to this group, send email to keep_mailing@googlegroups.com.
 
 

--
A.Sethumadhavan

--
Moderator: PALLAVI KATE
---
You received this message because you are subscribed to the Google Groups "keep_mailing" group.
To unsubscribe from this group and stop receiving emails from it, send an email to keep_mailing+unsubscribe@googlegroups.com.
To post to this group, send email to keep_mailing@googlegroups.com.
Visit this group at http://groups.google.com/group/keep_mailing?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.