Hello guys. I want to extract a portion of url and merge it with " @facebook.com" .
For example , I put http://facebook.com/groups/1234456/ in cell A1 , then I have [email protected] in cell B1. If I have http://facebook.com/groups/christopher in cell A2 I should have [email protected] in cell B2.
Thanks.
=SUBSTITUTE(RIGHT(A1,LEN(A1)-27),"/","")&"@groups.facebook.com"
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
If it is a one time thing you can use TextToColumns and break the cells out by "/"
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
thanks @special-k . It worked!
A little prpblem though, when I paste https://www.facebook.com/groups/124178424281618/ , I get [email protected] instead of [email protected]
Try
=SUBSTITUTE(RIGHT(A13,LEN(A13)-FIND("groups",A13)-6),"/","")&"@groups.facebook.com"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks