{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Contents","Introduction ISTEXT","ISTEXT","Number Store as Text","IF-ISTEXT","Validate Cell Input","Validate-Data Validation","Sumproduct -Text","Data Validation"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["ISTEXT Function"]
[null,"automateexcel.com/functions/istext-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction ISTEXT",null,null,null,"Excel Formulas w/Examples"]
[null,"ISTEXT",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Number Store as Text",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"IF-ISTEXT"]
[null,"Validate Cell Input"]
[null,"Validate-Data Validation"]
[null,"Sumproduct -Text"]
[null,"Data Validation"]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction ISTEXT","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ISTEXT ",null,"=ISTEXT (value)"]
[null,"The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not."]
[]
[null,"DATA","Result","Content _Column B"]
[null,{"$f":"TODAY()","v":"2021-08-31"},{"$f":"ISTEXT(B6)","v":false},"=TODAY()"]
[null,150,{"$f":"ISTEXT(B7)","v":false},150]
[null,"150",true,"'150"]
[null,"ABC",true,"ABC"]
[null,false,false,false]
[null,{"$f":"NOW()","v":44439.893818055556},false,"=NOW()"]
[]
[null,"automateexcel.com/functions/istext-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISTEXT","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["DATA","Result","Content _Column A"]
[{"$f":"TODAY()","v":"2021-08-31"},{"$f":"ISTEXT(A2)","v":false},"=TODAY()"]
[150,{"$f":"ISTEXT(A3)","v":false},150]
["150",true,"'150"]
["ABC",true,"ABC"]
[false,false,false]
[{"$f":"NOW()","v":44439.893818055556},false,"=NOW()"]
[null,null,null,null,null,null,null,null,null,null,null,"=NOW()"]
[]
[null,"automateexcel.com/functions/istext-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Number Store as Text","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["DATA","Result","Content _Column A"]
[{"$f":"10*15","v":150},{"$f":"ISTEXT(A2)","v":false},150]
["150",true,{"$f":"\"'150\"","v":"'150"}]
[]
[null,"automateexcel.com/functions/istext-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IF-ISTEXT","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["DATA","Result","Content _Column A"]
[{"$f":"TODAY()","v":"2021-08-31"},{"$f":"IF(ISTEXT(A2),\"text\", \"not text\")","v":"not text"},"=Today()"]
[150,{"$f":"IF(ISTEXT(A3),\"text\", \"not text\")","v":"not text"},150]
["150","text",{"$f":"\"'150\"","v":"'150"}]
["ABC","text","ABC"]
[false,"not text",false]
[{"$f":"NOW()","v":44439.893818055556},{"$f":"IF(ISTEXT(A7),\"text\", \"not text\")","v":"not text"},"=NOW()"]
[]
[null,"automateexcel.com/functions/istext-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Validate Cell Input","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Question","Answer","Validity"]
["1. First Name ?","Steven",{"$f":"IF(B2=\"\",\"\",IF(ISTEXT(B2),\"\",\"Invalid Entry\"))","v":""}]
["2. Last Name ?","Smith",{"$f":"IF(B3=\"\",\"\",IF(ISTEXT(B3),\"\",\"Invalid Entry\"))","v":""}]
["3. What is your hobby?",123,"Invalid Entry"]
["4. Do you have a Pet ?","No",""]
[]
[null,"automateexcel.com/functions/istext-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Validate-Data Validation","index":6,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Question","Answer"]
["1. First Name ?","Steven"]
["2. Last Name ?","Smith"]
["3. What is your hobby?"]
["4. Do you have a Pet ?"]
[]
[null,"automateexcel.com/functions/istext-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sumproduct -Text","index":7,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Value 01","Value 02","Value 03","Row Contain Text or Not ?"]
[7679,"F1234","X8790",{"$f":"IF(SUMPRODUCT(--ISTEXT(A2:C2))>0, \"Yes\", \"No\")","v":"Yes"}]
[5678,2346,8908,{"$f":"IF(SUMPRODUCT(--ISTEXT(A3:C3))>0, \"Yes\", \"No\")","v":"No"}]
["X5627","Y7678","C6877",{"$f":"IF(SUMPRODUCT(--ISTEXT(A4:C4))>0, \"Yes\", \"No\")","v":"Yes"}]
["C7289",6767,"C6527",{"$f":"IF(SUMPRODUCT(--ISTEXT(A5:C5))>0, \"Yes\", \"No\")","v":"Yes"}]
[]
[null,"automateexcel.com/functions/istext-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Data Validation","index":8,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Value 01","Value 02","Value 03"]
["F1234",7679,"X8790"]
[5678,"B6729",8908]
["X5627","Y7678","C6877"]
["C7289",6767,"C6527"]
[]
[null,"automateexcel.com/functions/istext-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]