Take specific text from Excel cell and copy it in a new one

Take specific text from Excel cell and copy it in a new one - ( text and/or words position varies)


Hi,

I am trying to copy specific text from a cell and copy to a new cell.

The specific text position varies and some of the words also vary.

The specific text commences with the "Action Completed - ". However, the officers name and date vary. Examples of the specific text that I am trying to copy are:

Action Completed - FOR ACTION : Responsible Location: Depot - done by 'tbrown' on 3/1/2014 at 1:39 PM
Action Completed - FOR INFORMATION : Responsible Location: Depot - done by 'sgreen' on 8/1/2014 at 1:50 PM
Action Completed - GENERAL CORRESPONDENCE FOR INFORMATION ONLY : Responsible Location: Depot - done by 'dwhye' on 8/1/2014 at 1:50 PM

Thank you for your help

Sorry,

The cells generally contain about 5000 characters, so I need to copy the text from Action Completed to after the date.

Sorry,

The cells generally contain about 5000 characters, so I need to copy the text from Action Completed to after the date.

I don't need the time.