Hi,
I am searching formula for Change the case as capital word to small but in this unable to search formula to gate first Letter of word should be Capital and rest all should be small.
for ex. DNYANESHWAR (I assumed as it is in A1 cell)
then I am using formula is =LOWER(A1) then answer is - dnyaneshwar.
But I want first letter should be Capital as = Dnyaneshwar
Also if there is a big sentence in capital form and i want to change it in Title Case.
So please help me for the same.
Bookmarks