| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using "find" or "search" to find commas
Here's the formula: =IF(SEARCH(",",F121)0,"y","n") I'm looking for commas, the above formula returns a "y" when it finds a comma, however it doesn't return the "n" when it doesn't... I get a #value! error. What have I done wrong? -- Shakespeare ------------------------------------------------------------------------ Shakespeare's Profile: http://www.excelforum.com/member.php...o&userid=21552 View this thread: http://www.excelforum.com/showthread...hreadid=530809 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace | Excel Worksheet Functions | |||
| Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
| Edit + Find | Excel Discussion (Misc queries) | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
Threaded Mode
