00:00If you have to split this raw data, which is a long string, into a column of salesperson
00:05and sales, and if you look at the raw data here, the salesperson column is actually delimited
00:10or separated using a colon, and the row is actually delimited using a semicolon.
00:17So you're going to have to use a function called tagSplit.
00:21First argument will be the location of where your raw data is, which is A2.
00:25Second argument, which is your column delimiter, which is going to be semicolon for us, and
00:29comma, and the row delimiter, or the next row, is going to be semicolon, like this, in double
00:36quote, of course, and close parenthesis, and hit enter, and it will split the raw data nicely
00:41into two columns here.
00:42And now, one thing to take away from this is that the function tagSplit is only available
00:47on Microsoft 365.
Comments