Hi all,

I have 3 columns.

B2: Has an ID:
21241391


J2 has a link:

https://rrrrrrr.eeeeee.com/betting/b...source=partner

K2 is where I am doing this:

=REPLACE(J2,49,7,B2)

I am trying to replace the ID in J2 with the ID from B2. However I am not getting the "?" symbol as can be seen in J2? any idea why?

*URL amended to maintain confidentialyity

thnk you!