ExcelBanter - FIND IF A CELL CONTAINS TEXT

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - FIND IF A CELL CONTAINS TEXT (https://www.excelbanter.com/excel-worksheet-functions/228027-find-if-cell-contains-text.html)

Tree

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.

Jacob Skaria

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.

Teethless mama

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.

Tree

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.

All times are GMT +1. The time now is 09:29 PM.