How to search column of data for specific string and extract to new column

Hello,

I have a large database of information from a PLC program. The program extracted the data to excel but merged all the data into one cell down a column of ~13000 lines. The devices that are being used are located in the cells. What I need is something where I can search all the lines in the column depending on what device name is which I have a list of and in a new column next to the corresponding cell, have the device name solely. Here is an example:

All down column D, so for D10 and D475 it has:
D10 = B40147.9^CV-10 AVB MAN PL RAM 00073
D475 = B40845.1^CV-10 RUN 03A100001

What I would do is input somewhere CV-10 and it would go through the whole spreadsheet and find where all the CV-10's are and in the next column copy this string. So for E10 and E475, they would contain CV-10.

Any help with this would be great.

Thanks,
-AS