B | C | D | E | F | |
1 | SURNAME | FIRSTNAME | MI | GENQUAL | CONCAT'D |
2 | DOE | JOHN | T | JR | DOE.JOHN.T.JR |
3 | DOE | JANE | DOE.JANE |
<tbody>
</tbody>
I cant figure out how to write a formula to concatenate column B thru Column E, add a period after each column, but not display a period if the field is blank. In the example, row 2 shows the full display with a "." after each and row 3 displays jane but no "." after because the other fields are blank.