Excel - Set first letter in uppercase

October 2016


I need a formula to set the first letter of each word in upper-case.


Try this formula:

Basically, we extract the first letter on the left (LEFT()) which is then passed in uppercase (UPPER()), then extract the right side (RIGHT()) after the first letter (LEN(D2))- 1), concatenates all ...

Thanks to Rinos for this tip.

Related :

This document entitled « Excel - Set first letter in uppercase » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.