Partial Match in 1 Column

[inneedforexcelhelp]

Hi,

I'm stuck on a list with 1 column consisting of 13000 company names. These company names some are partial matches. For example, Company ABC Pty Ltd. and Company ABC Proprietary Limited.
Is there anyway for me to be able to filter through this? Even a macro ...anything.
I only have 1 column and all I've found is comparing with 2 columns, I know you can do that with a Fuzzy Lookup.
Any help would be much appreciated.

Thanks!!

 

[Mike Szczesny]

Can you use something like this. I created a sample data field a1:a8. I used a criteria ABC. This is my formula

=IF(ISNUMBER(SEARCH($A$10,"*"&$A$1:$A$8&"*")),A1,"")

<tbody>
</tbody>

ABC Pty. Ltd.		ABC Pty. Ltd.
ABC Proprietary Limited		ABC Proprietary Limited
Smith Co
Rusk Inc.
Tex ABC Inc.		Tex ABC Inc.
Jones Inc.
N. ABC Inc		N. ABC Inc
West ABC Co		West ABC Co
ABC

<colgroup><col><col><col></colgroup><tbody>
</tbody>