Remove zeros from cell results

[Tucker92]

I am currently using a simple formula that looks like this

=A1&","&A2&","&A3 and so on until A30

My cells have vlookups in them and some of them come back as blank.

Because of my fomula i end up getting something like this

,,,,342,,,,,

Is there anyway i could skip the blank cells

Thank you in advance

 

[svorm]

if(counta(a1:a30)<30;"";A1&a2&......)

 

[Tucker92]

No that hasnt hidden the commas from the blanks or if i change the vlookup to show 0's instead of blanks they are still there as well

It comes up as 0,0,0,0,342,0,0,0,0 or just ,,,342,,,,, if the cells are shown as blanks

 

[jtakw]

Hi, you can do this, add to formula until A30:

Book1
	A	B	C
1			3,4,2
2
3	3
4	4
5	2
6
7
Sheet524

Cell Formulas
Range	Formula
C1	=SUBSTITUTE(TRIM(A1&" "&A2&" "&A3&" "&A4&" "&A5&" "&A6&" "&A7)," ",",")