I have two columns with slightly different content.

For example
Column C has C:\code drop\NSM 25-07-2012 (Drop 3)\NSM 25-07-2012\App_Code\IDcardGeneration.cs
Column A has C:\team projects\NSM\web\NSMLive\Web\Shared\IDcardGeneration.cs

Something like Search column C and A for "IDcardGeneration.cs" string , when search string is found then insert that into column B of the of the same row where it appears in column A.


I need to do this for a excel file with thousands of entries

Thanks