| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND IF A CELL CONTAINS TEXT
We need to have a formula that can find a text in a cell and if text is in
the cell, return that text, otherwise, leave the cell blank. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FIND IF A CELL CONTAINS TEXT
Try
=IF(ISTEXT(A1),A1,"") If this post helps click Yes --------------- Jacob Skaria "Tree" wrote: We need to have a formula that can find a text in a cell and if text is in the cell, return that text, otherwise, leave the cell blank. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FIND IF A CELL CONTAINS TEXT
THANK YOU!!! This forum really ROCKS! Thanks again!! Have a GREAT weekend!
"Jacob Skaria" wrote: Try =IF(ISTEXT(A1),A1,"") If this post helps click Yes --------------- Jacob Skaria "Tree" wrote: We need to have a formula that can find a text in a cell and if text is in the cell, return that text, otherwise, leave the cell blank. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FIND IF A CELL CONTAINS TEXT
=T(A1)
"Tree" wrote: We need to have a formula that can find a text in a cell and if text is in the cell, return that text, otherwise, leave the cell blank. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find cell address of last cell in a column with text | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
Hybrid Mode
