View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Pull text from cell with if statement

For example if a set of cells read BEG70
DEG60
BEG80
and I want to write an if statement that will pull all the cells where the
text starts with BEG ( I want to pull BEG70 and BEG80) how do I do that?