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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 26, 2010 at 12:55 PM
rizvisa1 Posts 4478 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
- Fenix internet on bank statement - Guide
- Excel if statement - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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
