| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A fromula to pick up nontext in cell
I 2 columns, A & B. I have data in colunm a cells that are text but the text
varies from cell to cell, over in some of the cells there is the words INACTIVE. I want a fomrula that will look to colunm A and return the inactive text into column B else if the colunm is not INACTIVE return blank cells. hint I tried VLOOKUP, IF THEN, ISTEXT and no luck. Please HELP!!! chris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A fromula to pick up nontext in cell
=IF(A1="INACTIVE",A1,"")
or is that too simplistic? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "chris" wrote in message ... I 2 columns, A & B. I have data in colunm a cells that are text but the text varies from cell to cell, over in some of the cells there is the words INACTIVE. I want a fomrula that will look to colunm A and return the inactive text into column B else if the colunm is not INACTIVE return blank cells. hint I tried VLOOKUP, IF THEN, ISTEXT and no luck. Please HELP!!! chris |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A fromula to pick up nontext in cell
or, if there's other text in there as well as INACTIVE
=IF(ISERR(FIND("inactive",A1,1)),"",A1) Best rgds Chris Lav "Bob Phillips" wrote in message ... =IF(A1="INACTIVE",A1,"") or is that too simplistic? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "chris" wrote in message ... I 2 columns, A & B. I have data in colunm a cells that are text but the text varies from cell to cell, over in some of the cells there is the words INACTIVE. I want a fomrula that will look to colunm A and return the inactive text into column B else if the colunm is not INACTIVE return blank cells. hint I tried VLOOKUP, IF THEN, ISTEXT and no luck. Please HELP!!! chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions | |||
| How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
