Split your text on a delimiter (TEXTSPLIT) The new TEXTSPLIT function allows you to split the content of your cell on a delimiter. It's very easy to use.
XLOOKUP is a Formula 1 XLOOKUP is the new Excel function to find data in a reference table. The function merge the benefits of VLOOKUP and INDEX