That sounds very possible but for something like this it would be really
helpful to see a string of data.

Mike

" wrote:

Is it possible to find a string of data within a cell and extract the
next two words when it appears?

I have a large amount of text within column A for approximately 1000
lines. In column B onwards (dependent upon how many unique entries
there are) I want to pull out the next two words after "This has been
assigned to". This text may appear more than once, therefore the
second entry should be put in column C etc. etc...

I could do this for one entry using =FIND function however I'm not
sure how to do this for multiple entries and also pull out the next
two words as it's people's names so won't be a specific set of
characters.

Thanks in advance for your help with this.

Regards, Al.