Concatenate formula with blank columns

[jvandoorn (Jackie van Doorn)]

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!

[JCorrell (Jim - The Monday Man)]

@jvandoorn

Here’s one way:

REGEXREPLACE(
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 monday.com Formulas? YES!!!

[jvandoorn (Jackie van Doorn)]

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