Comparing two columns of data that are near identical

Hello

I need some help, I have two sets of data that I can't do an advanced filter on.

They are basically the same but have different endings so to speak.

Column A
Shaun -10.00.52110-EN-1.0.0
Clippos10.00
Column B
Shaun 10
Clippos 10

I would like to be able do a sort of advanced filter to find matches or possible matches in a automatic way.

Also I would like to do this on a Column as well where I might have the same data but just prefixed with a ABC or something.

Column A
ShaunSoftware -10.00.52110-EN-1.0.0
ABC Shaun Software -10.00

The problem with these prefixes or appendages are they are random and are different lengths.

Any help most appreciated.

Could the FIND function come to your assistance?

Set up a spare column with:
=IF(ISNUMBER(FIND(B$1,A#)),A#,"")
(where # is the current row number)
then set B1 to Shaun

Any row that includes Shaun anywhere in the text in column A will be copied to the new column.
All other rows will remain blank.

Some variation on this might provide what you want.

Mark.