| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
String of data in a cell. Want to use 'contains' in an 'if' statem
Is there a way of writing the following?
=if ( cell 'contains' x , then write "y" , else write "n" ) The cell contains text. Suggestions appreciated, thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| Copy a string text to cell if another cell not empty | Excel Discussion (Misc queries) | |||
| IN AN IF FORMULA COPY STRING OF DATA IF A CELL IS CORRECT | Setting up and Configuration of Excel | |||
Threaded Mode
