|
Answer» Hello!!!
Move to the Font group on the HOME tab and click on the CHANGE Case icon. PICK one of 5 case options from the drop-down list. Note: You can also select your text and press Shift + F3 until the style you WANT is applied. Using the keyboard shortcut you can choose only upper, lower or sentence case.
(Or)
This formula converts the name in cell A2 from uppercase to proper case. To convert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell REFERENCE. Now, fill down the formula in the new column.
Hope u find it helpful.......
|