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
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
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:
- Formula for finding part of a word in a cell
- Word apk for pc - Download - Word processors
- How to delete part of a table in word - Guide
- How to search a word in a website - Guide
- How to insert a checkmark in word - Guide
- Number to word in excel formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 6, 2010 at 08:53 AM
Dec 6, 2010 at 08:53 AM
Hi Shelly,
See if this formula structure can benefit you:
Best regards,
Trowa
See if this formula structure can benefit you:
=IF(ISERROR(SEARCH(A1,H1)),"Not found","Found")
Best regards,
Trowa
