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

  • @itta
    @itta Жыл бұрын

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

  • @ExcelTipsVideos

    @ExcelTipsVideos

    Жыл бұрын

    Thanks a lot for your support

  • @Kapildev_N._Pol
    @Kapildev_N._Pol Жыл бұрын

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

  • @FK-ky2ww
    @FK-ky2ww2 ай бұрын

    excellent thank u

  • @danielmillwood6354
    @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

    @ExcelTipsVideos

    Жыл бұрын

    Glad that it helped

  • @melbanahi_
    @melbanahi_ Жыл бұрын

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

  • @ExcelTipsVideos

    @ExcelTipsVideos

    Жыл бұрын

    Thank you for your support

  • @PkTipsZone
    @PkTipsZone2 жыл бұрын

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

  • @ExcelTipsVideos

    @ExcelTipsVideos

    2 жыл бұрын

    Glad that it helped.

  • @ManuelLav
    @ManuelLav2 жыл бұрын

    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

    @ExcelTipsVideos

    2 жыл бұрын

    Glad that it helped!

  • @sadafnaz576
    @sadafnaz5768 ай бұрын

    EXCELLENT

  • @ExcelTipsVideos

    @ExcelTipsVideos

    7 ай бұрын

    Many thanks!

  • @jayasreesri5033
    @jayasreesri5033 Жыл бұрын

    Thank you so much for this❤💙

  • @madelineschiller2764
    @madelineschiller27643 ай бұрын

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

  • @ambadkarrg
    @ambadkarrg Жыл бұрын

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

  • @ExcelTipsVideos

    @ExcelTipsVideos

    7 ай бұрын

    You're welcome!

  • @shivasen10
    @shivasen10 Жыл бұрын

    Thankyou, very helpful

  • @ExcelTipsVideos

    @ExcelTipsVideos

    Жыл бұрын

    Glad it was helpful!

  • @TheRahul3456
    @TheRahul34562 жыл бұрын

    Definately helpful.. thanks for the video

  • @ExcelTipsVideos

    @ExcelTipsVideos

    2 жыл бұрын

    Glad that it helped

  • @FK-ky2ww
    @FK-ky2ww2 ай бұрын

    excellent, thank you

  • @adarshandhale8362
    @adarshandhale8362 Жыл бұрын

    Thank you very much ❤️ New subscriber

  • @ExcelTipsVideos

    @ExcelTipsVideos

    Жыл бұрын

    Thanks for your support

  • @sharonokota2224
    @sharonokota22242 жыл бұрын

    Thanks for this tip

  • @SURESHS-fi8xr
    @SURESHS-fi8xr3 жыл бұрын

    Very useful for my daily works

  • @ExcelTipsVideos

    @ExcelTipsVideos

    3 жыл бұрын

    Thanks for your support

  • @kristoferjoulesnavarosa588
    @kristoferjoulesnavarosa5882 жыл бұрын

    Thank you !

  • @pavan010989
    @pavan0109893 жыл бұрын

    Thanks a lot..

  • @mohanaa7803
    @mohanaa78032 жыл бұрын

    Thank u.. it is really useful to me

  • @ExcelTipsVideos

    @ExcelTipsVideos

    2 жыл бұрын

    Thank you for your support

  • @Maynoroto
    @Maynoroto2 жыл бұрын

    sin tanto rodeo, buen video, gracias

  • @ExcelTipsVideos

    @ExcelTipsVideos

    2 жыл бұрын

    Glad to have helped

  • @khans3006
    @khans30062 жыл бұрын

    Amazing....

  • @ExcelTipsVideos

    @ExcelTipsVideos

    2 жыл бұрын

    Thanks for watching

  • @mohsin2676
    @mohsin26762 жыл бұрын

    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

  • @zb6318
    @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!

  • @iskanderyemen2322
    @iskanderyemen23222 жыл бұрын

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

  • @ExcelTipsVideos

    @ExcelTipsVideos

    2 жыл бұрын

    Glad I could help!

  • @abhishekdasgupta8925

    @abhishekdasgupta8925

    Жыл бұрын

    I need help

  • @vighneshsharma211
    @vighneshsharma2112 жыл бұрын

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

  • @ExcelTipsVideos

    @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

    @ExcelTipsVideos

    2 жыл бұрын

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

  • @meghashreems7990

    @meghashreems7990

    2 жыл бұрын

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

  • @ExcelTipsVideos

    @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

    @meghashreems7990

    2 жыл бұрын

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

  • @ParthKhulbe
    @ParthKhulbe3 жыл бұрын

    Thnk uuuuuu

  • @quickexcel2412
    @quickexcel24122 жыл бұрын

    Liked 👍👍

  • @bikashpandeya69
    @bikashpandeya697 ай бұрын

    Just reverse process???

  • @ashfaqueansari6753
    @ashfaqueansari6753 Жыл бұрын

    How to do vice versa?

  • @hannasi4210
    @hannasi4210Ай бұрын

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

  • @mohamedchaouachi3967
    @mohamedchaouachi39672 жыл бұрын

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

  • @munyarugerojean

    @munyarugerojean

    2 жыл бұрын

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

  • @thebigbigdaddy
    @thebigbigdaddy5 ай бұрын

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

  • @chetanparab2624
    @chetanparab2624 Жыл бұрын

    Doesn't work

  • @ExcelTipsVideos

    @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
    @kgblog2156 Жыл бұрын

    Please buy a new mic