Cell A1 is the following text data "SCR: 27001.01, 27002.01, 27003.01,
27004.01, 27005.01."

Cell a2 is the following text data "SCR: 29001.01, 29002.01, 29003.01,
27004.01, 29005.01."

27004.01 is duplicated text in both cells.

Is there a formula or a macro to check for duplicated data (that has been
entered as text)?


--
Thomas