Report

Formula for finding part of a word in a cell

Ask a question Shelly - Last answered 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
See more 
Helpful
+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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!