Search This Blog

Thursday, September 6, 2012

How to make names in MS Excel Proper?

Proper(Text) - first letter caps


Once I had list of names in MS Excel, all are in small letters.
I want the first letter alone in the Capital letter.

Then I found PROPER() Capitalizes the first letter in a string and converts all other letters to lowercase letters.

Syntax

PROPER(Text)


About Me and My blog

Dear Friends,

I like to share my experience in computer programming in thin blog.
I have experience in VC++, VBA, PHP, MySQL and .net.

Soon I will post the issues I faced when I used some popular applications and in programming with solutions.