View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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