Extracting variable number of characters after defined number of characters & before defined text value

[Bayesatthemoon]

I want to extract a product code from an image url. Typical image url: http://s19.postimage.org/h3lmxzcar/RB2132_710.jpg in which the product code is RB2132_710

RB2132_710 has ten characters including the _, other product codes are longer or shorter. However, each image url begins with 35 characters ("http://s19.postimage.org/h3lmxzcar/") and ends with ".jpg"

So I want a mid function which extracts all characters after the 35th character and before the value ".jpg"

Any gurus out there who can help me please?

 

[VBA Geek]

Welcome

given your requirements, this should do it

=MID(A1,36,LEN(A1)-39)

 

[Bayesatthemoon]

Thank you maestro so very, very much, that's incredibly helpful and such a prompt response. U da man.