ExcelBanter - Pull text from cell with if statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pull text from cell with if statement (https://www.excelbanter.com/excel-discussion-misc-queries/221490-pull-text-cell-if-statement.html)

Doug

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?

Eduardo

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?

Luke M

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?

All times are GMT +1. The time now is 09:25 AM.