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

Upper case for first and last character in full name

0

Hi Respected Members,

What is the function to capitalize only first character in the first name and first character in the last name in below given list:

NAME vikash Kumar puneet khanuja trilok nath deepak yadav subhash singh yadav amit mishra sudarshan khan benson babu

Warm Regards,

Akash Sharma

excel
posted by: Akash Sharma (rep: 40) on Tue Oct 23, 2018 at 9:23 am
Answer
Discuss

Answers

0
Selected Answer

Hello Akash,

Please try the PROPER() function.

=PROPER($A1)
posted by: Variatus (rep: 4889) on Tue Oct 23, 2018 at 12:18 pm
Discuss

Discussion

Love you team, superb answer, thanks for quick revert, god bless your website!!!!!!!!!!!!!!!
Akash Sharma (rep: 40) Oct 23, '18 at 1:11 pm
Add to Discussion
0

If you have more than first and last name in a cell, use text-to-columns to first split the names and then use PROPER() function before combining them again.

Or, you can use a simple User Defined Function, to first split the words: excel function to get word from cell.

posted by: don (rep: 1989) on Tue Oct 23, 2018 at 1:11 pm
Discuss


Answer the Question

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