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)
<tbody>
</tbody>
Column 1 | Column 2 | Column 3 | Formula result |
One | Two | Three | One, Two, Three |
Three | , , Three | ||
<tbody>
</tbody>