Which is the correct way to concatenate two text values contained in cells Al and B1 in Excel?
a) =A1 & B1
b) =A1 + B1
c) A1 & B1
d) A1+ B1
Answers
Answer:
The correct way to concatenate two text values contained in two cells A1 and B1 is = A1 & B1.
EXTRA INFORMATION:-
Concatenate helps helps to combine the values of two cells in a spreadsheet.
Example:- = CONCATENATE(A1,B1) OR = A1 & B1.
Here, '&' acts as the command 'CONCATENATE'.
Note:- If you use " " between the cell names in the command, you will be able to add space between the text.
For example:- = A1 & " " & B1
People would misunderstand the two tes related to Excel that is concatenate cells and merge cells.
Merge cells help to merge the two cells whereas the concatenate option helps to join the text inside two cells.
Concatenate is one of the function's, hence we will be able to find it under the formulas with other predefined formulas like sum and average.
In the function library group in formulas and we will be able to find autosum option under which these predefined formulas are available.
Answer:
=A1&B1
Explanation:
Please mark me as brilliant