View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Pull text from cell with if statement

Hi,
Why you don't use filter and select the information as per below

"Doug" wrote:

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?