USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
abra-ka-dabra
|
|
|
proper
|
|
|
capitalize
|
|
|
upper-case
|
Detailed explanation-1: -In cell B2, type =PROPER(A2), then press Enter. This formula converts the name in cell A2 from uppercase to proper case. To convert the text to lowercase, type =LOWER(A2) instead.
Detailed explanation-2: -The PROPER function transforms the initial character to the upper case and the other characters to the lowercase. The function in Excel converts user input text to the proper case. It is possible to use it to capitalize each word in a string.
Detailed explanation-3: -Tip: Use the formula =UPPER(A1) for all UPPERCASE; =LOWER(A1) for all lowercase.
Detailed explanation-4: -Type “=UPPER(” or go to “Insert” → “Function” → “Text” → “UPPER”. Input a text value by cell reference or manual input. Press the “Enter” key.