Hard copy is hard copy.You can read it , experiment it , prepare notes and lot. So why read online samples when you can own a full copy for less than 4$ .Email [email protected]  to buy hard copy of the same. If you think the excel book can be improved please email the author at [email protected]
 

Home

How can we capitalize the first letter of a string?

 

In order that the data looks professional we would like to capitalize the first letter of a word.  For instance in the below figure ‘Capitalization in action’ we want to change ‘shivprasad koirala’ to ‘Shivprasad Koirala’. This can be achieved using the function ‘PROPER’. ‘PROPER’ takes in text and capitalizes the first letter.

Figure: - Capitalization in action

Hard copy is hard copy.You can read it , experiment it , prepare notes and lot. So why read online samples when you can own a full copy for less than 4$ .Email [email protected]  to buy hard copy of the same. If you think the excel book can be improved please email the author at [email protected]
 

Home

Hosted by www.Geocities.ws

1