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.
Bookmarks