I am trying to parse out words from a cell of data that are all between
the same characters ( ' )

For example, I have in one cell:

There is an error with 'Tom','Paul','Nicole' but then not with (or
including) 'Bill', 'Nancy'....

I am sorry I can't put the real data here but this is same scenario.

What I would like is in one cell to get Tom,Paul,Nicole,Bill,Nancy

instead of all the garbage in between.

Any ideas with this?

Please help if you can.

Thanks.

Conor Finnegan