How to find embedded hyperlinks in a column (Mac Excel User)

[JJ EXCEL1234]

I have a spreadsheet with hundreds of rows of data. Each row should contain a hyperlink to that rows specific file in Column B ("PDF"). Currently, Column B has everything formatted as a hyperlink, even if it does not contain a hyperlink.

How do I find which cells under column B are hyperlinked and which are not without hovering over each cell in order to see if there is a hyperlink?

 

[SanjayGMusafir]

Just Googled and found this link - Check whether a cell contains a link in Excel

Works perfect