Re: If then statement to search for text possible?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Think I was braindead :-(

Cheers Dave

Regards
Ken...............

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:43DEB821.469AECEA@xxxxxxxxxxxxxxxxxxx
>I bet you meant:
> =if(countif(a3,"*hou*"),"houston",0)
>
> Ken Wright wrote:
>>
>> =IF(SEARCH("*HOU*",A3),"Houston",0)
>>
>> --
>> Regards
>> Ken....................... Microsoft MVP - Excel
>> Sys Spec - Win XP Pro / XL 97/00/02/03
>>
>> ------------------------------­------------------------------­----------------
>> It's easier to beg forgiveness than ask permission :-)
>> ------------------------------­------------------------------­----------------
>>
>> "Steve" <Steve@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:FB1699A5-7665-4779-8878-272568F68939@xxxxxxxxxxxxxxxx
>> >I was wondering if there is a way to write an if statement like this:
>> >
>> > =if(a1="*HOU*", "Houston",0)
>> >
>> > So that if the text in cell A1 contains "HOU" then it would return
>> > "Houston".
>> >
>> > I know it works if the cell is an exact match, but what about if it
>> > only
>> > contains the word???
>> >
>> > HELP!
>> >
>> > Thanks!
>
> --
>
> Dave Peterson


.

Relevant Pages