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

Dom 836 Reputation points
2024-10-25T22:17:56.7333333+00:00

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 questions
{count} votes

Accepted answer
  1. Barry Schwarz 3,071 Reputation points
    2024-10-25T22:54:32.7033333+00:00

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

    2 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.