Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
An ops analyst maintains a customer contact roster where each row has 5 optional contact channels (Phone, Email, Address, Website, Social) and any cell may be blank. The downstream system wants a single " | "-delimited string per customer that skips the blanks — "555-1234 | alex@acme.com | acme.com" for a customer with only those three filled in.
Their original "skip-the-blanks" formula in column G is a 5-deep IF chain:
=IF(B2<>"",B2&" | ","") & IF(C2<>"",C2&" | ","") & IF(D2<>"",D2&" | ","") & IF(E2<>"",E2&" | ","") & IF(F2<>"",F2,"")
It works but it's painful to edit, leaves a trailing " | " if F2 is the only blank, and adding a sixth channel requires another nesting level.
TEXTJOIN collapses this into one call:
=TEXTJOIN(" | ", TRUE, B2:F2)
The first argument is the delimiter, the second is TRUE to skip blanks, and the third is the range to join. No IF chain, no trailing-delimiter bug, and adding a column means extending the range — no nesting changes.
Your task:
" | ".Graded cells: G2 (Phone + Email + Website only → 555-1234 | alex@acme.com | acme.com), G5 (Phone + Email + Address + Social → 555-1212 | dev@hooli.com | 99 Tech Way | @hooli), G10 (Phone + Address + Social → 555-3333 | 1007 Mountain Dr | @wayne).