Vlookup or Index Formula

Hi All,

I have an excel sheet with google LinkedIn results extracted data. I want to get cells which contains "|" and next to the hyperlink cells in another sheet. Attached the sample input and manually mocked up output file for your reference. Plz help me to sort it out.

Thanks in advance!