Textjoin & Textsplit
Textjoin: Textjoin Function Website Textsplit: Textsplit Function Website Below I show an example of using textjoin and textsplit. Textjoin would be helpful for reports that I pull where the header has the name broken apart and I need to put them together into one cell. Textsplit is just like text to columns but in a formula form.