excel 2007 duplicate data with unc path
Posted on 2010-11-22
I have 2 columns in excel 2007 with thousands of entries - ColumnA and ColumnB like so:
What I would like to do and am struggling to find an answer is take ColumnB as an input and remove the duplicated word.doc from columnA, so I would be left with the following:
I am unable to use find replace with wildcards using \ as an anchor, as I have multiple in the unc paths..