Thanks Biff. Totally missed to handle blank cell.
--
If this post helps click Yes
---------------
Jacob Skaria


"T. Valko" wrote:

=IF(T(A1)=A1,"Text","None Text")

That might be ok but if A1 is an empty cell it'll return "Text".


--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
Use the T() function. Returns text if text.

=IF(T(A1)=A1,"Text","None Text")

If this post helps click Yes
---------------
Jacob Skaria


"Dredgeboat" wrote:

In using the If function, I would like to test if a cell has text in it,
not
specific text, just any text, such as a name (Tim Dyer). What do I use to
represent the text in the argument?