G gopalakrishnarao1 Board Regular Joined Nov 23, 2008 Messages 146 Nov 29, 2009 #1 I am having some data which are in capitals, Now I want to change this in this format. eg. GOPALA TO Gopala i.e. only first letter should be in upper case, rest should be in lower case. What I have to do?