How can I customize a work around for TextJoin function?

I work for a financial firm as a data analyst and I am attempting to scrub datasets in order to enrich our contact list. An ideal world I am looking for a function or workaround to mimic the text join function that exists in Excel but in CRMA. 

Dataset before it is scrubbed:

Column A: "(123) 456-7890"

Column B: Null

Column C: "(098) 321-4321"

Ideal State: "(123) 456-7890 | (098) 321-4321"

Currently, the formulas I have used error out when there are nulls.

I have used concatenate but it does not allow me to insert a delimiter and to ignore nulls.

#CRMA #Reports & Dashboards @Reports & Dashboards