I have a spreadsheet with various URLs column "A" and I am trying obtain a portion of the website for each link in Column B. Specifically, I am looking for the"Name" in website so I know which URL goes to which person.

Attached is a sample of the worksheet I am working with. Column A has the URLs, and column B has the names. Is there any way to obtain the name automatically obtain the name for Column B rather than manually going to the URL? Thanks.


NPI.xlsx