PROPER function is used to capitalize the first letter of every word in a given string. All letters that do not follow any other letter are set to uppercase and rest to lowercase.
Visit us for daily dose of Excel Tips & Tricks at http://www.exceltip.com/
In case of any simple or complicated "Excel" query, you can ask to our experts for instant solution at http://www.excelforum.com/