Ask a question Report

Formula for finding part of a word in a cell

Shelly - Latest answer on Dec 6, 2010 08:53AM
I was wondering if there is a formula for finding part of a word in a excel cell. For example I have several manufacturers name in one cell and some manufacturers name in another cell. I want it to tell me if they are the same. For example in cell A1 I have ABC and in cell H1 I have ABC Corp. Can it tell me that they are the same because of the ABC?
Read more 

moins plus
Hi Shelly,

See if this formula structure can benefit you:
=IF(ISERROR(SEARCH(A1,H1)),"Not found","Found")

Best regards,
Add comment
This document entitled « formula for finding part of a word in a cell » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.

Not a member yet?

sign-up, it takes less than a minute and it's free!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.