| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 5135 | 2000-07-30 20:11:00 | Excel 2000 | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 5634 | 2000-07-30 20:11:00 | I am using the formula =IF(SEARCH('Food*',F1),B1,' ') to search for text 'Food*' in a worksheet. How can I get a space in the cell when the searched text does not contain 'Food*'. I get a #Value! result with the above formula |
Guest (0) | ||
| 1 | |||||