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


autofit excel vbavlookups in excel 2010shared workbookprogramming excel vbaexcel password cracker macroexcel if isnaexcel rgb formulams access vba functionswhat is sumif functionhow to put things in alphabetical order in excelexcel formulas to find duplicatesvba create hyperlinkhow to eliminate blank rows in excelcustomer management excel templatelearn excel macros step by stephow to merge two columns in excelaccess query vbahow to use the sumif function in microsoft excel 2010open userform vbaexcel vba left functionmacro to save excel filevba basic tutorialpivotal table in excelexcel macro delete empty rowsconvert from excel to xmlinteractive excel dashboardsdata definition language commandsmacro to refresh pivot tablehow to use advanced filter in excelcol_index_num vlookupexcel macro write to text fileactivate sheet vbaindex formula in excel 2007linking pivot tablescode vbastacked clustered chart excel 2013vba excel msgbox yes novba concatenate functionschedule spreadsheet template excelexcel last cell in columnvba get file extensionhow to unprotect an excel filevbscript check file existslearn excel vlookupexcel formula to copy cell valueaccess vba forecolorpurge excel filevba excel programsaccess vba export query to excelvba sheet nameexcel 2007 autofit row heightformatting charts in excelhow to delete empty rowshow to lock spreadsheetexcel hide duplicatessql query questions and answers pdfexcel macro hide columnsopen recordset vbaexcel power pivot tutorialvba array functionsunderstanding vlookuphow do you remove password protection from excel 2010how to use a sumifcopy file vbaalternative to vlookupsimple dashboard in excelcreating pivot charts in excel 2010excel macro row countisnumber excelhow to create a worksheet in excel 2007vba workbook activateusing the vlookup functionexcel vba if multiple conditionscopy and paste in vbahow do i unprotect an excel worksheethow to protect excel sheet with passwordgoto statement vbainserting check boxes in excelexcel vba userform examplesunprotect worksheet forgot passwordexcel isnumber