Trying to batch Find and Replace Part Numbers within cells

[mastry]

Been searching around for a way to do this, but my complete lack of Excel knowledge and the seeming limited options for Office for Mac 2016 have me dead in my tracks.

One sheet has two columns to show part number supersedes.
For instance:

27241-300000,27243-300000

The other sheet has data formatted in a specific way to upload to a search system. One column is for product data, which contains all of the part number information.
For instance:

729902-01560|pos=0|qty=1|opt1=1;23876-030000|pos=1|qty=1|opt1=5;171051-01921|pos=2|qty=1|opt1=6;129900-02020|pos=3|qty=10|opt1=7;129900-02410|pos=4|qty=1|opt1=10;22351-060012|pos=5|qty=2|opt1=11;23876-030000|pos=6|qty=1|opt1=12;129900-01250|pos=7|qty=1|opt1=13;23876-030000|pos=8|qty=1|opt1=14;27241-300000|pos=9|qty=8|opt1=15;129900-02800|pos=10|qty=5|opt1=16;129900-02930|pos=11|qty=2|opt1=25;129900-01200|pos=12|qty=18|opt1=28;129902-01331|pos=13|qty=1|opt1=29|notes=UNDERSIZED PART U.S IS 0.25;129900-02340|pos=14|qty=5|opt1=30|notes=OVERSIZED PART O.S IS 0.25;129900-02940|pos=15|qty=2|opt1=33;

The few people in my office that use Excel on a daily basis are stumped thanks to the unusual data structure. Find and Replace one at a time works, but there are hundreds of part numbers to change for several documents, so I'm trying to create an automated workflow. I'm willing to use other software or resources for the process and importing the updated data back into excel as well if that helps.

Thank you for any assistance.

 

[BrianM]

Joe4 is the lifesaver... :D