Convert Excel Column to comma separated values

Показать описание

In this video, we will see how you can convert an excel column to comma separated values using a simple formula.

We will use the CONCATENATE formula to quickly convert an excel column to comma separated values.

This versatile method will also allow you to use any delimiter of your choice instead of a comma - based on your requirements.

Click here to subscribe to my channel to get more videos of Excel formula tips and uses:

Check out our Excel Graph Playlist for ideas on creating great-looking charts :

Рекомендации по теме

Комментарии

I rarely comment on something, but I'm really grateful you've done this well explained video, sir! Thanks!

itta

you are a real life saver, thank you very much, Love from india

Kapildev_N._Pol

Thank you SO MUCH for this!!! I really appreciate the time you took to create this video and share this. God bless you.

danielmillwood

Very helpful I was looking for this since time ago, but I can believe there is not a simple formula but recurring to another trick to do this, wow!!

ManuelLav

Thank you very much for this! It was so helpful and saved me a ton of time :)

madelineschiller

thank you. you really solve my problem very thank you god bless you

PkTipsZone

thanks very much! this is super helpful and super easy!

ambadkarrg

Definately helpful.. thanks for the video

TheRahul

sin tanto rodeo, buen video, gracias

Maynoroto

Thank you very much ❤️
New subscriber

adarshandhale

Here's the quick one, in Cell B type =A1&", " then double click the cell to run down the formula in Cell B. then in Cell C type =concat(B:B). Thanks!

zb

Thanks!. Although after pasting as values, still excel converts it into text and when i convert to number, the values go for a toss.
Please help

mohsin

Hahah I wanted to do the opposite. BTW thanks for this info it helped

iskanderyemen

i was actually looking for opposite of this from coma to row

vighneshsharma

I dont understand how this doesnt work for me 😭
All i get are red dots around that cell

hannasi

Double clicking on the corner doesn’t auto fill the rest

mohamedchaouachi

easier way:
=Concatenate_Range(B2:B23, ", ")

thebigbigdaddy

Convert Excel Column to comma separated values

Convert Excel Column to comma separated values

Convert comma separated list of data into columns in EXCEL!!!!!!

How to convert column list to comma separated list in Excel

4 Ways to Convert Excel Column to Comma Separated Value

Convert a column into comma separated list in Excel

How To Convert a Column or Rows of Data into Comma Separated Values | Excel comma Delimited

Convert a column into comma separated list in Excel

Convert Excel File to Comma Separated Values File

SAS Programming Master Classes: Quickly Learn Proc Import & Export - 05 | Learn SAS Tutorial Fre...

How To Convert a Column or Rows of Data into Comma Separated Values | Excel 2016/2013/2010/2007

Convert Excel Column to Comma Delimited List

Convert column into comma separated list in Excel

Quickly Concatenate Multiple Cells - Combine Cells with commas, space and semicolon

Excel Pro Trick: Convert Columns or rows to Comma Separated Lists in Excel using Formula - 2 Methods

Convert Excel Column to comma separated values

How to convert vertical data into horizontal data separated by comma | Convert column to row

How to Convert Comma to Decimal Point & Dot to Comma in Excel

Concatenate Converts column data into comma separated values in Excel #shorts

Excel Pro Tricks: How to Convert Columns into Comma Separated Values #exceltech #exceltricks

Convert values of a column into comma separated string in Excel using TEXTJOIN function

MS Excel - Convert a List into a Comma Separated Value

Convert Data in Column or Rows into Comma Separated List in Microsoft Excel

How to replace dots with commas in Excel

Convert Excel Column to comma separated values Part 2