Replace hyphenated prefix of concatenated columns removing to much

[capson]

I have multiple dynamically created concatenated column.

The data in the columns all have prefix's and I do not know in advance of running the code what the prefix's are, the data in the the columns look like:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

etc...

I need to remove all the hyphenated prefix's so it looks like:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I am using the replace code below but the

Please Login or Register  to view this content.

is removing every thing before the last concatenated element i.e I end up with

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Not sure how to write the Replace part to work in this instance

Thanks

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[capson]

Thanks Ben,

The code works only for the first instance of the prefix I get this

Please Login or Register  to view this content.

But need

Please Login or Register  to view this content.

[capson]

In further effort my code works with a two step process

first

Please Login or Register  to view this content.

Then

Please Login or Register  to view this content.

[apo]

Hi..

Try this one too.. seemed to work on the data you provided.

Click the button on the "Test" sheet.

Please Login or Register  to view this content.

[capson]

Thanks apo that works great