find a particular character in a cell

[tweety127]

hi,

i want to find a particular character in a cell and on the other cell, it will display true if the character exist and false if not. for example, i want to find the (*) on cell A1 and on the cell B1 if there is an (*) then it will display true and of none it will display false....can you help me with this?....this is really urgent....thanks so much for the help....

[MDubbelboer]

hi,

i want to find a particular character in a cell and on the other cell, it will display true if the character exist and false if not. for example, i want to find the (*) on cell A1 and on the cell B1 if there is an (*) then it will display true and of none it will display false....can you help me with this?....this is really urgent....thanks so much for the help....

=if(iserror(find("*",a1,1)),false,true)