Sunday 7 April 2013

[HM:255914] 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

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/
 
https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ
 
---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment