Forum Discussion
fcbda
May 13, 2021Copper Contributor
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...
HansVogelaar
May 13, 2021MVP
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.