Harlan Grove

Posts: n/a

"Jason Morin" wrote...
=IF(ISNUMBER(SEARCH("-",A1)),"value_1","value_2")

Alternatives.

=IF(COUNTIF(A1,"*-*"),"Yay!","Boo!")

=IF(SUBSTITUTE(A1,"-","")<A1,"Yay!","Boo!")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Print the results of a search	Celestina	Excel Discussion (Misc queries)	1	January 12th 05 01:04 AM
Q: search in string	JIM.H.	Excel Discussion (Misc queries)	5	January 5th 05 10:24 PM
Excel 2000 - How to create an auto search	echo7	Excel Discussion (Misc queries)	1	December 17th 04 04:32 PM
Search for a Sheet	Chance224	Excel Discussion (Misc queries)	3	December 14th 04 12:29 AM
better search: "make worksheet visible"	christo	Excel Discussion (Misc queries)	1	December 1st 04 12:20 AM

All times are GMT +1. The time now is 05:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us