Forum Discussion
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 betwee...
I'm sharing a formula, hope it work for u.
because you find already a simple way to do your query.
| Model | Image name | Result | Formula in use |
| Test1 | A/1/.Jpg | A/1/Test1.Jpg | LEFT(B2,FIND(".",B2)-1)&A2&"."&RIGHT(B2,LEN(B2)-FIND(".",B2)) |
| Test2 | B/2/.Jpg | B/2/Test2.Jpg | Drop down formula |
| Test3 | C/3/.Jpg | C/3/Test3.Jpg | |
| Test4 | D/4/.Jpg | D/4/Test4.Jpg | |
| Test5 | E/5/.Jpg | E/5/Test5.Jpg | |
| Test6 | F/6/.Jpg | F/6/Test6.Jpg | |
| Test7 | G/7/.Jpg | G/7/Test7.Jpg | |
| Test8 | H/8/.Jpg | H/8/Test8.Jpg | |
| Test9 | I/9/.Jpg | I/9/Test9.Jpg | |
| Test10 | J/10/.Jpg | J/10/Test10.Jpg | |
| Test11 | K/11/.Jpg | K/11/Test11.Jpg | |
| Test12 | L/12/.Jpg | L/12/Test12.Jpg | |
| Test13 | M/13/.Jpg | M/13/Test13.Jpg | |
| Test100 | M/100/.Jpg | M/100/Test100.Jpg |