Code to replace text as a part match

Morning,

I have the following line of code which replaces certain text as a direct match, how can i change this to a part match;

For example;

I want to replace A214 with A200, on the data i have A214AW. I still want to change the A214.

How do i change my code?

Please Login or Register  to view this content.

Use

Please Login or Register  to view this content.

Am glad it worked.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save