How to lowercase first letter in Excel

Retrieve the first letter with LEFT, LOWER it, and then concatenate the rest with CONCATENATE + MID.

=CONCATENATE(LOWER(LEFT(A1,1)),MID(A1,2,LEN(A1)))

Here is a SUBSTITUTE version:

=SUBSTITUTE(A1,LEFT(A1),LOWER(LEFT(A1)),1)

enter image description here

Another to throw into the pot.

=replace(a2, 1, 1, char(code(a2)+32))

This will do the trick:

=REPLACE(A2,1,1,LOWER(LEFT(A2)))

Related