Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

If you want to combine 2 column in 1 row which formula do u use For example A5 Date B5 Invoice no. 115 Show in one colum 31.8.2015115?

Option are

a) vlookup

b) concatinate

c) =sum(a5+b5)

d) duplicate a colum ctrl+d

user-image
Question added by Badar Iqbal , Distribution Manager & K.P.O , Dalda Foods LTd
Date Posted: 2015/08/31
Faranak Moghadas Zadeh
by Faranak Moghadas Zadeh , Sales Executive , EMAC Engineering & Services

" C " is the correct answer 

Hi Badar

 

The question you have asked refer to excel function. So based on your qestion I would like tell you that we can combine values from two different columns (but in same row) by using concatenate formula.

 

By using concateneate formula you have further choice which value you like to appear first and second value also we can chhose any space or symbol between twon values...i.e 100   and 150 are two different values we can show like this:

 

100150

100,150

etc

Badar Iqbal
by Badar Iqbal , Distribution Manager & K.P.O , Dalda Foods LTd

Correct answer is option B Concatenate 

More Questions Like This

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