if column contains text which is equal to text in cell A2 then it returns A2
Paste this in cell A2 and write {=IF(ISNUMBER(MATCH(A2,A3:A13,0)),A2,"")} in cell A1
1C8109 1C8160 1C8296 1C8507 1C8627 1C8722 1C8727 2C7461
1C8109
1C8160 1C8296 1C8627 1C8722 1C8727 2C7461