Clear text within cell

[srosk]

This is probably another simple one. I have values stored in column B, and I need to take some parts of the text out. Here's an example.

Testing 1; Testing 2; Testing 3

In this scenario, I need to sometimes delete "Testing 2; " but in other scenarios "; Testing 3" would need to be removed. I am ok listing out both possibilities in the vba code.. I just couldn't find proper code for my needs.

Thank you in advance!

 

[Scott Huish]

Sub Test()
Range("B:B").Replace "Testing 2;", ""
End Sub

 

[srosk]

Simple enough. Great, thank you!