{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","FIND Function","SEARCH Function","ISNUMBER FIND","ISNUMBER SEARCH","Find Feature","IF ISNUMBER FIND","IF ISNUMBER SEARCH","VBA Macro Code"],"not_rendered":{"charts":0,"images":0,"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":"Dataset","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Find Character in String"]
[null,"Name and ID","Character Sign","Character Number"]
[null,"Jane Doe-123",{"$f":"CHAR(97)","v":"a"},"Char(97)"]
[null,"Kit Harington_124",{"$f":"CHAR(103)","v":"g"},"Char(103)"]
[null,"Jane Austin 125&",{"$f":"CHAR(38)","v":"&"},"Char(38)"]
[null,"Julia Roberts 126!",{"$f":"CHAR(33)","v":"!"},"Char(33)"]
[null,"Andrew Eric 127",{"$f":"CHAR(101)","v":"e"},"Char(101)"]
[null,"Bob Harly\"128",{"$f":"CHAR(34)","v":"\""},"Char(34)"]
[null,"Rocky Montana*129",{"$f":"CHAR(50)","v":"2"},"Char(50)"]
[null,"Jay Hope#130",{"$f":"CHAR(48)","v":"0"},"Char(48)"]
[null,"Jony Wilson/131",{"$f":"CHAR(47)","v":"/"},"Char(47)"]

{"sheet":"FIND Function","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using FIND Function"]
[null,"Name and ID","Character Sign","Character Number","Character Position"]
[null,"Jane Doe-123",{"$f":"CHAR(97)","v":"a"},"Char(97)",{"$f":"FIND(C4,B4)","v":2}]
[null,"Kit Harington_124",{"$f":"CHAR(103)","v":"g"},"Char(103)",{"$f":"FIND(C5,B5)","v":10}]
[null,"Jane Austin 125&",{"$f":"CHAR(38)","v":"&"},"Char(38)",16]
[null,"Julia Roberts 126!",{"$f":"CHAR(33)","v":"!"},"Char(33)",18]
[null,"Andrew Eric 127",{"$f":"CHAR(101)","v":"e"},"Char(101)",5]
[null,"Bob Harly\"128",{"$f":"CHAR(34)","v":"\""},"Char(34)",10]
[null,"Rocky Montana*129",{"$f":"CHAR(50)","v":"2"},"Char(50)",16]
[null,"Jay Hope#130",{"$f":"CHAR(48)","v":"0"},"Char(48)",12]
[null,"Jony Wilson/131",{"$f":"CHAR(47)","v":"/"},"Char(47)",12]

{"sheet":"SEARCH Function","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SEARCH Function"]
[null,"Name and ID","Character Sign","Character Number","Character Position"]
[null,"Jane Doe-123",{"$f":"CHAR(97)","v":"a"},"Char(97)",{"$f":"SEARCH(C4,B4)","v":2}]
[null,"Kit Harington_124",{"$f":"CHAR(103)","v":"g"},"Char(103)",{"$f":"SEARCH(C5,B5)","v":10}]
[null,"Jane Austin 125&",{"$f":"CHAR(38)","v":"&"},"Char(38)",{"$f":"SEARCH(C6,B6)","v":16}]
[null,"Julia Roberts 126!",{"$f":"CHAR(33)","v":"!"},"Char(33)",18]
[null,"Andrew Eric 127",{"$f":"CHAR(101)","v":"e"},"Char(101)",5]
[null,"Bob Harly\"128",{"$f":"CHAR(34)","v":"\""},"Char(34)",10]
[null,"Rocky Montana*129",{"$f":"CHAR(50)","v":"2"},"Char(50)",16]
[null,"Jay Hope#130",{"$f":"CHAR(48)","v":"0"},"Char(48)",12]
[null,"Jony Wilson/131",{"$f":"CHAR(47)","v":"/"},"Char(47)",12]

{"sheet":"ISNUMBER FIND","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using ISNUMBER and FIND Function"]
[null,"Name and ID","Character Sign","Character Number","Character Status"]
[null,"Jane Doe-123",{"$f":"CHAR(97)","v":"a"},"Char(97)",{"$f":"ISNUMBER(FIND(C4,B4))","v":true}]
[null,"Kit Harington_124",{"$f":"CHAR(103)","v":"g"},"Char(103)",{"$f":"ISNUMBER(FIND(C5,B5))","v":true}]
[null,"Jane Austin 125&",{"$f":"CHAR(38)","v":"&"},"Char(38)",true]
[null,"Julia Roberts 126!",{"$f":"CHAR(33)","v":"!"},"Char(33)",true]
[null,"Andrew Eric 127",{"$f":"CHAR(101)","v":"e"},"Char(101)",true]
[null,"Bob Harly\"128",{"$f":"CHAR(34)","v":"\""},"Char(34)",true]
[null,"Rocky Montana*129",{"$f":"CHAR(50)","v":"2"},"Char(50)",true]
[null,"Jay Hope#130",{"$f":"CHAR(48)","v":"0"},"Char(48)",true]
[null,"Jony Wilson/131",{"$f":"CHAR(47)","v":"/"},"Char(47)",true]

{"sheet":"ISNUMBER SEARCH","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using ISNUMBER and SEARCH Function"]
[null,"Name and ID","Character Sign","Character Number","Character Status"]
[null,"Jane Doe-123",{"$f":"CHAR(97)","v":"a"},"Char(97)",{"$f":"ISNUMBER(SEARCH(C4,B4))","v":true}]
[null,"Kit Harington_124",{"$f":"CHAR(103)","v":"g"},"Char(103)",{"$f":"ISNUMBER(SEARCH(C5,B5))","v":true}]
[null,"Jane Austin 125&",{"$f":"CHAR(38)","v":"&"},"Char(38)",true]
[null,"Julia Roberts 126!",{"$f":"CHAR(33)","v":"!"},"Char(33)",true]
[null,"Andrew Eric 127",{"$f":"CHAR(101)","v":"e"},"Char(101)",true]
[null,"Bob Harly\"128",{"$f":"CHAR(34)","v":"\""},"Char(34)",true]
[null,"Rocky Montana*129",{"$f":"CHAR(50)","v":"2"},"Char(50)",true]
[null,"Jay Hope#130",{"$f":"CHAR(48)","v":"0"},"Char(48)",true]
[null,"Jony Wilson/131",{"$f":"CHAR(47)","v":"/"},"Char(47)",true]

{"sheet":"Find Feature","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Find Character in String"]
[null,"Name and ID","Character Sign","Character Number"]
[null,"Jane Doe-123",{"$f":"CHAR(97)","v":"a"},"Char(97)"]
[null,"Kit Harington_124",{"$f":"CHAR(103)","v":"g"},"Char(103)"]
[null,"Jane Austin 125&",{"$f":"CHAR(38)","v":"&"},"Char(38)"]
[null,"Julia Roberts 126!",{"$f":"CHAR(33)","v":"!"},"Char(33)"]
[null,"Andrew Eric 127",{"$f":"CHAR(101)","v":"e"},"Char(101)"]
[null,"Bob Harly\"128",{"$f":"CHAR(34)","v":"\""},"Char(34)"]
[null,"Rocky Montana*129",{"$f":"CHAR(50)","v":"2"},"Char(50)"]
[null,"Jay Hope#130",{"$f":"CHAR(48)","v":"0"},"Char(48)"]
[null,"Jony Wilson/131",{"$f":"CHAR(47)","v":"/"},"Char(47)"]

{"sheet":"IF ISNUMBER FIND","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using IF ISNUMBER and FIND Function"]
[null,"Name and ID","Character Sign","Character Number","Character Status"]
[null,"Jane Doe-123",{"$f":"CHAR(97)","v":"a"},"Char(97)",{"$f":"IF(ISNUMBER(FIND(C4,B4)),\"Found\",\"Not Found\")","v":"Found"}]
[null,"Kit Harington_124",{"$f":"CHAR(103)","v":"g"},"Char(103)",{"$f":"IF(ISNUMBER(FIND(C5,B5)),\"Found\",\"Not Found\")","v":"Found"}]
[null,"Jane Austin 125&",{"$f":"CHAR(38)","v":"&"},"Char(38)","Found"]
[null,"Julia Roberts 126!",{"$f":"CHAR(33)","v":"!"},"Char(33)","Found"]
[null,"Andrew Eric 127",{"$f":"CHAR(101)","v":"e"},"Char(101)","Found"]
[null,"Bob Harly\"128",{"$f":"CHAR(34)","v":"\""},"Char(34)","Found"]
[null,"Rocky Montana*129",{"$f":"CHAR(50)","v":"2"},"Char(50)","Found"]
[null,"Jay Hope#130",{"$f":"CHAR(48)","v":"0"},"Char(48)","Found"]
[null,"Jony Wilson/131",{"$f":"CHAR(47)","v":"/"},"Char(47)","Found"]

{"sheet":"IF ISNUMBER SEARCH","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using IF ISNUMBER and SEARCH Function"]
[null,"Name and ID","Character Sign","Character Number","Character Status"]
[null,"Jane Doe-123",{"$f":"CHAR(97)","v":"a"},"Char(97)",{"$f":"IF(ISNUMBER(SEARCH(C4,B4)),\"Found\",\"Not Found\")","v":"Found"}]
[null,"Kit Harington_124",{"$f":"CHAR(103)","v":"g"},"Char(103)",{"$f":"IF(ISNUMBER(SEARCH(C5,B5)),\"Found\",\"Not Found\")","v":"Found"}]
[null,"Jane Austin 125&",{"$f":"CHAR(38)","v":"&"},"Char(38)","Found"]
[null,"Julia Roberts 126!",{"$f":"CHAR(33)","v":"!"},"Char(33)","Found"]
[null,"Andrew Eric 127",{"$f":"CHAR(101)","v":"e"},"Char(101)","Found"]
[null,"Bob Harly\"128",{"$f":"CHAR(34)","v":"\""},"Char(34)","Found"]
[null,"Rocky Montana*129",{"$f":"CHAR(50)","v":"2"},"Char(50)","Found"]
[null,"Jay Hope#130",{"$f":"CHAR(48)","v":"0"},"Char(48)","Found"]
[null,"Jony Wilson/131",{"$f":"CHAR(47)","v":"/"},"Char(47)","Found"]

{"sheet":"VBA Macro Code","index":8,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Macro Code"]
[null,"Name and ID","Character Sign","Character Number","Character Position"]
[null,"Jane Doe-123",{"$f":"CHAR(97)","v":"a"},"Char(97)",{"$f":"FindM(C4,B4,1)","v":2}]
[null,"Kit Harington_124",{"$f":"CHAR(103)","v":"g"},"Char(103)",{"$f":"FindM(C5,B5,1)","v":10}]
[null,"Jane Austin 125&",{"$f":"CHAR(38)","v":"&"},"Char(38)",{"$f":"FindM(C6,B6,1)","v":16}]
[null,"Julia Roberts 126!",{"$f":"CHAR(33)","v":"!"},"Char(33)",{"$f":"FindM(C7,B7,1)","v":18}]
[null,"Andrew Eric 127",{"$f":"CHAR(101)","v":"e"},"Char(101)",{"$f":"FindM(C8,B8,1)","v":5}]
[null,"Bob Harly\"128",{"$f":"CHAR(34)","v":"\""},"Char(34)",{"$f":"FindM(C9,B9,1)","v":10}]
[null,"Rocky Montana*129",{"$f":"CHAR(50)","v":"2"},"Char(50)",{"$f":"FindM(C10,B10,1)","v":16}]
[null,"Jay Hope#130",{"$f":"CHAR(48)","v":"0"},"Char(48)",{"$f":"FindM(C11,B11,1)","v":12}]
[null,"Jony Wilson/131",{"$f":"CHAR(47)","v":"/"},"Char(47)",{"$f":"FindM(C12,B12,1)","v":12}]