convert excel column to comma separated list with double quotes

How to Add Quotes And Comma To Excel Cells - YouTube

Excel Pro Trick: Convert Columns or rows to Comma Separated Lists ...

January 25, 2023

04:28

Convert Excel Column to comma separated values - YouTube

November 9, 2020

00:54

Convert List into Comma Separated Values - Excel #Shorts - YouTube

superuser.com › questions › 240858 › convert-a-column-into-a-comma-separated-list

microsoft excel - Convert a column into a comma separated list - Super User

stackoverflow.com › questions › 19483794 › converting-excel-values-into-double-quotation-with-commas-between-them

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"

Stack Overflow

csv - Converting Excel values into double quotation with commas between them - Stack Overflow

utilhatch.com › home › blog › how to convert an excel column to a comma separated list

1 of 1

10

Here is one suggestion:

In another column, put something like this =""""&A1&"""," and copy/drag the formula until the end of your column.

Then Copy and Paste that column into MS Word, and paste special using "Keep Text Only".

Now do a find & replace in MS Word for ^p, and keep the "Replace" field empty (this will put it all on one line). You can then copy that back into Excel or wherever you need it.

UtilHatch

How to Convert an Excel Column to a Comma Separated List

2 weeks ago - If you only need the list once, use the Column to Comma Separated List converter. It is faster than writing a formula and gives you the cleanup options that matter most: comma plus space, duplicate removal, trimming, blank-line removal, and quote wrapping. If the spreadsheet will keep changing, use a formula such as TEXTJOIN in Excel or JOIN in Google Sheets.

ExtendOffice

extendoffice.com › home › office tips › excel tips

How to convert column list to comma-separated list in Excel?

July 3, 2025 - Learn how to convert a column list to a comma-separated list in Excel using functions like TEXTJOIN and CONCATENATE, VBA code, or the Kutools add-in.

Find elsewhere

Google Bing Mojeek

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 - In an empty cell, begin typing the formula: =CONCATENATE( Click on the first cell in your list (A2), then type a comma. Type your delimiter in double quotes (", "), followed by another comma.

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 - 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.

TendersOnTime

tendersontime.com › tools › column-to-comma-separated-list

Column To Comma Separated List | Tools | TendersOnTime

1 day ago - Our free comma separator tool automatically converts a column to a comma list or list to CSV (comma-separated values). Copy your column of data and watch the conversion happen. You can do the reverse and convert a delimited list to a column. You can use our comma separator tool to convert column lists to comma-separated value (CSV) lists quickly and easily.

C4Calculators

c4calculators.com › home › comma separator tool – convert column to comma separated list online

Comma Separator Tool – Convert Column to Comma Separated List Online - C4Calculators

March 24, 2026 - Quickly convert column data into a clean, formatted list using commas, pipes, or semicolons. Perfect for Excel, SQL, coding, and data formatting tasks. ... Trim spaces Remove duplicates Wrap in single quotes (‘value’) Wrap in double quotes (“value”)

Convert a column into a comma separated list in Excel - YouTube

youtube.com › watch

02:48

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

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)

CodeShack

codeshack.io › home › tools › column to comma separated list

Column to Comma Separated List - Free Online Converter

Whatever you choose is placed between every value. Use the Wrap items menu and pick double quotes, single quotes, backticks, parentheses, or square brackets — each value gets that wrapper before the items are joined.

Edureka Community

edureka.co › home › community › categories › database › convert excel column to comma separated list

Convert excel column to comma separated list | Edureka Community

1 of 4

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)

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 - The first argument is the delimiter (a comma), the second argument TRUE tells Excel to ignore empty cells, and the third is your range. If you need single quotes for a SQL query, you can use ="'"&TEXTJOIN("','", TRUE, A1:A500)&"'". This wraps ...

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 :>

1 of 4

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

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.

TextKit

textkit.dev › convert column to comma separated list online

Convert Column to Comma Separated List — Free | TextKit

... Yes. Use the Delimiter buttons to switch between comma, semicolon, pipe, tab, space, or click Custom to type any separator you like: an arrow (->), multiple characters, or even a word.

MrExcel

mrexcel.com › forums › question forums › excel questions

Surround values with single quote | MrExcel Message Board

02:14

Hi, I created the below sub to convert a single column of values (of varying amounts) into a single, comma separated string. Thus if Column A on "Sheet1" contains: 50 55 60 65 70 75 The procedure will convert that to a comma separated string on a new worksheet ("List1"), e.g.: 50, 55, 60, 65...

Published March 23, 2018

Views 1M

Stack Overflow

stackoverflow.com › questions › 42915255 › how-to-add-single-quote-and-comma-to-all-values-in-a-column

vba - How to add single quote and comma to all values in a column? - Stack Overflow

1 of 3

7

Your original UDF was close. You just need to join with ',' rather than , and then place ' at the start and end of your output string

Public Function MergeME(r As Range) As String
  MergeME = "'" & Join(Application.Transpose(r.Value), "','") & "'"
End Function

Output string as required:

'server1.abc.com','server2.abc.com','server3'

2 of 3