Split text by delimiter

How do I split multiple columns to rows by a delimiter character?

Please find an example in attachment.

Thank you,

Joao

Parse

Accepted answers

Is this what you're looking to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.

Regards,

Jonathan

Try the Text-to-columns tool in the Split to rows setting.

Is this what you're looking to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.

Regards,

Jonathan

Thanks I think it was helpful. But perhaps I was too simplistic.

Since it is a big dataset I don't know the exact number of delimiters per row (it may vary).

So I doesn't seem like it is working

E.g.

Thanks

Spoiler