Text functioning

0

How to convert a sentence in upper case to first letter in upper and others are small

Answer
Discuss

Answers

0
Selected Answer
=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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login