Excel - Set first letter in uppercase

December 2016

Issue


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

Solution


Try this formula:
CONCATENATE(UPPER(LEFT(D2;1));RIGHT(D2;(LEN(D2))-1))


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.