00:00I recently published a video on how you can convert this kind of data set which
00:03is data and comma separated into this format so that I can do sum and total at
00:08the bottom here. I'll leave the link to that video on my description but someone
00:12had a question. What if you have a multiple delimiter rather than just
00:15comma? Let's say semicolon like this and maybe a hyphen right about here. You can
00:20see that my result is actually basically breaking apart like this. How do you
00:25mitigate that? Well basically you're gonna have to introduce an array of
00:28delimiter like this. Basically put a curly braces here like this like that and
00:33inside the curly brace you define all your delimiters. I've got semicolon hyphen
00:37and comma like this and basically copy the delimiter array of delimiter and apply
00:44to the text split function as well like this and hit enter and now if you apply
00:48the same formula to the rest of the row like this the data set is now split with
00:54semicolon hyphen and comma now.
