Some YouTube videos have a list of chapters in their description. How can these chapter descriptions be split or separated into columns and rows? Usually the format in the description is as follows:
Time Description
00:00 Intro before you start
01:30 First part
02:45 Second part
03:50 Third part
05:15 End and conclusion
If this text is copied then pasted into a spreadsheet then the text will be in a single cell with the following format:
00:00 Intro before you start 01:30 First part 02:45 Second part 03:50 Third part
05:15 End and conclusion
Google Sheets has a split function and a split text to columns option but I can't figure out what a proper delimiter is for this. I'm guessing the first space following any integer could be the delimiter. Can this be done with a regular expression?