How do I extract a specific id from a discripton cell

[JHO26]

I have an excel file with raw data pulled from a program that we use to document faults. The program generates a ID for each fault with date location, responsible dept, ect. Each row in the file is an entry. One of the columns is a fault description in which the cell of that row has a brief description of the fault. If the fault is due to incorrect assembly of a connector, the cell will identify the connector ID somewhere in the text. connectors are identified as "***DB**" or "***A1**". If there were multiple connectors bad there will be multiple connectors called out in the cell with the description. If there are no connector faults there will be no connector ID listed in the cell. How do I extract the connector ID (or multiple id's) listed to a new column so I can use the data to identify most commonly discrepant connectors

 

[alansidman]

Please use XL2BB to show us a sample data and mocked up solution. You will have better success showing us an example.