In MS Excel 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?

Review the verified answer and explanation for this PPSC Punjab Public Service Commission past-paper question on CampusFin.

In MS Excel 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? Answer: Ampersand

The ampersand (&) operator in Excel is used to concatenate text from two or more cells into one cell. For example, =A1 & B1 joins the contents of cells A1 and B1.

Question context

This question is part of 📁 Microsoft Office within the broader 💾 Computer Science subject and appears in the PPSC Punjab Public Service Commission preparation collection. Reviewing the answer together with nearby questions helps reinforce the underlying concept and identify how it may appear in competitive exams.

In MS Excel 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?

Question context

Related questions