Choose your language

First Capital Letter

Basic Exercise


Statement

Transcribe the names from column A to column B while making the first letter a capital letter.


Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: Divide the names into two parts (left and right). Apply the Ucase function only for the first letter (left part).

Note: In a future exercise (VBA Text to Columns) you will find that this exercise can be solved in a very simple way: StrConv("target_string", vbProperCase).


Show Answer

Download exercise Download answer



SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2019 SuperExcelVBA | ABOUT

Protected by Copyscape