concatenate date cells with text cells, some comma missing

[basavarajkh]

Hi

I have some date in column A, & I already concatenate A1 & B1 with below formula


=TEXT(A2,"dd/mm")&" "&B2


& in cell C3 comma is missing

please help me to write formula.


Pls Find Link below

http://speedy.sh/ZqPWc/ex.xlsx


Thanks in Advance

 

[oldchippy]

Hi,


Try this one


=TEXT(A3,"dd/mm")&" "&TEXT(B3,"#,#")