Some help in excel formula extracting data

[stuartbrisgel]

Hello Y'all

PART 1
2=32002-6013938-new


I want

N2=32002
O2=4211050

PART 2

AB = https://cdn.shopify.com/s/files/1/0368/2485/products/6013938.jpeg?v=1405679174


I want to

USE O2 Value

to Make new cell

https://cdn.shopify.com/s/files/1/0368/2485/products/4211050.jpeg?v=1405679174

 

[VBA Geek]

<b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C2</th><td style="text-align:left">=LEFT(<font color="Blue">A2&"-",FIND(<font color="Red">"-",A2</font>)-1</font>)</td></tr></tbody></table></td></tr></table><br />


<b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A4</th><td style="text-align:left">=REPLACE(<font color="Blue">A3,FIND(<font color="Red">"products/",A3</font>)+9,FIND(<font color="Red">".jpeg",A3</font>)-FIND(<font color="Red">"products/",A3</font>)-9,D2</font>)</td></tr></tbody></table></td></tr></table><br />

Excel 2013
	A	B	C	D	E	F	G	H
2	32002-6013938-new		32002	4211050
3	https://cdn.shopify.com/s/files/1/0368/2485/products/6013938.jpeg?v=1405679174
4	https://cdn.shopify.com/s/files/1/0368/2485/products/4211050.jpeg?v=1405679174
Sheet5