Removal of additional commas

[shakaka]

Hi all,

I have a spreadsheet which looks like this:

A1 = 1 B1 = C1 = =IF(ISTEXT(B1),A1,"")
A2 = 2 B2 = Jonny C2 = =IF(ISTEXT(B2),A2,"")
A3 = 3 B3 = C3 = =IF(ISTEXT(B3),A3,"")
A4 = 4 B4 = Rich C4 = =IF(ISTEXT(B4),A4,"")
A5 = 5 B5 = Dave C5 = =IF(ISTEXT(B5),A5,"")
A6 = 6 B6 = C6 = =IF(ISTEXT(B6),A6,"")

My formula at C7 is =CONCATENATE(C1, ", ",C2,",",C3,",",C4,",",C5,",",C6,)
This returns the following: ,2,,4,5,
How do I remove the double comma with a formula,

Thanks in advance

[Jonmo1]

Try

=SUBSTITUTE(TRIM(CONCATENATE(C1," ",C2," ",C3," ",C4," ",C5," ",C6))," ",",")

[shakaka]

Will give it a bosh,
Thanks

[shakaka]

Try

=SUBSTITUTE(TRIM(CONCATENATE(C1," ",C2," ",C3," ",C4," ",C5," ",C6))," ",",")

Worked like a charm,
Thanks a million.

[Jonmo1]

You're welcome