The TEXTJOIN function will do what you want: TEXTJOIN(";",1,A1:A3)
E-mail addresses in single column to delimited values in a single cell
Dom
836
Reputation points
I have a column that contains e-mail addresses. I need to transform this column into a single cell that has a semi-colon between each address. I know you can manually do things with Concatenate, Transpose, F9 & deleting the curly braces, but is there a way to write a FORMULA that will perform this function?