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.

 

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 , Training And Development Director , Muhayal Assir National Hospital

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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.