Please suggest

KapardhiSarma

New member
Joined
Dec 6, 2012
Messages
5
Reaction score
0
Points
0
Hi,

I have a requirement to convert the first word of the letter to upper case, and every first word after a '.' should be an upper case.

See my requirement below.

kapardhi.p.v.k should be changed to KapardhiPVK

Please help.
 
Use

=SUBSTITUTE(PROPER(A2),".","")
 
Back
Top