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:

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1658971343051
https://c.scudata.com/article/1659061408754