Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

In Ms Excel 2 columns data put in 1 row which formula you can use For Example C4 Date 30.5.2016 D4 Invoice No 100200 E5 31.5.2016100200?

Option are

A) =sum(C4+D4)

B) =CONCATENATE(C4," ",D4)

C) =CONCATENATE( A4, " ", B4, ", DOB: ", TEXT( C4, "mm/dd/yy" ) )

D) =CONCATENATE( "The Time is: ", A2 )

Data Marts Data Quality Data Reduction Data Analysis Data Archiving
user-image
Question added by Badar Iqbal , Distribution Manager & K.P.O , Dalda Foods LTd
Date Posted: 2016/05/31
Upvote (0) Views (3) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Badar Iqbal
by Badar Iqbal , Distribution Manager & K.P.O , Dalda Foods LTd

B) =CONCATENATE(C4," ",D4)

Gayasuddin Mohammed
by Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

concatenate function, simply combines your text info of different coloumns

simple =CONCATENATE(c4,D4) = 30.5.2016100200 ANSWER.

Write Your Answer
More Questions Like This