b2397 b9504 b3333 b8655 bxxxx
I would like to combine each value with a URL, for example:
From Cell A2, I auto-filled all the way down to Cell A6. The problem is whenever I try to click on the links, only the first cell (A2) works and the rest (from Cells A3 to A6) that were auto-filled do not. The links that do not leads me to a website stating: "No Such Record" which is not true, because when I try to plug in the formula combining URL and alphanumeric value manually instead of auto-fill, it leads me to the proper link. (I really do not want to do each cell manually...)
Why does it only work for the first cell and not the rest that were auto-filled? I tried someone's suggestion of "find and replace" to possibly refresh the links, but it doesn't work.