Forum Discussion

zanebadenhorst's avatar
zanebadenhorst
Copper Contributor
Jan 14, 2019

Pasting data in specific place.

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
  • Naveen1992's avatar
    Naveen1992
    Brass Contributor
    Jan 14, 2019

    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 

     

  • zanebadenhorst's avatar
    zanebadenhorst
    Copper Contributor
    Jan 14, 2019

    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.

     

     

     

Resources