Concatenate formula with blank columns

Hi there,
I’m trying to concatenate three connect board columns (Chair, Speaker 1, Speaker 2) together but sometimes one of the columns is blank. When that happens, the formatting of the formula column adds extra spaces and commas (see image). I’ve read through posts here, and tried to figure this out, but I can’t figure out how to exclude blank columns from this formula. I feel it’s likely something simple, but I don’t know how to move it forward. Thanks in advance for any suggestions!


Here’s one way:

IF({Chair}, {Chair} & ", ", "") & IF({Speaker 1}, {Speaker 1} & ", ", "") & IF({Speaker 2}, {Speaker 2} & ", ", ""), 
"(.*)." & CHAR(123) & "2" & CHAR(125), "$1")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in Formulas? YES!!!

Hi Jim, that worked perfectly, thank you so much! It was actually more complex than I think I could have figured out.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.