E-mail addresses in single column to delimited values in a single cell

Question

E-mail addresses in single column to delimited values in a single cell

Dom 951

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?

User's image

Emi Zhang-MSFT 30,116 Reputation points Microsoft External Staff

2024-10-28T06:13:17.8333333+00:00

Hi,

Just checking in to see if the information of Barry Schwarz was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer accepted by question author

0 additional answers

Your answer

Emi Zhang-MSFT 30,116 Reputation points Microsoft External Staff

2024-10-28T06:13:17.8333333+00:00

Hi,

Just checking in to see if the information of Barry Schwarz was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 1

Barry Schwarz 4,476

The TEXTJOIN function will do what you want: TEXTJOIN(";",1,A1:A3)

Share via

E-mail addresses in single column to delimited values in a single cell

0 additional answers

Your answer