ExcelBanter - Identify a hyperlink

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Identify a hyperlink (https://www.excelbanter.com/excel-discussion-misc-queries/103161-identify-hyperlink.html)

shantanu oak

Identify a hyperlink

I have a column formatted in blue (& underline) and some of the cells
are hyperlinks.
How do I know which cells are only text and missing the link?

All times are GMT +1. The time now is 10:31 PM.