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?

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

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 )

Question ajoutée par Badar Iqbal , Distribution Manager & K.P.O , Dalda Foods LTd
Date de publication: 2016/05/31

Apprécier (0) Vues (3) Suiveurs (2) Réponses (2) Report Question

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

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

par 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.

What is the function of Macros in MS Excel ?
Top Answer: If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then it ... Voir Plus

Réponses (154)
What is the function of Macros in MS Excel ?
Top Answer: If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then it ... Voir Plus

Réponses (154)
Could you please specify any situation you have applied conditional formatting in ms excel for your business analysis?
Top Answer: Yes -Applying data bar gives an indication of cell value ... Voir Plus

Réponses (6)
What are the functions defined in MS Excel but not listed in function's guide ? and is it possible to customize a function through Microsoft VBA ?
Top Answer: there are some functions that are not listed in the functions list like: DateDif(), which Microsoft tries ... Voir Plus

Réponses (3)

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?