Sunday, 7 April 2013

[KM] Keep_Mailing 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.DailyTenMinutes.com
Blogger Twitter LinkedIn  Google Plus Blog RSS

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

No comments:

Post a Comment