Multiple choice technology

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. -2146826259

  3. (space)

  4. None of the above

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

The ampersand (&) is the text concatenation operator in Excel and spreadsheets. It joins text strings from cells, just like the CONCATENATE function. For example, =A1&B1 combines the text from both cells, and =A1&' '&B1 adds a space between them. Option B appears to be an error code rather than a valid operator.