AnsweredAssumed Answered

Insert new characters in existing field

Question asked by davidphillips on Oct 29, 2008
Latest reply on Oct 29, 2008 by TSGal

Title

Insert new characters in existing field

Post

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?

Thanks,

David 

Outcomes