looking for a function
 

Is there a function (or an addin with this function) that just defines wethera character is present in a string or not ?
("Find" gives an error-string if the character is not present).
Thanks,
Gilbert

looking for a function
 

Hi

Try
=IF(ISNUMBER(FIND(your find formula)),"do 1",do 2")

--

Regards
Roger Govier
"Gilbert De Ceulaer" wrote in message ...
Is there a function (or an addin with this function) that just defines wethera character is present in a string or not ?
("Find" gives an error-string if the character is not present).
Thanks,
Gilbert

looking for a function
 

=isnumber(find(...))
will return true/false if the string is found.



Gilbert De Ceulaer wrote:

Is there a function (or an addin with this function) that just defines wethera
character is present in a string or not ?
("Find" gives an error-string if the character is not present).
Thanks,
Gilbert


--

Dave Peterson

looking for a function
 

Hi Gilbert,

What do you want returned if a string is not present?

Try something like

=IF(ISERROR(FIND("a",A1)),"NotFound",FIND("a",A1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"Gilbert De Ceulaer" wrote in message ...
Is there a function (or an addin with this function) that just defines wethera character is present in a string or not ?
("Find" gives an error-string if the character is not present).
Thanks,
Gilbert

looking for a function
 

On Thu, 29 Nov 2007 22:10:41 +0100, "Gilbert De Ceulaer"
wrote:

Is there a function (or an addin with this function) that just defines wethera character is present in a string or not ?
("Find" gives an error-string if the character is not present).
Thanks,
Gilbert

You can simply test for the error:

For example:

=if(iserr(find(...),"Not Prsent","Present")


--ron

looking for a function
 

Sorry, typo
Missing set of quotes
=IF(ISNUMBER(FIND(your find formula)),"do 1","do 2")

Replace Do 1 and Do 2 with whatever you want depending on the outcome of the test.

--

Regards
Roger Govier
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ...
Hi

Try
=IF(ISNUMBER(FIND(your find formula)),"do 1",do 2")

--

Regards
Roger Govier
"Gilbert De Ceulaer" wrote in message ...
Is there a function (or an addin with this function) that just defines wethera character is present in a string or not ?
("Find" gives an error-string if the character is not present).
Thanks,
Gilbert