Pasting data in specific place.

Copper Contributor

Good Day

 

I'm not sure if there is already a thread or post on this or if this is possible.

 

I need to know if there is a easier way to copy the model numbers in column A and paste it in between the " / " and " .jpg " in column B without having to copy and past each line individually. This is to load data onto a website so that the image links to the product, we have +- 120k products.

 

 

Thanking you in advance.

Excel.PNG

 

 

2 Replies

Ok so I played around and did some research on other forums and then got to this result which works 100%, but if there is another way feel free to post, the more we know the better.

 

Similarly to the CONCATENATE function, you can use "&" in Excel to combine different text strings, cell values and results returned by other functions. "

 

So now I just copy column E into my worksheet.

 

Solved.PNG

 

 

Hi @zanebadenhorst

 

I'm sharing a formula, hope it work for u.

because you find already a simple way to do your query.

ModelImage nameResultFormula in use
Test1A/1/.JpgA/1/Test1.JpgLEFT(B2,FIND(".",B2)-1)&A2&"."&RIGHT(B2,LEN(B2)-FIND(".",B2))
Test2B/2/.JpgB/2/Test2.JpgDrop down formula
Test3C/3/.JpgC/3/Test3.Jpg 
Test4D/4/.JpgD/4/Test4.Jpg 
Test5E/5/.JpgE/5/Test5.Jpg 
Test6F/6/.JpgF/6/Test6.Jpg 
Test7G/7/.JpgG/7/Test7.Jpg 
Test8H/8/.JpgH/8/Test8.Jpg 
Test9I/9/.JpgI/9/Test9.Jpg 
Test10J/10/.JpgJ/10/Test10.Jpg 
Test11K/11/.JpgK/11/Test11.Jpg 
Test12L/12/.JpgL/12/Test12.Jpg 
Test13M/13/.JpgM/13/Test13.Jpg 
Test100M/100/.JpgM/100/Test100.Jpg