View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terri Terri is offline
external usenet poster
 
Posts: 110
Default How do I write "begins with"?

I want my formula to say =if(B3 "begins with" Computer, B3, 0). So, I want
the formula to go to cell B3, if it begins with the word computer, (could be
computer desk, or computer monitor) then put it in the cell that I am in, if
not, put 0.
--
Terri
Amos Pewter