Suppose you have a string - Hello! HOW are you doing - with cell reference C54. Now you need to convert the first letter of every word as capital and rest characters in lower case.Which of the following is the correct function for the same? Answer choicesSelect only one optionREVISITLOWER(C54)UPPER(C54)PROPER(C54)PROPERL(C54)
Question
Suppose you have a string - Hello! HOW are you doing - with cell reference C54. Now you need to convert the first letter of every word as capital and rest characters in lower case.Which of the following is the correct function for the same? Answer choicesSelect only one optionREVISITLOWER(C54)UPPER(C54)PROPER(C54)PROPERL(C54)
Solution
The correct function to use in this case is PROPER(C54). This function in Excel converts the first letter of each word in a text string to uppercase and all other letters to lowercase.
Similar Questions
Which of the following function will change the first letter of every word to Upper Case in excel? FirstUpper Tittle Proper Mid
Which function helps in changing the text to uppercase in Excel?Answer( Please choose a correct answer ) CLEARLOWER()CAPITAL()UPPER()BIG()
Which method can be used to return a string in upper case letters?
How can you convert a lowercase character to uppercase manually in a string?
You have text in Cell B2 which is in Capital Letter and you want to change the text to Small Letter, which of the following will change the text for you? Lower=(B2) =LowerCase(B2) =SmallCase(B2) =Lower(B2)
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.