ISTEXT function


Excel ยป Functions ยป Information ยป ISTEXT function ยป

If cell contains any text

The picture above shows different values in column B and a formula in column C that tries to identifies the [โ€ฆ]

How to use the ISTEXT function

The ISTEXT function returns TRUE if value is text. Formula in cell C3: =ISTEXT(B3) Excel Function Syntax ISTEXT(value) Arguments value [โ€ฆ]

Extract unique distinct values if adjacent cell is text

Question: I want a unique distinct list to be created from a column where an adjacent column has text cell [โ€ฆ]

en English
en Englishes Spanish