If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|