How can i change small letter to capital letter in excel?
Answers
Answered by
0
This formula converts the name in cell A2 from uppercase to proper case. Toconvert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to converttext to uppercase, replacing A2 with the appropriate cell reference. Now, fill down the formula in the new column.
Similar questions