DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Proper
|
|
|
Apt
|
|
|
Cap
|
|
|
Formal
|
Detailed explanation-1: -In the example below, the PROPER function is used to convert the uppercase names in column A to proper case, which capitalizes only the first letter in each name.
Detailed explanation-2: -The PROPER function, whose purpose of existence is to capitalize the first letter of each word. Suppose you have a dataset as shown below and you want to quickly convert the first letter of each word into upper case. This would capitalize the first letter of each word in the referenced cell.
Detailed explanation-3: -In the above program, the regular expression (regex) is used to convert the first letter of a string to uppercase. The regex pattern is /^./ matches the first character of a string. The toUpperCase() method converts the string to uppercase.
Detailed explanation-4: -Select the text, and right-click on it to see the text options. Hover over the Transformations menu. Select the case you want (the Capitalize option will capitalize the first letter of every word).
Detailed explanation-5: -The PROPER function will automatically reformat the text so that all words are capitalized. At the same time, it will convert to lowercase all other text.