how to parse data from one cell to multiple columns by a delimiter

Dion

Hi i would like some assistance parsing this data to multiple columns using a delimiter:

"|John doe1 1/1/25 02:00| Opened task
|John Doe2 1/1/25 02:10| Faxed
|John Doe3 1/1/25 02:10| Called Jane doe"

Paul Newcome

What would go where and based on what delimiter?

Dion

using | as the delimiter and segregate each text that follow to a new column

Paul Newcome

Ok. And is the above in a single cell, or is it three individual rows within the sheet?

Dion

I would like it to be in three individual columns

Paul Newcome

3 columns? You indicated using the pipe as your delimiter, but that would only parse out to two columns.

Is the data in your original post in a single cell, or is each line of the sample data its own row in the sheet?