Previously when trying to accomplish this I have gone into Find & Replace and looked for whatever is the catalyst for the line break and then done 'Replace with' ctrl+j

But in this instance it isn't working, so if there's a way to resolve with a formula then that would be so helpful.

Essentially my data is something like this


Ford Focus, Mondeo, Kuga >. Toyota Avensis, Celica, Rav 4 >. Kia Picanto, Ceed >.



and I want the data to look like this:

Focus Focus, Mondey, Kuga

Toyota Avensis, Celica, Rav 4

Kia Picanto, Ceed


So I want it to look for the >. and then introduce a line break (CHAR10?) in there.

If anyones able to help that would be so much appreciated.