How to locate specific text within a cell, starting from the right

[SimplySA]

Hi All,

I am but a mere newbie still and although I have worked through various training vids and understand a fair amount of most of the VBA code I see, I have a problem which I just cannot solve and hope someone here can be so kind as to help me out. I've been scouring the net and forums to find a solution, but most are close to what I am after, but fail when I try to adapt the code for my specific issue.

My issue is I am looking for either a formula or macro to look at a cell containing text, starting from the right hand side of a cell, identify a specific delimiter, lets say ---- as an example and only remove data to the left of the example once it finds the second instance of the example. Below is a typical text box for me and the way it would be generated. It always end with ----, some text, then again ----, more text and so on, with each instance of text being enclosed between these ---.

In sincerely hope someone can help me.

Text Box Example: (The length of text within each cell may change, but it will always have ---- between text fields and end with ---)
05/29/2014 09:05AM
Peter Williams (BG56586)

Not Home That Day
----
05/29/2014 09:08AM
Peter Williams (BG56586)

On the phone
----
05/29/2014 09:10AM
Peter Williams (BG56586)
Left early
----


The Desired Result should leave me with just;
----
05/29/2014 09:10AM
Peter Williams (BG56586)
Left early
----

[mehmetcik]

Hi

a simple user defined function is all you need:

Please Login or Register  to view this content.

[mehmetcik]

Hi

a simple user defined function is all you need:

Please Login or Register  to view this content.

[SimplySA]

Dear mehmetcik,

Wow, I have to be honest and never knew you could add an additional function to excel. I will be looking at this in more detail. It worked brilliantly. I cannot thank you enough.

Thank you for the amazing help!