output similarities from two columns into new column

Question

how to compare  columns and find similarity and output the similarities in new column

unknown · Answer

sample file attached.
i need to filter out remarks column with respect to OWS(component). but due to manual data recording , the terminology used are different . OWS , 15 PPM calibration, oily water separator, calibration & certification 15ppm all these words denote  - OWS component.

\

Basically i want to filter out component - OWS 
1. fuzzy match can be used to group these words and assume it as OWS

2. or can i find multiple words and replace them with OWS

sample input .xlsx

mceleavey · Answer

@Inactive User ,

if you post the data rather than a screenshot we can help, but you also need to provide the logic.

What you have said is you would like to compare them but not how. Do you mean match them? Find where Remarks exist in Item Name?

Please provide more information.

M.

unknown · Answer

above this is 2 column(remarks & item name) for which i would like to compare them. In the remarks column, it contains data which are not structured like ( for one same items each personnel had given their own terminology .) i need to filter it out and make into new column and then filter it out later for analysis