ISTEXT Function in Excel

Home/Excel Formulas/ISTEXT Function in Excel

What is the use of ISTEXT function?

ISTEXT Function in Excel returns TRUE if the given value is a string/text, otherwise returns FALSE

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


What is the syntax of ISTEXT function?

ISTEXT Function in Excel- Syntax

ISTEXT( value)

value : value to be checked

ISTEXT Function in Excel – Examples

ISTEXT Function in Excel- Example 1

Example 1: Returns FALSE as the given value is not a string
Example 2: Returns TRUE as the given value is a string
Example 3: Returns FALSE as the given value is not a string
Example 4: Returns FALSE as the given value is not a string

Reference:

Please refer the below article for more Information Excel functions.
Information Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

 
 
Related Resource External VBA Reference
Excel VBA Reference Project Management Reference
VBA Reference:
Excel Reference:
By |March 25th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment


Related pages


vba adodb recordset exampleexcel vba recordset getrows3d bubble chart excel 2010for loop in excel vbaoffset excel functionwhat is vba macroexcel vba worksheet open eventhow to protect excel from editingvba trimcreating dashboards in excelexcel unlock workbookexcel project management dashboard templateexcel vba interiorinterview questions asked in genpact for financedeveloper tab in excel 2010calculator vb codeestimating templatesvlookup macro excelconditionals in excelmerge multiple excel files into one sheet vbavba backcolorhow can i find duplicates in excelevents at excelvb source code examplesvba objectsurface chart in excelhighlight duplicate in excelexcel schedule plannervlookup excel explainedexcel bubble plotmerging worksheets in excelexcel dashboard add inswhat is the password to unprotect a sheet on excelif statement in macro excelhow to use the sumif functionunhide tabs in excelexcel vba queryunshare excel workbookexcel macro remove duplicatesmerge cells excelrefresh all pivot tables vbaunprotecting excelvba chart typesddl commands sqlexcel erase duplicatesexcel vba specify rangemark duplicates excelhow to check for duplicates in excelexcel 2003 pivot tablessearching for duplicates in excelddl dml commandssorting an excel spreadsheetexcel vba windowsprogramming macros in excelhow create macro in excelexcel workbook savecell function worksheetuserform comboboxvba variablesexcel form vbaremove duplicates excel 2010unlock vba codeexcel macro msgboxlook up function in excelshortcut key to insert row in excel 2010how to get rid of duplicate rows in exceldml statement in sqlvba excel file existsexcel macro hide rowsms access vba msgboxexcel project management templatelock excel worksheetdefinition of excel formulasvba combobox control sourceremove duplicates excel 2007colorindex exceluseful excel sheetsvba filecopyexcel formula example sheetgoto excel vbaunlock excel without password