Extracting Specific Text in String

Copper Contributor

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 

 

2 Replies

@fcbda 

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.

@fcbda 

If these are 16 digits numbers I'd simplify a bit

=MID(B3,FIND("posts/",B3)+6,16)