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

Pull and do what??
An array answer is
=IF(LEFT(A2:A5,3)="BEG",A2:A5,)
Entered using Ctrl+Shift+Enter


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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?