Excel formula to Remove everything in a Column followed by a Single "/"(Forward slash)

Hi!
I use Windows 7 with MS Office 2010

I have an excel file with a long list of links from social media, etc. in Column A

Eg:
Column A=

https://in.linkedin.com/in/abhra-d-5...mename-profile
https://in.linkedin.com/in/addy-bisht
https://www.facebook.com/pages/categ...8653264378096/
https://www.facebook.com/iMakeAnimations/
https://www.facebook.com/dcreationsofficial/
https://www.facebook.com/UofWA/reviews/
https://www.facebook.com/biz/interne...08424279189115
https://twitter.com/rebeltaxi
https://twitter.com/rjsuspect


I want a formula in COLUMN B to:
Remove everything from the 'column A' which are followed by a (Single forward slash) "/"
i.e.
Result:
Column B=

https://in.linkedin.com/
https://in.linkedin.com/
https://www.facebook.com/
https://www.facebook.com/
https://www.facebook.com/
https://www.facebook.com/
https://www.facebook.com/
https://twitter.com/
https://twitter.com/

I have attached an example file Test1
where my original source list is in Column A
The formula should be applied on Column B

Note: Column C - contains desired result (done manually)

Thank you

How about

Formula:

Please Login or Register  to view this content.