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.
new excel function
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
