Here is a string separated by multi-character separator. To split this string into multiple strings by the separator “and”:

Script:

=spl("=?1.split@(""and"")",A1)

The function split is used to split the string into a sequence; the parameter “and” is used as the separator.
Result:

esProc Desktop and Excel Processing
15.2 Split string - separate by carriage return (CR) - automatic parsing of data type
15.4 Concatenate into string