Multiple choice general knowledge

You can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?

  1. & (ampersand)

  2. = (equal sign)

  3. (space)

  4. All of the above

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The ampersand (&) operator in Excel concatenates (joins) text strings from multiple cells. For example, =A1&B1 combines the text from both cells. The equal sign (=) starts formulas, and space is not a concatenation operator in Excel.