🎴 Flashcard Mode
general knowledge Online Quiz - 2753
Card1 / 20
Mastered0
Review0
QuestionClick to flip
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?
AnswerClick to flip back
A
& (ampersand)
💡 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.