Register now or log in to join your professional community.
MS Excel Case Changes:
If you need to change the case of text, such as people and product names, noufal chakkinga thodi and mohammed yaseen, uppercase, or lowercase, you don’t have to do a lot of retyping. In most cases, Flash Fill can do the work for you.
Here’s a list of names in lower case in column A. But let’s change the names to proper case, with the first letter in each name capitalized.
in Coulum noufal chakkinga thodi and mohammed yaseen to > Noufal Chakkinga Thodi and Mohammed Yaseen.
in the column next to your data, enter the first and last name in proper case, and press Enter.
short key : Ctrl+E or Data > Flash Fill.
.: Columan =PROPER(A1)
MS word:
Simply Select Text which you want to change case Press (Upper to lower and Lower to Upper) ctrl+shift+A
For reset text format : ctrl+shift+n