USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Concatenation of text can be done using
|
|
Apostrophe (’)
|
|
|
Ampersand (&)
|
|
|
Hash (#)
|
|
|
Exclamation (!)
|
Explanation:
Detailed explanation-1: -The ampersand (&) calculation operator lets you join text items without having to use a function. For example, =A1 & B1 returns the same value as =CONCATENATE(A1, B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.
Detailed explanation-2: -Ampersand (&) Was this answer helpful?
Detailed explanation-3: -The word CONCATENATE means to join or combine. The CONCATENATE function in Excel is used to combine the text from different cells into one cell.
There is 1 question to complete.