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?

" 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

Correct answer is option B Concatenate