Formula help

[Donai]

Hi, i am after a formula in col A that will return Yes or NO if an apostrophe is found within a string

<TABLE style="WIDTH: 386pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=515 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 338pt; mso-width-source: userset; mso-width-alt: 16493" width=451><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17>YES</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=451>CIT1-Outstanding settlement a/c. No rec req'd - Mark Wood 5/1/11</TD></TR></TBODY></TABLE>

 

[AlphaFrog]

Try something like this...
=IF(ISNUMBER(FIND("'",B1)), "Yes", "No")

 

[T. Valko]

Hi, i am after a formula in col A that will return Yes or NO if an apostrophe is found within a string

<TABLE style="WIDTH: 386pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=515 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 338pt; mso-width-source: userset; mso-width-alt: 16493" width=451><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17>YES</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=451>CIT1-Outstanding settlement a/c. No rec req'd - Mark Wood 5/1/11</TD></TR></TBODY></TABLE>

Try this...

=IF(COUNT(FIND("'",B2)),"Yes","No")

 

[Airfix9]

=IF(ISERROR(FIND("'",B1)),"No","Yes")

Edit to suit. Please note after FIND( there is " ' "

 

[Donai]

Thankyou all

 

[T. Valko]

Thankyou all

You're welcome!