View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Graham H Graham H is offline
external usenet poster
 
Posts: 56
Default If for word in sentence

Absolutely perfect Paul, works fine and is nice and tidy. Many thanks.

Graham

Paul C wrote:
Try this (assuming A14 would not start with "Information:" when there is the
extra phrase)

If Left(Range("A14"),11)=" Information" Then
Do Something
Else
Do Something Else
End if