Extract data from a formula

I am rewriting some inefficient workbooks and need to extract data that someone has hardcoded into about 800 formulas.

The formula typically looks like this:

Please Login or Register  to view this content.

I need to extract the PLUKBA code from this formula and place it in its own cell.

Is there a way I can do this using either a conventional formula or VBA code?

Thanks for any help!