Convert List into Comma Separated Values - Excel #Shorts

To convert a column of data values into Comma Separated Values (CSV) has been made easier with the TEXTJOIN function. But you're not constrained by just commas as your delimiter, so feel free to substitute dashes or semicolons. However you can't mix and match delimiters with the TEXTJOIN function but with a helper column, it can be done with the CONCAT function. Here's an Excel #shorts video to show you how.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

[vegetarianninja]

Thank you. quick and simple. I used to do this completely the long way! transposing across, and then a [A1 & ", " & B1] to create a comma-sep list. Welcome to my life TEXTJOIN

[A]

Thank you so much! I tried different videos for 2 days and this is the first one that worked.

[marshalljackson]

Excellent! Simple and quick. Thank you very much for this video.

[DirtyErnie]

this is super helpful for my prob and stats class, thanks

[vanscoyoc]

At 22 seconds what happened to the right parenthesis? I tried this and all that happened is the formula is printed in the cell instead of any rusult. Weird.

[asmrindia]

Thanks Sir, Please mention its vice-versa also, that is, if a value or text string (in my case numbers) is comma delimited, I downloaded it (Excel File) from the web portal, I get a large number string (such as 2, 20, 34, 72, 20, 34, 82, 20, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 000
or 2.2034722034822E+59), then how can I separate it properly. The correct string is 220347, 220348, 220349, 220350, 220352, 220065, 220066, 220083, 220104, 220371 on the portal. Please suggest me a function opposite to the Text Join Function, so I can paste the number string in proper format.
Thanks

[poojaverma]

Thanks for this video. How do you do the opposite? I have line items that are separated by commas but want to get them into a list.

thanks, that helped me. just the formula separator for me was ; not,

[BertFlamingo]

Thank you! However, I had to replace the, with ; otherwise it didn't work. I have a swedish mac book.

[ithinkidontlikemusicbutim]

thanks for the video, how about convert a paragraph of data with comma into excel list, is there a way to that? eg aaa, bbb, ccc, zzz, xxx, yyy.... to list in excel one cell by one cell vertically

[lqvkvew]

Thank you. How do you add a space after each comma?

[bryceyin]

Anyone got invalid name error by using this?