View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hawksby Hawksby is offline
external usenet poster
 
Posts: 16
Default Is there such a thing as a contains formula

Afternoon all,

I'm looking to reference a cell and return a specific value if it contains a
certain text string / strings. Does anyone know of a way of doing this. The
Text string is not always at the begining or end of the field so left and
right are unusable

Thanks in advance