Google docs spreadsheet app is going mainstream with each passing day. Recently they have introduced split() formula to divide text in to multiple cells using a user specified delimiter.
The syntax for this function is =split(text value, delimeter), for eg. =split("pointy haired dilbert", " ") would result in 3 individual cells with “pointy”, “haired” and “dilbert” as values. Learn more.
This is a very good replacement for excel import text functionality using which you can paste large text files in to excel sheet.
Also try: concat() function to combine lots of cells to a single value
One Response to “How to export YouTube video comments to Excel file? – Free template + Power Query case study”
And I asked myself when i saw your Accouncement Video for the Give away: "Seriously, will Chandoo go manualy thru all his Videos and pick the winners?!". Great connection to the give away with this tutorial 🙂 !