Tuesday, 9 April 2013

Excel Function: PROPER



On Mon, Apr 8, 2013 at 11:55 AM, 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
Blogger Twitter LinkedIn  Google Plus Blog RSS

--
You received this message because you are subscribed to the Google Groups "Islamabadianz" group.
To unsubscribe from this group and stop receiving emails from it, send an email to islamabadianz+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 



--
-- 
For University of Pakistan Study Material Sharing, Discussion, etc, Come and join us at http://4e542a34.linkbucks.com
You received this message because you are subscribed to the Google
Groups "Study" group.
To post to this group, send email to http://ca13054d.tinylinks.co
For more options, visit this group at
http://004bbb67.any.gs

No comments:

Post a Comment

Note: only a member of this blog may post a comment.