Microsoft Excel help

[wickedDUDE]

Hello,

I have a long list of URLs in Column A and a long list of URLs in Column B.

Both columns contain URLs that are similar, but they are not an exact match. I.e. some of the folder paths are the same, but not the entire path.

Is there an easy way to highlight all URLs that are similar in both columns? There are many variations for the folder paths, so it would be difficult to create a condition for each one.

Any help is appreciated.

 

[greenleaves]

drop it in notepad, replace / with a tab, paste into excel, sort ,if need be, filter.

 

[Fiver]

Do a search on YouTube for this stuff. There's one guy on there who has an Excel series for every possible Excel question you might have.