Previous Topic Next Topic

Formula for finding part of a word in a cell

Closed
Shelly - Dec 4, 2010 at 02:24 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 6, 2010 at 08:53 AM
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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 6, 2010 at 08:53 AM
Hi Shelly,

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

Best regards,
Trowa
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to convert the tamil pdf file to tamil word file
varathalakshmi -
karthik -

12 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response