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.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Use

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