Extract data from a formula

[Cumberland]

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!

[duane]

what do you mean by

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

Do you mean replace the word PLUKBA by a cell reference containing PLUKBA?

very unclear.