Excel, If statement with part of text matchin
Closed
minseoul5
Posts
1
Registration date
Friday March 26, 2010
Status
Member
Last seen
March 26, 2010
-
Mar 26, 2010 at 12:33 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 26, 2010 at 12:55 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 26, 2010 at 12:55 PM
Related:
- Excel, If statement with part of text matchin
- Excel date format dd.mm.yyyy - Guide
- Excel if statement increment by 1 - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Fenix internet on bank statement - Guide
- How many if statements can you nest - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Mar 26, 2010 at 12:55 PM
Mar 26, 2010 at 12:55 PM
you can use FIND and SEARCH functions
=SEARCH(B1, A1,1)
=IF(ISERROR(SEARCH(B1, A1,1)), 0, 1)
etc
=SEARCH(B1, A1,1)
=IF(ISERROR(SEARCH(B1, A1,1)), 0, 1)
etc