Problem:

Replacing the \"XX\" substring in each of the strings in column A with the corresponding number from column B.

Solution:

Use the LEFT, FIND, and MID functions as shown in the following formula:
=LEFT(A2,FIND(\"XX\",A2)-1)&B2&MID(A2,FIND(\"XX\",A2)+2,255)