Insert new characters in existing field
I am re-vamping our Item Numbers for Catalog, Price Book, and organizational purposes. I need to add characters as a prefix to the existing Item Number. I have tried Find & Replace. If I want to add NR to an Item Number (BALEX2) I find "B" and replace this with "NRB". This works fine if there are no other "B"s in the Item Number. If there is a "B" in the Item Number, the result is NR planted right in the middle of the new Item Number. Is there an easier way?