May 14 2021 09:14 AM
I have attached 3 instances of a link below:
What I would like to do is to be able to extract the 16 digit number after "posts/" for each of the links. That is all.
I have randomized the numbers within the links for confidentiality purposes and they will lead to broken pages.
Thank you!
https://www.facebook.com/319331008154444/posts/3949634461790232/?comment_id=3972705792816315&reply_c... |
https://www.facebook.com/110674865650231/posts/4125373270847756/ |
https://www.facebook.com/319331008154720/posts/3984168261670572/?comment_id=3984819191605454
|
May 14 2021 09:46 AM
With a string in A1, enter the following formula in for example B1:
=MID(A1,FIND("posts/",A1)+6,FIND("/",A1,FIND("posts/",A1)+6)-FIND("posts/",A1)-6)
This can be filled down.
May 15 2021 04:09 AM