Pull text from cell with if statement

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

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?
 
Pull and do what??
An array answer is
=IF(LEFT(A2:A5,3)="BEG",A2:A5,)
Entered using Ctrl+Shift+Enter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Statement 5
Pulling a specific email from cells and putting info in new row 4
If Statements 1
If statement with dates 0
Multiple cell formulas in different cells 7
Pulling Data from other excel workbooks? 5
Excel Functions 6
=IF function, reference problem to "text strings" in Data Validati 2

Back
Top