How to convert a sentence in upper case to first letter in upper and others are small
How to convert a sentence in upper case to first letter in upper and others are small
=Proper(A1)
Where A1 holds the the string to be converted.
As an alternative, if you only wish to capitalise the first character, you might use the formula below.
=UPPER(LEFT(A1,1))&MID(LOWER(A1),2,1000)
Note that the length of the string to be converted is limited here to 1001 characters. The number 1000 in the formula could be increased or decreased to cover the longest expected string.