How to embed numeric string in text in Excel?

Posted on


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:



B2 then needs to be:

What is the easiest way to do this?


If you are looking to transform A2: “$” to “http://[…]/$.jpg”, then put this command in B2:

="" & 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 *