String function

I

Irina

Hi guys,

The problem is:

I need to know if a cell contains special text, if "yes" then d
something.

When I use "search" it returns "#VALUE!" if the result is FALSE and
do know how to avoid it.

Thanks a lot in advance,

Irina
 
F

Frank Kabel

Hi
try
=IF(ISNUMBER(SEARCH("special",A1)),"do something","do something else")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Need help finding a substring in a array of strings. 1
Function to evaluate function as string 3
WORD VBA Search and switch to advanced ... 1
Right Function 2
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Searching the formula (not the value) for a text string 1
Function or Sub to help with text string 5

Top