Text Combination Operator Options

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
Explanation
  • The Ampersand (&) operator in MS Excel is used to concatenate (combine) text from two or more cells into one cell.
  • For example, =A1 & B1 will combine the text in cells A1 and B1 into a single string.
  • This question appeared in Past Papers (5 times)
    PPSC 5 Years Past Papers Subject Wise (Solved with Details) (2 times)
    PPSC Junior Clerk Past Papers and Syllabus (1 times)
    This question appeared in Subjects (1 times)
    COMPUTER (1 times)

    Install this app on your device for quick access right from your home screen.