Please help with a formula

[Djoshua]

Im new on excel and want to put information from 5 different cells all into one cell but the information extracted from the 5 different cells should be separated by a "," in the cell that it gets inserted in. And if there is blank in one of the 5 cells then it should not just put in a ",".

For example
Cell A1 :house 1 Then in Cell B1: House 1,Wall Street,New York,1252
Cell A2: Wall Street
Cell A3: "blank" NB Not:House 1, Wall Street,,New York,1252
Cell A4:New York
Cell A5: 1252

But if there was something in Cell A3 then it gets inserted in cell B1 with the rest of the info.

If someone could please give me some advice on what to do I would really appreciate it

 

[VoG]

Try

=SUBSTITUTE(A1&","&A2&","&A3&","&A4&","&A5,",,",",")

 

[barry houdini]

Try

=SUBSTITUTE(IF(A1<>"",","&A1,"")&IF(A2<>"",","&A2,"")&IF(A3<>"",","&A3,"")&IF(A4<>"",","&A4,"")&IF(A5<>"",","&A5,""),",","",1)

 

[Djoshua]

Thank you buddy works perfectly!! you are awesome!