Hi everyone, I've got the following formula and can't find a way to ignore the blank cells if not data is entered. I'm trying to avoid having double comas when no data is in one of the cells. using formula (=CONCATENATE(A1, ", ",B1, ", ",C1)[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Column 1
[/TD]
[TD]Column 2
[/TD]
[TD]Column 3
[/TD]
[TD]Formula result
[/TD]
[/TR]
[TR]
[TD]One
[/TD]
[TD]Two
[/TD]
[TD]Three
[/TD]
[TD]One, Two, Three
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Three
[/TD]
[TD], , Three
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]Column 1
[/TD]
[TD]Column 2
[/TD]
[TD]Column 3
[/TD]
[TD]Formula result
[/TD]
[/TR]
[TR]
[TD]One
[/TD]
[TD]Two
[/TD]
[TD]Three
[/TD]
[TD]One, Two, Three
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Three
[/TD]
[TD], , Three
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]