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:
/ @exceltipsvideos
Check out our Excel Graph Playlist for ideas on creating great-looking charts :
• Excel Graphs

[@itta]

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

[@ExcelTipsVideos]

Thanks a lot for your support

[@Kapildev_N._Pol]

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

[@danielmillwood6354]

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

[@ExcelTipsVideos]

Glad that it helped

[@madelineschiller2764]

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

[@ManuelLav]

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

[@ExcelTipsVideos]

Glad that it helped!

[@zb6318]

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!

[@jayasreesri5033]

Thank you so much for this❤💙

[@sharonokota2224]

Thanks for this tip

[@TheRahul3456]

Definately helpful.. thanks for the video

[@ExcelTipsVideos]

Glad that it helped

[@FK-ky2ww]

excellent thank u

[@ambadkarrg]

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

[@ExcelTipsVideos]

You're welcome!

[@PkTipsZone]

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

[@ExcelTipsVideos]

Glad that it helped.

[@kristoferjoulesnavarosa588]

Thank you !

[@melbanahi_]

I cannot day thank you enough!!! 🙇‍♀

[@ExcelTipsVideos]

Thank you for your support

[@pavan010989]

Thanks a lot..

[@SURESHS-fi8xr]

Very useful for my daily works

[@ExcelTipsVideos]

Thanks for your support

[@FK-ky2ww]

excellent, thank you

[@mohanaa7803]

Thank u.. it is really useful to me

[@ExcelTipsVideos]

Thank you for your support

[@Maynoroto]

sin tanto rodeo, buen video, gracias

[@ExcelTipsVideos]

Glad to have helped

[@mohsin2676]

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

[@adarshandhale8362]

Thank you very much ❤️
New subscriber

[@ExcelTipsVideos]

Thanks for your support

[@shivasen10]

Thankyou, very helpful

[@ExcelTipsVideos]

Glad it was helpful!

[@sadafnaz576]

EXCELLENT

[@ExcelTipsVideos]

Many thanks!

[@bikashpandeya69]

Just reverse process???

[@khans3006]

Amazing....

[@ExcelTipsVideos]

Thanks for watching

[@ParthKhulbe]

Thnk uuuuuu

[@ashfaqueansari6753]

How to do vice versa?

[@vighneshsharma211]

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

[@ExcelTipsVideos]

If you are looking to convert comma separated values, you can use the “Text to column” feature. Please select the delimiter as “Comma” in the second step of the process

[@ExcelTipsVideos]

Please let me know if you need help with Text to Column feature

[@meghashreems7990]

@@ExcelTipsVideos I have tried this one.. But I am getting some error

[@ExcelTipsVideos]

@@meghashreems7990 could you please let me know what error you are getting? That will help to identify the issue - If you are looking for commas to rows - you can follow the steps in the video and then transpose the column to a row (additional step)

[@meghashreems7990]

@@ExcelTipsVideos thank you for your reply.. Now I got a solution. I was selected whole row instead of a cell

[@quickexcel2412]

Liked 👍👍

[@iskanderyemen2322]

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

[@ExcelTipsVideos]

Glad I could help!

[@abhishekdasgupta8925]

I need help

[@hannasi4210]

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

[@mohamedchaouachi3967]

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

[@munyarugerojean]

@Mohamed Chaouachi, you should have to enter the formula in the column nex to the data.

[@thebigbigdaddy]

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

[@chetanparab2624]

Doesn't work

[@ExcelTipsVideos]

The video does show that it works - if it does not work for you, it could be due to an error on your end. Please follow the steps shown in the video and share the issue that you faced

[@kgblog2156]

Please buy a new mic