QUESTION :
I need to copy and paste thousands of numeric values, from A2-A10000 to B2-B10000, with some text around it. Here is one example:
A2:
5047612445
B2 then needs to be:
http://www.example.com/images/5047612445.jpg
What is the easiest way to do this?
ANSWER :
If you are looking to transform A2: “$” to “http://[…]/$.jpg”, then put this command in B2:
="http://www.example.com/images/" & A2 & ".jpg"
(Note that extra spaces are shown here in the formula for readability but aren’t necessary.)