Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Medhat Mohamed sayed Ahmed , HR Manager , Sercotex for Textile
Date Posted: 2016/03/11
Mohammed Hussain
by Mohammed Hussain , Senior Sales Executive , Mahmood Saeed Glass Industry

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

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

The Answer is B: Concatenate.

Faraz Shiwani
by Faraz Shiwani , Managing Partner , Shiwani Traders

& Operator

=concatenate() function

but try asap utilities.

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

B- Concatenate is the correct answer.

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

B-Concatenate()

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

 

Deleted user
by Deleted user

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