| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If cell contains...
Hi
I'm sure this must be the easiest question ever but it's proving very difficult for me to find in the help and on Google. What is the Excel function that says "if A1 contains "fred" then 1, else 0". Note, A1 might contain Fred, Freddy or Alfredo, all should match. TIA Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
