Remove Extra Commas in Join/Collect?

SYSPK

I have a great formula of JOIN and COLLECT together that pulls info from 11 columns. It pulls strings if they meet certain conditions with commas as a delimiter.

But if the conditions are not met, I have a bunch of commas next to each other. E.g. , , , EX1, , EX4, , , , and in some cases, just 11 commas.

Is there a way to only show the strings if they meet the conditions, keep them separated by commas but then nothing else? I.e. if there are 2 commas next to each other, to not show in the cell. I'm willing to use a helper column for this. The e.g. above would look like "EX1, EX4" and if there are no conditions met, the cell would be blank.

Thank you

Paul Newcome

Add in a second instance of the range you are pulling from and use the criteria of

@cell <> ""

This means it will not pull blanks which in turn will get rid of those extra columns.

Sean Morgan

Hello @SYSPK ,

Would you be able to share the formula you are currently using, as well as a screenshot of how it looks in your sheet?

Regards

Sean

Paul Newcome

Add in a second instance of the range you are pulling from and use the criteria of

@cell <> ""

This means it will not pull blanks which in turn will get rid of those extra columns.