Thread: Does the cell contain the character "-" within the string?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Does the cell contain the character "-" within the string?
A couple mo
=countif(a1,"*-*")0
=isnumber(search("-",a1))

Eric wrote:

Does anyone know how to determine the cell containing the character "-" with
the string? for example
In cell A1, =" - ", which include the character "-", then return true in B1.
Thank for any suggestion
Eric

--

Dave Peterson
Reply With QuoteReply With Quote