Excel First Letter Capitalized

An Excel file that teaches how to perform Excel First Letter Capitalized operation.

Excel Powered First Letter Capitalized

The first character of the text and its continuation are handled separately. The first character is converted to uppercase and the remaining part is converted to lowercase. Empty cells and texts starting with numbers are checked. Batch application is made with array formulas. The results are shown in the control column.

Hope it is useful.