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