Extract text from string

[Temporary-Failure]

I have thousands of rows which has string like

<img src="https://www.rd-shop.de/out/pict/gene/product/1/450_/sposet_gr_14045.jpg" /><br>

String length is not always same, url can vary etc. How I extrack string "sposet_gr_14045.jpg" from cell? It is picture file.

 

[sandy666]

with your example

use PowerQuery

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Column1[/td][td][/td][td=bgcolor:#70AD47]Column1[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]< img src="https://www.nd-shop.de/out/pictus/generd/product/2/450_450_75/sposet_gr_14045_02.jpg" /><br>[/td][td][/td][td=bgcolor:#E2EFDA]sposet_gr_14045_02.jpg[/td][/tr]
[/table]

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table13"]}[Content],
    #"Extracted Text Between Delimiters" = Table.TransformColumns(Source, {{"Column1", each Text.BetweenDelimiters(_, "/", """", {1, RelativePosition.FromEnd}, 0), type text}})
in
    #"Extracted Text Between Delimiters"[/SIZE]

 

[Temporary-Failure]

Thanks but I forgot to tell that I use office 2003.

 

[sandy666]

ooops ! sorry
so I can't help

have a nice day

 

[RoryA]

If the string always ends the same (i.e. with " /><br>) then you could use:

=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,LEN(A1)-8),"/",REPT(" ",1000)),1000))

 

[Temporary-Failure]

Working, thank you!