Multiple choice

Which operator is known as Concatenation Operator in Excel?

  1. %

  2. $
  3. &

  4. #

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

The ampersand (&) symbol is Excel's concatenation operator, used to join or combine text strings from different cells. For example, =A1&B1 combines the contents of cell A1 and B1 into a single text string.