Replace a string

[kingsushi001]

Good day everyone

Can someone please help me with the following...

	A	B
1	http://www.xyz.co.za/ProdImg/AA13NDfl1uuL2c.jpg <tbody> </tbody>	http://www.africaestore.com/esquire/AA13NDfl1uuL2c.jpg <tbody> </tbody>
2	http://www.esquireshop.co.za/ProdImg/WDBYFT0020BB.jpg <tbody> </tbody>	http://www.africaestore.com/esquire/WDBYFT0020BB.jpg <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

I need to change A1 and A2 to look like B1 and B2. Basically just replacing before the last /
Is there a function or combination of functions I can use to achieve this?

Any help would be greatly appreciated.

 

[kingsushi001]

Good day everyone

Can someone please help me with the following...

	A	B
1	http://www.xyz.co.za/ProdImg/AA13NDfl1uuL2c.jpg <tbody> </tbody>	http://www.africaestore.com/esquire/AA13NDfl1uuL2c.jpg <tbody> </tbody>
2	http://www.esquireshop.co.za/ProdImg/WDBYFT0020BB.jpg <tbody> </tbody>	http://www.africaestore.com/esquire/WDBYFT0020BB.jpg <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

I need to change A1 and A2 to look like B1 and B2. Basically just replacing before the last /
Is there a function or combination of functions I can use to achieve this?

Any help would be greatly appreciated.

Ok, so I have another problem I can't seem to solve.

Some of the URL's contains a sub folder like this

http://www.xyz.co.za/ProdImg/AR-AS5520X4/AR-AS5520X4.jpg

<tbody>
</tbody>

I need it to be the same as my original post. Like so http://www.africaestore.com/esquire/AR-AS5520X4.jpg

Any ideas?

 

[FormR]

Some of the URL's contains a sub folder like this

http://www.xyz.co.za/ProdImg/AR-AS5520X4/AR-AS5520X4.jpg

<tbody>
</tbody>

Hi, here is one option:

Excel 2013/2016
	A	B
1	http://www.xyz.co.za/ProdImg/AA13NDfl1uuL2c.jpg	http://www.africaestore.com/esquire/AA13NDfl1uuL2c.jpg
2	http://www.esquireshop.co.za/ProdImg/WDBYFT0020BB.jpg	http://www.africaestore.com/esquire/WDBYFT0020BB.jpg
3	http://www.xyz.co.za/ProdImg/AR-AS5520X4/AR-AS5520X4.jpg	http://www.africaestore.com/esquire/AR-AS5520X4.jpg
4	http://www.xyz.co.za/A/B/C/D/E/F/G/H/I/AR-AS5520X4.jpg	http://www.africaestore.com/esquire/AR-AS5520X4.jpg
Sheet1

Cell Formulas
Range	Formula
B1	="http://www.africaestore.com/esquire/" &TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),99))

 

[sparkerk1]

Dear Sir,

Apologies for replying on this thread , i was not able to figure our how to start a new thread, hence I replied on this one

The 6 line come in 6 different cells , basically the attached image represents a fare which i need to extract specific numbers only

 

[kingsushi001]

Hi, here is one option:

Excel 2013/2016

	A	B
1	http://www.xyz.co.za/ProdImg/AA13NDfl1uuL2c.jpg	http://www.africaestore.com/esquire/AA13NDfl1uuL2c.jpg
2	http://www.esquireshop.co.za/ProdImg/WDBYFT0020BB.jpg	http://www.africaestore.com/esquire/WDBYFT0020BB.jpg
3	http://www.xyz.co.za/ProdImg/AR-AS5520X4/AR-AS5520X4.jpg	http://www.africaestore.com/esquire/AR-AS5520X4.jpg
4	http://www.xyz.co.za/A/B/C/D/E/F/G/H/I/AR-AS5520X4.jpg	http://www.africaestore.com/esquire/AR-AS5520X4.jpg

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 ="http://www.africaestore.com/esquire/" &TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),99)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you very much. Worked awesomely

 

[FormR]

Thank you very much. Worked awesomely

Great, good to hear

i was not able to figure our how to start a new thread

Click the brownish "+ Post New Thread" button towards the top left of the page linked below.

https://www.mrexcel.com/forum/excel-questions/

the attached image represents a fare which i need to extract specific numbers only

Images are not a good way to show your data - see the link below for a few better methods of sharing your expected results.

https://www.mrexcel.com/forum/about-board/508133-attachments.html