Thread: Query - Formula (Test for string)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
  
Posts: 274
Default Query - Formula (Test for string)
Hi mralmac,

Try this

If Left(Range("B4").Value, 3) = "CD-" Then

Regards

Michael Beckinsale

Reply With QuoteReply With Quote