The SPLIT function in Google Sheets is used to divide a text string (or value) around a given delimiter, and output the separate pieces into their own cells.
I love when you take a formula and dig in further Ben. I have used this three different times in my work this week. For example, I used multiple INDEX formulas to clean uo data where there were multiple points of data in the same cell =INDEX(SPLIT(A1,” “),1,1)&” “&INDEX(SPLIT(A1,” “),1,2). I was hoping that I could select multiple items using the INDEX formula in the same manner as the VLOOKUP formula, but it does not seem to be possible.