Assuming your data starts in A1 I would put the following in column B:
B1:
=A1
B2:
=B1&","&A2
You can then paste column B2 down the whole column. The last cell in column B should now be a comma separated list of column A.
Answer from Sux2Lose on Stack ExchangeExtendOffice
extendoffice.com › home › office tips › excel tips
How to convert column list to comma-separated list in Excel?
July 3, 2025 - Convert column list to comma-separated list with VBA code · Excel doesn’t include a column-to-comma list function, but you can achieve it easily: use TEXTJOIN in Office 365/2019+, or CONCAT+IF in any version to streamline your data. As Excel's most advanced concatenation function, TEXTJOIN ...
Top answer 1 of 14
173
Assuming your data starts in A1 I would put the following in column B:
B1:
=A1
B2:
=B1&","&A2
You can then paste column B2 down the whole column. The last cell in column B should now be a comma separated list of column A.
2 of 14
112
- Copy the column in Excel
- Open Word
- "Paste special" as text only
- Select the data in Word (the one that you need to convert to text separated with
,), press Ctrl-H (Find & replace) - In "Find what" box type
^p - In "Replace with" box type
, - Select "Replace all"
Convert a column to a comma separated list
if its just one large column you can select all, then special paste and paste the transpose; Then save as a CSV https://www.laptopmag.com/articles/transpose-columns-rows-using-paste-special-excel If you want to do it in VBA: https://stackoverflow.com/questions/13174916/transpose-a-range-in-vba More on reddit.com
4
2
May 15, 2019Converting multiple columns/rows of text into comma seperated rows of text
u/PlebPlebberson - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
10
2
June 7, 2023How to convert data to a comma separated form.
u/Existing_Advisor_375 - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
12
1
November 14, 2023How to consolidate rows into a single cell separated by a comma?
u/prometheon13 - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
11
1
March 20, 2024Can I convert multiple columns to comma-separated lists simultaneously?
Yes, create separate TEXTJOIN formulas for each column in different cells. For automation, use helper columns or write a VBA macro to process multiple columns at once. This is faster for large datasets with many columns.
getelyxai.com
getelyxai.com › home › how-to guides › how to convert column values to comma-separated list
How to How to Convert Column Values to Comma-Separated List in ...
How do I remove duplicates from my comma-separated list?
Combine with UNIQUE function (Excel 365): =TEXTJOIN(",",TRUE,UNIQUE(A1:A10)). For older versions, manually remove duplicates first via Data > Remove Duplicates, then apply TEXTJOIN.
getelyxai.com
getelyxai.com › home › how-to guides › how to convert column values to comma-separated list
How to How to Convert Column Values to Comma-Separated List in ...
What's the difference between TEXTJOIN and CONCATENATE?
TEXTJOIN automatically handles delimiters and ignores blanks with one parameter, while CONCATENATE requires manual delimiter insertion for each cell. TEXTJOIN is more efficient for large ranges. CONCATENATE is better for combining specific cells with custom formatting.
getelyxai.com
getelyxai.com › home › how-to guides › how to convert column values to comma-separated list
How to How to Convert Column Values to Comma-Separated List in ...
Videos
01:11
How to Convert comma separated list of data into columns in EXCEL ...
Convert comma separated list of data into columns in EXCEL!!!!!!
00:34
How To Split Comma Seperated Data Into Columns In Excel - Full ...
How to Split Comma separated Values into Columns or Rows ...
Microsoft Learn
learn.microsoft.com › en-us › answers › questions › 5062007 › how-do-i-convert-column-data-to-a-comma-separated
how do I convert column data to a comma separated list in a single cell - Microsoft Q&A
April 29, 2020 - Simply copy it, right click, and hit the fourth button to the right under the paste options. ... You can first use Transpose function and then use joint operator < &> for putting in single cell.
Computing.net
computing.net › home › how to convert column list to comma separated list in excel
How to Convert Column List to Comma Separated List in Excel - Computing.net
July 24, 2024 - Now please follow carefully as I walk you through how to use this function. Select a blank cell, such as cell C2 and type the formula =TEXTJOIN to convert a column list to a separated comma-separated list (“,“,TRUE,A1:A8).
Convert Town
convert.town › column-to-comma-separated-list
Convert Column to Comma Separated List Online
Copy your column of text in Excel · Paste the column here (into the leftmost textbox) Copy your comma separated list from the rightmost textbox · Paste your comma separated list wherever you wish · No ads with PRO ·
Statology
statology.org › home › excel: how to convert column into comma separated list
Excel: How to Convert Column into Comma Separated List
June 7, 2023 - Recall the formula that we used ... any empty cells in the range. Note: You can find the complete documentation for the TEXTJOIN function in Excel here....
The Bricks
thebricks.com › home › resources › how to turn an excel column into a list with commas
How to Turn an Excel Column into a List with Commas
February 20, 2025 - Click any empty cell where you want the results to appear. ... For the first argument, the delimiter, type ", " (including the quotes). This tells Excel to separate each name with a comma followed by a space for cleaner formatting.
Capitalize My Title
capitalizemytitle.com › home › tools › online comma separator – convert list to csv (column to comma)
Convert Column to Comma Separated List
Quickly convert a data list to CSV. Copy/paste a list from Excel to convert columns to comma-delimited values. Save settings & auto-copy results.
Reddit
reddit.com › r/excel › convert a column to a comma separated list
r/excel on Reddit: Convert a column to a comma separated list
May 15, 2019 -
I have a set of data where I need to convert a column such as this
| Jeff |
|---|
| Bob |
| Steve |
| Jim |
| Karen |
to a comma separated list that reads Jeff, Bob, Steve, Jim, Karen. I then need to copy that string of text so that I can put it in word, and so I can enter it into a website field. I assume VBA is going to be the go to on this.
Top answer 1 of 2
2
if its just one large column you can select all, then special paste and paste the transpose; Then save as a CSV https://www.laptopmag.com/articles/transpose-columns-rows-using-paste-special-excel If you want to do it in VBA: https://stackoverflow.com/questions/13174916/transpose-a-range-in-vba
2 of 2
1
Not very elegant, but I sometimes use... =A1&", "&A2&", "&A3&", "&A4 If your task is ad hoc, then copy, paste, transpose is probably quicker, but my method is useful when you need to repeat the task often.
ElyxAI
getelyxai.com › home › how-to guides › how to convert column values to comma-separated list
How to How to Convert Column Values to Comma-Separated List in Excel - Practical Guide | ElyxAI
Use =TEXTJOIN(",",TRUE,A1:A10) where comma is the delimiter and TRUE ignores empty cells.
YouTube
youtube.com › watch
Convert a column into a comma separated list in Excel - YouTube
In this video, we'll explore how to convert a column into a comma-separated list in Excel using the TextJoin function. By the end of this tutorial, you will ...
Published November 22, 2024
Top answer 1 of 4
1
The CONCATENATE function in Excel can transform a column list into a list separated by commas in a cell. Please follow these instructions:1. Type the formula =CONCATENATE(TRANSPOSE(A1:A7)&",") in a blank cell adjacent to the list's initial data, for example, cell C1. (The column A1:A7 will be converted to a comma-serrated list, and the separator "," will be used to separate the list.) Take a look at the images below:2. Press the F9 key to highlight the TRANSPOSE(A1:A7)&"," in the formula.3. Remove the curly brackets and press the Enter key from the formula.
2 of 4
0
=TEXTJOIN(",",TRUE,A1:A50)
YouTube
youtube.com › watch
Convert Column to Comma Separated List - YouTube
📽️ In this Microsoft Excel video tutorial I demonstrate how to convert a column to a comma separated list. The way you do this depends on the version of Ex...
Published June 1, 2025
ExcelDemy
exceldemy.com › home › excel formulas › how to convert a column into a comma separated list with single quotes – 5 methods
How to Convert a Column into a Comma Separated List With Single Quotes - 5 Methods - ExcelDemy
August 9, 2024 - The ampersand sign (&) will join the single quotes (‘’) and the commas (,) with the cell values to create a comma separated list with single quotes. Press ENTER to see the result. Read More: How to Convert Columns to Rows in Excel (2 Methods)
iCert Global
icertglobal.com › home › community › what is the fastest way to convert a vertical excel column into a comma-separated list?
What is the fastest way to convert a vertical Excel column into a comma-separated list? | iCert Global
April 20, 2026 - Master the TEXTJOIN and CONCAT functions in Excel to transform columns into comma-separated lists. Perfect for SQL queries and data reformatting.
The Bricks
thebricks.com › home › resources › how to convert column to row in excel with comma separated list
How to Convert Column to Row in Excel with Comma Separated List
February 12, 2025 - The TEXTJOIN function has three main parts (arguments): Delimiter: ", " — This is the character(s) you want to place between each item. We've used a comma followed by a space for nice, clean formatting.
TextKit
textkit.dev › blog › column-to-comma-excel
How to Convert a Column to a Comma Separated List in Excel (3 Methods) | TextKit Blog
March 3, 2026 - You've got a column of values in Excel and need them as a comma-separated list. For a SQL IN clause, an email recipient field, a configuration file, or just to paste into another tool. Here are three ways to do it. ... This is the cleanest approach if your Excel version supports it. First argument: the delimiter. ", " gives you a comma followed by a space. Use "," if you don't want the space, or ";" for a semicolon. Second argument: TRUE means ignore empty cells.
CodeShack
codeshack.io › home › tools › column to comma separated list
Column to Comma Separated List - Free Online Converter
Choose the separator. Comma + space is the default; switch to a plain comma, semicolon, pipe, space, or type your own with Custom. Wrap and tidy (optional). Wrap each value in quotes or brackets for code, then trim spaces, remove blank lines or duplicates, and sort if you like. Take the list. The right box updates live with your one-line list — copy it to your clipboard or download it as a text file.
ExcelDemy
exceldemy.com › home › excel formulas › how to convert column to row with comma in excel (3 ways)
How to Convert Column to Row with Comma in Excel (3 Ways) - ExcelDemy
June 18, 2024 - The range B5:B9 indicates the cells of the Name column. Press ENTER. The Name column of the dataset will be converted to a comma separated list. ... << Go Back to How to Add Comma in Excel | Concatenate Excel | Learn Excel Get FREE Advanced Excel Exercises with Solutions!
Reddit
reddit.com › r/excel › converting multiple columns/rows of text into comma seperated rows of text
r/excel on Reddit: Converting multiple columns/rows of text into comma seperated rows of text
June 7, 2023 -
I have an excel that has over 3000+ rows of text in different columns that i need to convert into comma seperated text for csv.
Example:
Column1 | Column2| Column3
Name | surname | phonenumber
Name1 | surname1 | phonenumber1
I need to get all of these converted into the following lines of text:
Name,surname,phonenumber
Name1,surname1,phonenumber1
Bonus points if i can convert them to a text format of:
,"XXX","Name","surname","phonenumber","YYY","ZZZ"
,"XXX","Name1","surname1","phonenumber1","YYY","ZZZ"
The xxx, yyy and zzz being static information that is same for every row.
I can do it row by row with =TEXTJOIN() but i cant add the static information and doing it one row at a time seems tedious.
Help pls :>
Top answer 1 of 4
1
u/PlebPlebberson - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2 of 4
1
that i need to convert into comma seperated text for csv. Have you tried Save As > Changing Excel Workbook to CSV? Then you can just insert a column for static information. No idea where "Password" came from.