Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Medhat Mohamed sayed Ahmed , HR Manager , Sercotex for Textile
Date de publication: 2016/03/11
Mohammed Hussain
par Mohammed Hussain , Senior Sales Executive , Mahmood Saeed Glass Industry

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

Abed Allah Omari
par Abed Allah Omari , Commissioning Processes Manager , AMICO

The Answer is B: Concatenate.

Faraz Shiwani
par Faraz Shiwani , Managing Partner , Shiwani Traders

& Operator

=concatenate() function

but try asap utilities.

Hiren Bhatt
par Hiren Bhatt , Finance Manager , Riyam Investment & Trading Est. LLC

B- Concatenate is the correct answer.

Muzammul Latif
par Muzammul Latif , Receivable Accountant , UTS Carrier LLC

B-Concatenate()

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

 

Utilisateur supprimé
par Utilisateur supprimé

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
par 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
par 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

 

More Questions Like This