Concatenate over variable range

[JonRowland]

Hi Guys,

I should be able to get this but mind's a buzzing.

I want to Concatenate cells contents of a row over a variable range. I'm doing this manually at the moment but it's a nuisance when you've got a lot of columns.

Plus if anyone has any ideas for something quicker & leaner then I all ears.

I'll start on Row 2. I've got values in this row for Cols D - last Column

I want to skip through the columns in that row and if there is a value have this entered in Col C and separate each with a comma.

EG From D2 - E2

D2 E2 F2 G2

A C E

I want C2 to show
A,C,E

I'm normally entering =CONCATENATE(D2,",",E2,",",F2 .. & so on) and then use substitute to clean it up but getting to be a burden when confront with lots of columns.

If anyone can help you'll put a smile on my face
Cheers
Jon

 

[Andrew Poulsom]

Chip Pearson has a useful UDF here:

http://www.cpearson.com/Excel/stringconcatenation.aspx

 

[JonRowland]

Cheers for link Andrew,

That a great function & perfect for me.

Jon