Forum Discussion

bhhspro's avatar
bhhspro
Copper Contributor
Jul 22, 2020

combining text from multiple cells into one cell

I'm trying to combine text into multiple cells into one cell with a comma in between without having to identify the comma in between each cell.  Is that possible and how?

Formulas and Functions

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jul 22, 2020

    bhhspro  Look at the function TEXTJOIN(), in which you define a delimitor (in this case ",") to put between each of the strings that will be joined.