How to get a string in excel with only first letter is capital and rest of string in small letter?
This code will give the right string in excel.
In string First letter will be capital letter and rest of string will be in small letter.
try this really works.....
=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
In string First letter will be capital letter and rest of string will be in small letter.
try this really works.....
=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
Comments
Post a Comment