Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using an IF statement from a pull down box | Excel Worksheet Functions | |||
Setting up an If-Then Statement that will pull from a valdiated li | Excel Worksheet Functions | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
How do I get an IF statement to pull a date range?? | Excel Worksheet Functions | |||
Pull-down text in a cell | Excel Worksheet Functions |