Breaking up Excel Cell into multiple lines

[wareagle1984]

I am stuck..the bottom line is I have a string:

String ="01/01/2014 I did this 02/05/2015 I just did this as well 05/06/2017"

Essentially I need to build the string as such:
NewString = "01/01/2014 I did this
02/05/2015 I just did this as well
05/06/2017"

I have been trying to write a loop in the string (and recordset) using a number of techniques, such as using INSTRREV to find character positions of the years (Note the years span over a decade) and inserting a chr(10) after the position but have not had much luck. I can do this in vba using access or excel - I really just need someone to help bounce some ideas off.

Thanks for any help or ideas, I am new to this forum but have a few years experience of VBA, Access and Excel.

 

[wareagle1984]

I should provide more clarity, I need to bring each of these strings AFTER the year.