Ask a question Report

Formula for finding part of a word in a cell

Shelly - Latest answer on Dec 6, 2010 08:53AM
Hello,
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?
Thanks
Read more 
Answer
+0
moins plus
Hi Shelly,

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

Best regards,
Trowa
Add comment
This document entitled « formula for finding part of a word in a cell » from CCM (ccm.net) 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.