Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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