Extract varied character number string from URL

Hello, I'm new to the forum. I've been trying to solve this little formula for a few days, and can't quite crack how to extract a string of numbers that vary from 4 to 6 characters in length, and are numbers. They always sit in between a "/" and "."

Here are a couple example URLs ( it wouldn't let me post the entire URL since it's my first post):

/example-product-url-here/8552.html
/example-product-url-here/175563.html

I've tried the following formula:

=mid(A29,Search("/",A29,50)+1,15)

and it gives me this:

8552.html
175563.html

but can't figure out how to get rid of the ".html" as well. Any help would be great!

This should work.

=MID(A1,FIND("/",A1,10)+1,(FIND(".",A1)-1)-FIND("/",A1,10))

This worked perfectly. Thank you!

Hi,

Use this if your URL strings can possibly be of varying length, and the SEARCH for "/" may Not necessary produce the correct result if started at 50.

This will produce the correct results for Any length URL, as long as the number you want is Always after the Last "/" :

Formula:

Please Login or Register  to view this content.