How to embed numeric string in text in Excel?

Posted on

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.)

Leave a Reply

Your email address will not be published. Required fields are marked *