FIND IF A CELL CONTAINS TEXT

[Tree]

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.

 

[Jacob Skaria]

Try

=IF(ISTEXT(A1),A1,"")

If this post helps click Yes

 

[Teethless mama]

=T(A1)

 

[Tree]

THANK YOU!!! This forum really ROCKS! Thanks again!! Have a GREAT weekend!