Forum Discussion
Extracing a specific text within a url
I have an example url as follows: http://1secretsofsuccess.com I want to be able to extract the second number, 3975284149225354 , from the link. Not every URL is the same however they a...
Let's say the URL is in A1. In another cell in row 1, enter the formula
=TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",255)),1400,255))
This can be filled down if required.