Hello Alicia,
Normally, using the text to columns tool you need to type in the delimiter.
If you have some dynamic format, where this delimiter is in another field and changes from row to row, my suggestion is to create a macro and filter by these specific delimiters and update the parameter of the text to columns tool using a control parameter.
Best,
Gustavo.
