PDA

View Full Version : Excel 2000



31-07-2000, 08:11 AM
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