Good Morning Jim,
REGEXREPLACE(IF({AWV}, {AWV} & ", ", “”) & IF({DXR}, {DXR} & ", ", “”) & IF({TCM}, {TCM} & ", ", “”) & IF({ED}, {ED} & “, “, “”),”(.*).” & CHAR(123) & “2” & CHAR(125), “$1”)
This was another one I used. The above one wouldn’t work again, I had more cells to summarize.
CONCATENATE({Anthem}&" , “&{Village Health}&” , “&{Call Center}&” , “&{EHR Overlay: Huddle}&” , “&{EHR Overlay: Specialist}&” , “&{BP}&” , “&{CDI}&” , “&{HPSR}&” ")