VBA To Cleanup Text

Hello

Can you suggest a vba to clean up text like this:

Please Login or Register  to view this content.

So the end result is

Please Login or Register  to view this content.

and text like this

Please Login or Register  to view this content.

ends up as

Please Login or Register  to view this content.

Thanks

Thanks - unfortunately the data is being imported some will need to apply vba on the new data.