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

Answer
Discuss

Answers

0
Selected Answer

Hello Akash,

Please try the PROPER() function.

=PROPER($A1)
Discuss

Discussion

Love you team, superb answer, thanks for quick revert, god bless your website!!!!!!!!!!!!!!!
Akash Sharma (rep: 28) 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.

Discuss


Answer the Question

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