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
Пікірлер: 58
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
you are a real life saver, thank you very much, Love from india
excellent thank u
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
I cannot day thank you enough!!! 🙇♀
@ExcelTipsVideos
Жыл бұрын
Thank you for your support
thank you. you really solve my problem very thank you god bless you
@ExcelTipsVideos
2 жыл бұрын
Glad that it helped.
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
2 жыл бұрын
Glad that it helped!
EXCELLENT
@ExcelTipsVideos
7 ай бұрын
Many thanks!
Thank you so much for this❤💙
Thank you very much for this! It was so helpful and saved me a ton of time :)
thanks very much! this is super helpful and super easy!
@ExcelTipsVideos
7 ай бұрын
You're welcome!
Thankyou, very helpful
@ExcelTipsVideos
Жыл бұрын
Glad it was helpful!
Definately helpful.. thanks for the video
@ExcelTipsVideos
2 жыл бұрын
Glad that it helped
excellent, thank you
Thank you very much ❤️ New subscriber
@ExcelTipsVideos
Жыл бұрын
Thanks for your support
Thanks for this tip
Very useful for my daily works
@ExcelTipsVideos
3 жыл бұрын
Thanks for your support
Thank you !
Thanks a lot..
Thank u.. it is really useful to me
@ExcelTipsVideos
2 жыл бұрын
Thank you for your support
sin tanto rodeo, buen video, gracias
@ExcelTipsVideos
2 жыл бұрын
Glad to have helped
Amazing....
@ExcelTipsVideos
2 жыл бұрын
Thanks for watching
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
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!
Hahah I wanted to do the opposite. BTW thanks for this info it helped
@ExcelTipsVideos
2 жыл бұрын
Glad I could help!
@abhishekdasgupta8925
Жыл бұрын
I need help
i was actually looking for opposite of this from coma to row
@ExcelTipsVideos
2 жыл бұрын
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
2 жыл бұрын
Please let me know if you need help with Text to Column feature
@meghashreems7990
2 жыл бұрын
@@ExcelTipsVideos I have tried this one.. But I am getting some error
@ExcelTipsVideos
2 жыл бұрын
@@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
2 жыл бұрын
@@ExcelTipsVideos thank you for your reply.. Now I got a solution. I was selected whole row instead of a cell
Thnk uuuuuu
Liked 👍👍
Just reverse process???
How to do vice versa?
I dont understand how this doesnt work for me 😭 All i get are red dots around that cell
Double clicking on the corner doesn’t auto fill the rest
@munyarugerojean
2 жыл бұрын
@Mohamed Chaouachi, you should have to enter the formula in the column nex to the data.
easier way: =Concatenate_Range(B2:B23,",")
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
Please buy a new mic