USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Separate text into two columns
|
|
|
Combine only numbers together
|
|
|
Add a character in the middle of a text string
|
|
|
Combine text strings together
|
Detailed explanation-1: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Detailed explanation-2: -Concatenation is the process of appending one string to the end of another string. You concatenate strings by using the + operator. For string literals and string constants, concatenation occurs at compile time; no run-time concatenation occurs. For string variables, concatenation occurs only at run time.
Detailed explanation-3: -The word CONCATENATE means to join or combine.
Detailed explanation-4: -In formal language theory and computer programming, string concatenation is the operation of joining character strings end-to-end. For example, the concatenation of “snow” and “ball” is “snowball".
Detailed explanation-5: -The CONCATENATE function in Excel is used to join different pieces of text together or combine values from several cells into one cell. The syntax of Excel CONCATENATE is as follows: CONCATENATE(text1, [text2], …) Where text is a text string, cell reference or formula-driven value.