looking for a function

  • Thread starter Thread starter Gilbert De Ceulaer
  • Start date Start date
G

Gilbert De Ceulaer

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
 
Hi

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

--

Regards
Roger Govier
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
 
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



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
 
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
Click to expand...

You can simply test for the error:

For example:

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


--ron
 
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
Hi

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

--

Regards
Roger Govier
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
 
Back
Top