Think I was braindead :-(

Cheers Dave

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

"Dave Peterson" wrote in message
...
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" wrote in message
...
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