ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Which Of these formula can combine two cell's content into one cell? A- Sum() B- Concatenate() c- N()?

user-image
تم إضافة السؤال من قبل Medhat Mohamed sayed Ahmed , HR Manager , Sercotex for Textile
تاريخ النشر: 2016/03/11
Mohammed Hussain
من قبل Mohammed Hussain , Senior Sales Executive , Mahmood Saeed Glass Industry

It's (b) "concatenate" is the correct answer.

Abed Allah Omari
من قبل Abed Allah Omari , Commissioning Processes Manager , AMICO

The Answer is B: Concatenate.

Faraz Shiwani
من قبل Faraz Shiwani , Managing Partner , Shiwani Traders

& Operator

=concatenate() function

but try asap utilities.

Hiren Bhatt
من قبل Hiren Bhatt , Finance Manager , Riyam Investment & Trading Est. LLC

B- Concatenate is the correct answer.

Muzammul Latif
من قبل Muzammul Latif , Receivable Accountant , UTS Carrier LLC

B-Concatenate()

We can also use & function to add or merger two cells.

 

مستخدم محذوف‎
من قبل مستخدم محذوف‎

Select the cell in which you want to combine the contents of other cell

  1. To start the formula, type =(

  2.  select the first cell that contains the text that you want to combine, type&" "&  and then select the next cell that contains the text that you want to combine.
  3. To insert a comma, type &", "& 
  4. then enter

Firas Shahadi
من قبل Firas Shahadi , Human Resources Director , SAUDI UNION

Concatenate() function in the one.

but now with Excel 2016 there is a better function called 

TEXTJOIN()

Medhat Mohamed sayed Ahmed
من قبل Medhat Mohamed sayed Ahmed , HR Manager , Sercotex for Textile

B- Concatenate it the Right Answer ..

and you can use the "&" Operator to combine text in one cell

 

المزيد من الأسئلة المماثلة