Replace function help

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!

I doubt anyone is going to click a link like that. Rather, upload your sample file here to the forum.

Please try

=REPLACE(J2,47,8,B2)

or
=REPLACE(J2,FIND("?",J2)-LEN(B2),LEN(B2),B2)

to return hyperlink
=HYPERLINK(REPLACE(J2,47,8,B2))

=HYPERLINK(REPLACE(J2,FIND("?",J2)-LEN(B2),LEN(B2),B2))

This will look for the only "?" in string first, then find the max value in the left, replace it:

=SUBSTITUTE(J2,AGGREGATE(14,6,RIGHT(LEFT(J2,SEARCH("~?",J2)-1),ROW($1:$12))+0,1),B2)

Ty all! Solution found!