Consolidate variable list into single cell

[JamesT1]

Morning Folk

I'm looking for a way to consolidate a variable list, which changes daily, into a statement in a single cell.

The list can contain anywhere between 1 and 80 items,,,

Please see the attachment

Many thanks

JT

[tom1977]

You can use such code:

Please Login or Register  to view this content.

[JamesT1]

Tom1977

That does it,, many thanks for your help, much appreciated

JT

[JamesT1]

Tom 1977,,,

sorry one last thing,,, if the list in column B is empty I need cell E3 to be blank

Thanks

JT

[tom1977]

try this

Please Login or Register  to view this content.

[JamesT1]

tom1977

Thanks for that,,, didn't quite work,,, I suspect this is due to how I have the equations in column B,, however I referenced cell C2 to the list and tweaked your code to suit,,, and it works for me...... probably not the best way to do it but !!!!...

Many thanks for your help, and helping me improve my knowledge

Please Login or Register  to view this content.