View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Logical test of text?

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?