How to remove word after word upload/ in exel?

Question

excel

there are links
https://kazakhfilmstudios.kz/upload/resize_cache/iblock / 36d / 1050_600_0 / 36d672ab652eb1d016dbd942c24f318b.jpg,
https://kazakhfilmstudios.kz/upload/resize_cache/iblock / de0 / 1050_600_0 / de0a39c3b4c935ddb53be4a81113a5ec.jpg

lot of them and I need bring them to this form
/upload/de0a39c3b4c935ddb53be4a81113a5ec.jpg I deleted the resize_cache, iblock sections using the search replacement method in exel, but the /36d/ /de0/ section is unique and with what formula or function should I remove them? I don’t understand exel at all, so I will be very grateful if you tell me the finished formula!

Answer 1

=LEFT(A1;FIND("iblock";A1)-1)&RIGHT(A1;LEN(A1)-LEN(LEFT(A1;FIND("iblock";A1)-1))-LEN("iblock/XXX /"))
works if the original string is in A1, iblock is NOT REMOVED from it, the length of the variable segment to be deleted is static (always two slashes and three characters between them).
If Excel is Russian, the formula must be translated into Russian.
===
Or, alternatively, use find and replace: Looking for
:
/iblock/???
replace with:
<leave blank>

Answer 2

If the link is always of this kind, then the simplest thing I would do is:
- on the data input, the "text by columns" function, and select / as a separator
- the value "36d672ab652eb1d016dbd942c24f318b.jpg" will be in the last column
- then the formula = concatenate ("/upload/"; and a link to the data cell "36d672ab652eb1d016dbd942c24f318b.jpg")