Excel Formula: Change Case of First Letter Only

This formula changes the case of the first letter of cell text and doesn’t change the remaining text in the cell.

=REPLACE(C2,1,1,UPPER(LEFT(C2,1)))

Loading...