{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Case of String","CHAR function 1","CHAR function 2","Remove blank spaces","Extract text 1","Extract text 2","Extract text 3","Extract text 4","Extract text 5","Concatenation"],"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":"Case of String","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Name","Result Upper Case","Formula Used"]
[null,"jack Ruster",{"$f":"UPPER(B3)","v":"JACK RUSTER"},"=UPPER(B2)"]
[null,"jOy akien",{"$f":"UPPER(B4)","v":"JOY AKIEN"},"=UPPER(B3)"]
[]
[null,"Name","Result Lower Case","Formula Used"]
[null,"jack Ruster",{"$f":"LOWER(B7)","v":"jack ruster"},"=LOWER(B7)"]
[null,"jOy akien",{"$f":"LOWER(B8)","v":"joy akien"},"=LOWER(B8)"]
[]
[null,"Name","Result Upper Case","Formula Used"]
[null,"jack Ruster",{"$f":"PROPER(B11)","v":"Jack Ruster"},"=PROPER(B11)"]
[null,"jOy akien",{"$f":"PROPER(B12)","v":"Joy Akien"},"=PROPER(B12)"]

{"sheet":"CHAR function 1","index":1,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Code ","CHAR ","Formula","Code ","CHAR ","Formula","Code ","CHAR ","Formula","Code ","CHAR ","Formula","Code ","CHAR ","Formula"]
[1,{"$f":"CHAR(A2)","v":"\u0001"},{"$f":"CONCATENATE(\"=CHAR(\",A2,\")\")","v":"=CHAR(1)"},26,{"$f":"CHAR(D2)","v":"\u001a"},{"$f":"CONCATENATE(\"=CHAR(\",D2,\")\")","v":"=CHAR(26)"},51,{"$f":"CHAR(G2)","v":"3"},{"$f":"CONCATENATE(\"=CHAR(\",G2,\")\")","v":"=CHAR(51)"},76,{"$f":"CHAR(J2)","v":"L"},{"$f":"CONCATENATE(\"=CHAR(\",J2,\")\")","v":"=CHAR(76)"},101,{"$f":"CHAR(M2)","v":"e"},{"$f":"CONCATENATE(\"=CHAR(\",M2,\")\")","v":"=CHAR(101)"}]
[2,{"$f":"CHAR(A3)","v":"\u0002"},{"$f":"CONCATENATE(\"=CHAR(\",A3,\")\")","v":"=CHAR(2)"},27,{"$f":"CHAR(D3)","v":"\u001b"},{"$f":"CONCATENATE(\"=CHAR(\",D3,\")\")","v":"=CHAR(27)"},52,{"$f":"CHAR(G3)","v":"4"},{"$f":"CONCATENATE(\"=CHAR(\",G3,\")\")","v":"=CHAR(52)"},77,{"$f":"CHAR(J3)","v":"M"},{"$f":"CONCATENATE(\"=CHAR(\",J3,\")\")","v":"=CHAR(77)"},102,{"$f":"CHAR(M3)","v":"f"},{"$f":"CONCATENATE(\"=CHAR(\",M3,\")\")","v":"=CHAR(102)"}]
[3,"\u0003","=CHAR(3)",28,"\u001c","=CHAR(28)",53,"5","=CHAR(53)",78,"N","=CHAR(78)",103,"g","=CHAR(103)"]
[4,"\u0004","=CHAR(4)",29,"\u001d","=CHAR(29)",54,"6","=CHAR(54)",79,"O","=CHAR(79)",104,"h","=CHAR(104)"]
[5,"\u0005","=CHAR(5)",30,"\u001e","=CHAR(30)",55,"7","=CHAR(55)",80,"P","=CHAR(80)",105,"i","=CHAR(105)"]
[6,"\u0006","=CHAR(6)",31,"\u001f","=CHAR(31)",56,"8","=CHAR(56)",81,"Q","=CHAR(81)",106,"j","=CHAR(106)"]
[7,"\u0007","=CHAR(7)",32," ","=CHAR(32)",57,"9","=CHAR(57)",82,"R","=CHAR(82)",107,"k","=CHAR(107)"]
[8,"\b","=CHAR(8)",33,"!","=CHAR(33)",58,":","=CHAR(58)",83,"S","=CHAR(83)",108,"l","=CHAR(108)"]
[9,"\t","=CHAR(9)",34,"\"","=CHAR(34)",59,";","=CHAR(59)",84,"T","=CHAR(84)",109,"m","=CHAR(109)"]
[10,"\n","=CHAR(10)",35,"#","=CHAR(35)",60,"<","=CHAR(60)",85,"U","=CHAR(85)",110,"n","=CHAR(110)"]
[11,"\u000b","=CHAR(11)",36,"$","=CHAR(36)",61,"=","=CHAR(61)",86,"V","=CHAR(86)",111,"o","=CHAR(111)"]
[12,"\f","=CHAR(12)",37,"%","=CHAR(37)",62,">","=CHAR(62)",87,"W","=CHAR(87)",112,"p","=CHAR(112)"]
[13,"\r","=CHAR(13)",38,"&","=CHAR(38)",63,"?","=CHAR(63)",88,"X","=CHAR(88)",113,"q","=CHAR(113)"]
[14,"\u000e","=CHAR(14)",39,"'","=CHAR(39)",64,"@","=CHAR(64)",89,"Y","=CHAR(89)",114,"r","=CHAR(114)"]
[15,"\u000f","=CHAR(15)",40,"(","=CHAR(40)",65,"A","=CHAR(65)",90,"Z","=CHAR(90)",115,"s","=CHAR(115)"]
[16,"\u0010","=CHAR(16)",41,")","=CHAR(41)",66,"B","=CHAR(66)",91,"[","=CHAR(91)",116,"t","=CHAR(116)"]
[17,"\u0011","=CHAR(17)",42,"*","=CHAR(42)",67,"C","=CHAR(67)",92,"\\","=CHAR(92)",117,"u","=CHAR(117)"]
[18,"\u0012","=CHAR(18)",43,"+","=CHAR(43)",68,"D","=CHAR(68)",93,"]","=CHAR(93)",118,"v","=CHAR(118)"]
[19,"\u0013","=CHAR(19)",44,",","=CHAR(44)",69,"E","=CHAR(69)",94,"^","=CHAR(94)",119,"w","=CHAR(119)"]
[20,"\u0014","=CHAR(20)",45,"-","=CHAR(45)",70,"F","=CHAR(70)",95,"_","=CHAR(95)",120,"x","=CHAR(120)"]
[21,"\u0015","=CHAR(21)",46,".","=CHAR(46)",71,"G","=CHAR(71)",96,"`","=CHAR(96)",121,"y","=CHAR(121)"]
[22,"\u0016","=CHAR(22)",47,"/","=CHAR(47)",72,"H","=CHAR(72)",97,"a","=CHAR(97)",122,"z","=CHAR(122)"]
[23,"\u0017","=CHAR(23)",48,"0","=CHAR(48)",73,"I","=CHAR(73)",98,"b","=CHAR(98)",123,"{","=CHAR(123)"]
[24,"\u0018","=CHAR(24)",49,"1","=CHAR(49)",74,"J","=CHAR(74)",99,"c","=CHAR(99)",124,"|","=CHAR(124)"]
[25,"\u0019","=CHAR(25)",50,"2","=CHAR(50)",75,"K","=CHAR(75)",100,"d","=CHAR(100)",125,"}","=CHAR(125)"]
[]
[]
["Code ","CHAR ","Formula","Code ","CHAR ","Formula","Code ","CHAR ","Formula","Code ","CHAR ","Formula","Code ","CHAR ","Formula"]
[151,{"$f":"CHAR(A30)","v":"—"},{"$f":"CONCATENATE(\"=CHAR(\",A30,\")\")","v":"=CHAR(151)"},176,{"$f":"CHAR(D30)","v":"°"},{"$f":"CONCATENATE(\"=CHAR(\",D30,\")\")","v":"=CHAR(176)"},201,{"$f":"CHAR(G30)","v":"É"},{"$f":"CONCATENATE(\"=CHAR(\",G30,\")\")","v":"=CHAR(201)"},226,{"$f":"CHAR(J30)","v":"â"},{"$f":"CONCATENATE(\"=CHAR(\",J30,\")\")","v":"=CHAR(226)"},251,{"$f":"CHAR(M30)","v":"û"},{"$f":"CONCATENATE(\"=CHAR(\",M30,\")\")","v":"=CHAR(251)"}]
[152,{"$f":"CHAR(A31)","v":"˜"},{"$f":"CONCATENATE(\"=CHAR(\",A31,\")\")","v":"=CHAR(152)"},177,{"$f":"CHAR(D31)","v":"±"},{"$f":"CONCATENATE(\"=CHAR(\",D31,\")\")","v":"=CHAR(177)"},202,{"$f":"CHAR(G31)","v":"Ê"},{"$f":"CONCATENATE(\"=CHAR(\",G31,\")\")","v":"=CHAR(202)"},227,{"$f":"CHAR(J31)","v":"ã"},{"$f":"CONCATENATE(\"=CHAR(\",J31,\")\")","v":"=CHAR(227)"},252,"ü","=CHAR(252)"]
[153,"™","=CHAR(153)",178,"²","=CHAR(178)",203,"Ë","=CHAR(203)",228,"ä","=CHAR(228)",253,"ý","=CHAR(253)"]
[154,"š","=CHAR(154)",179,"³","=CHAR(179)",204,"Ì","=CHAR(204)",229,"å","=CHAR(229)",254,"þ","=CHAR(254)"]
[155,"›","=CHAR(155)",180,"´","=CHAR(180)",205,"Í","=CHAR(205)",230,"æ","=CHAR(230)",255,"ÿ","=CHAR(255)"]
[156,"œ","=CHAR(156)",181,"µ","=CHAR(181)",206,"Î","=CHAR(206)",231,"ç","=CHAR(231)",256,{"$error":"#VALUE!"},"=CHAR(256)"]
[157,"\u009d","=CHAR(157)",182,"¶","=CHAR(182)",207,"Ï","=CHAR(207)",232,"è","=CHAR(232)"]
[158,"ž","=CHAR(158)",183,"·","=CHAR(183)",208,"Ð","=CHAR(208)",233,"é","=CHAR(233)"]
[159,"Ÿ","=CHAR(159)",184,"¸","=CHAR(184)",209,"Ñ","=CHAR(209)",234,"ê","=CHAR(234)"]
[160," ","=CHAR(160)",185,"¹","=CHAR(185)",210,"Ò","=CHAR(210)",235,"ë","=CHAR(235)"]
[161,"¡","=CHAR(161)",186,"º","=CHAR(186)",211,"Ó","=CHAR(211)",236,"ì","=CHAR(236)"]
[162,"¢","=CHAR(162)",187,"»","=CHAR(187)",212,"Ô","=CHAR(212)",237,"í","=CHAR(237)"]
[163,"£","=CHAR(163)",188,"¼","=CHAR(188)",213,"Õ","=CHAR(213)",238,"î","=CHAR(238)"]
[164,"¤","=CHAR(164)",189,"½","=CHAR(189)",214,"Ö","=CHAR(214)",239,"ï","=CHAR(239)"]
[165,"¥","=CHAR(165)",190,"¾","=CHAR(190)",215,"×","=CHAR(215)",240,"ð","=CHAR(240)"]
[166,"¦","=CHAR(166)",191,"¿","=CHAR(191)",216,"Ø","=CHAR(216)",241,"ñ","=CHAR(241)"]
[167,"§","=CHAR(167)",192,"À","=CHAR(192)",217,"Ù","=CHAR(217)",242,"ò","=CHAR(242)"]
[168,"¨","=CHAR(168)",193,"Á","=CHAR(193)",218,"Ú","=CHAR(218)",243,"ó","=CHAR(243)"]
[169,"©","=CHAR(169)",194,"Â","=CHAR(194)",219,"Û","=CHAR(219)",244,"ô","=CHAR(244)"]
[170,"ª","=CHAR(170)",195,"Ã","=CHAR(195)",220,"Ü","=CHAR(220)",245,"õ","=CHAR(245)"]
[171,"«","=CHAR(171)",196,"Ä","=CHAR(196)",221,"Ý","=CHAR(221)",246,"ö","=CHAR(246)"]
[172,"¬","=CHAR(172)",197,"Å","=CHAR(197)",222,"Þ","=CHAR(222)",247,"÷","=CHAR(247)"]
[173,"­","=CHAR(173)",198,"Æ","=CHAR(198)",223,"ß","=CHAR(223)",248,"ø","=CHAR(248)"]
[174,"®","=CHAR(174)",199,"Ç","=CHAR(199)",224,"à","=CHAR(224)",249,"ù","=CHAR(249)"]
[175,"¯","=CHAR(175)",200,"È","=CHAR(200)",225,"á","=CHAR(225)",250,"ú","=CHAR(250)"]

{"sheet":"CHAR function 2","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Country road,take me home","To the place I belong"]
[]
[null,{"$f":"$B$2 & CHAR(1) & $C$2","v":"Country road,take me home\u0001To the place I belong"},"=$B$2 & CHAR(1) & $C$2"]
[null,{"$f":"REPLACE($B$2,13,1,CHAR(10))","v":"Country road\ntake me home"},"=REPLACE($B$2,13,1,CHAR(10))"]
[null,{"$f":"REPLACE($B$2,13,1,CHAR(10))","v":"Country road\ntake me home"},"=REPLACE($B$2,13,1,CHAR(13)&CHAR(10))"]
[null,{"$f":"REPLACE($B$2,13,1,CHAR(32))","v":"Country road take me home"},"=REPLACE($B$2,13,1,CHAR(32))"]
[null,{"$f":"REPLACE($B$2,13,1,CHAR(160))","v":"Country road take me home"},"=REPLACE($B$2,13,1,CHAR(160))"]

{"sheet":"Remove blank spaces","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Example","TRIM Function","Formula"]
[null,"  All my Memories geathered round her    ",{"$f":"TRIM(B3)","v":"All my Memories geathered round her"},"=TRIM(B3)"]
[null,"   Miner's lady, stranger    to blue water",{"$f":"TRIM(B4)","v":"Miner's lady, stranger to blue water"},"=TRIM(B4)"]
[null,"      Dark and dusty      painted on the sky    ","Dark and dusty painted on the sky","=TRIM(B5)"]
[null,"Misty     taste of moonshine   ","Misty taste of moonshine","=TRIM(B6)"]
[null,"              Teardrop           in my eye  ","Teardrop in my eye","=TRIM(B7)"]
[null,"Country road,     take me home","Country road, take me home","=TRIM(B8)"]
[null,"   To the place    I belong","To the place I belong","=TRIM(B9)"]

{"sheet":"Extract text 1","index":4,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Example","LEFT Function","Formula","MID Function","Formula","RIGHT Function","Formula"]
[null,"Name: Jack Height: 192 cm Weight: 75 kg",{"$f":"LEFT(B3,10)","v":"Name: Jack"},"=LEFT(B3,10)",{"$f":"MID(B3,11,15)","v":" Height: 192 cm"},"=MID(B3,11,15)",{"$f":"RIGHT(B3,13)","v":"Weight: 75 kg"},"=RIGHT(B3,13)"]
[null,"Name: Marie Height: 172 cm Weight: 55 kg",{"$f":"LEFT(B4,11)","v":"Name: Marie"},"=LEFT(B4,11)",{"$f":"MID(B4,12,15)","v":" Height: 172 cm"},"=MID(B4,12,15)",{"$f":"RIGHT(B4,13)","v":"Weight: 55 kg"},"=RIGHT(B4,13)"]
[]
[null,"Example","LEFT Function","Formula","MID Function","Formula"]
[null,"Name: Jack Height: 92 cm Weight: 30 kg",{"$f":"LEFT($B7,FIND(\"Height\",$B7,1)-2)","v":"Name: Jack"},"=LEFT($B7,FIND(\"Height\",$B7,1)-2)",{"$f":"MID(B7,FIND(\"Height\",$B7,1),FIND(\"Weight\",$B7,1) - FIND(\"Height\",$B7,1))","v":"Height: 92 cm "},"=MID(B7,FIND(\"Height\",$B7,1),FIND(\"Weight\",$B7,1) - FIND(\"Height\",$B7,1))"]
[null,"Name: Marie Height: 172 cm Weight: 55 kg",{"$f":"LEFT($B8,FIND(\"Height\",$B8,1)-2)","v":"Name: Marie"},"=LEFT($B8,FIND(\"Height\",$B8,1)-2)",{"$f":"MID(B8,FIND(\"Height\",$B8,1),FIND(\"Weight\",$B8,1) - FIND(\"Height\",$B8,1))","v":"Height: 172 cm "},"=MID(B8,FIND(\"Height\",$B8,1),FIND(\"Weight\",$B8,1) - FIND(\"Height\",$B8,1))"]
[null,null,null,null,"RIGHT Function","Formula"]
[null,null,null,null,{"$f":"RIGHT(B7,LEN($B7) - FIND(\"Weight\", $B7, 1)+1)","v":"Weight: 30 kg"},"=RIGHT(B7,LEN($B7) - FIND(\"Weight\", $B7, 1)+1)"]
[null,null,null,null,{"$f":"RIGHT(B8,LEN($B8) - FIND(\"Weight\", $B8, 1)+1)","v":"Weight: 55 kg"},"=RIGHT(B8,LEN($B8) - FIND(\"Weight\", $B8, 1)+1)"]
[]
[null,"Example","LEFT Function","Formula","MID Function","Formula"]
[null,"Name: Jack Height: 92 cm Weight: 30 kg",{"$f":"LEFT($B14,FIND(\"height\",$B14,1)-2)","v":{"$error":"#VALUE!"}},"=LEFT($B14,FIND(\"height\",$B14,1)-2)",{"$f":"MID(B14,FIND(\"height\",$B14,1),FIND(\"Weight\",$B14,1) - FIND(\"Height\",$B14,1))","v":{"$error":"#VALUE!"}},"=MID(B14,FIND(\"height\",$B14,1),FIND(\"Weight\",$B14,1) - FIND(\"Height\",$B14,1))"]
[null,"Name: Marie Height: 172 cm Weight: 55 kg",{"$f":"LEFT($B15,FIND(\"height\",$B15,1)-2)","v":{"$error":"#VALUE!"}},"=LEFT($B15,FIND(\"height\",$B15,1)-2)",{"$f":"MID(B15,FIND(\"height\",$B15,1),FIND(\"Weight\",$B15,1) - FIND(\"Height\",$B15,1))","v":{"$error":"#VALUE!"}},"=MID(B15,FIND(\"height\",$B15,1),FIND(\"Weight\",$B15,1) - FIND(\"Height\",$B15,1))"]
[null,null,null,null,"RIGHT Function","Formula"]
[null,null,null,null,{"$f":"RIGHT(B14,LEN($B14) - FIND(\"Weight\", $B14, 1)+1)","v":"Weight: 30 kg"},"=RIGHT(B14,LEN($B14) - FIND(\"Weight\", $B14, 1)+1)"]
[null,null,null,null,{"$f":"RIGHT(B15,LEN($B15) - FIND(\"Weight\", $B15, 1)+1)","v":"Weight: 55 kg"},"=RIGHT(B15,LEN($B15) - FIND(\"Weight\", $B15, 1)+1)"]
[]
[null,"Example","LEFT Function","Formula","MID Function","Formula"]
[null,"Name: Jack Height: 92 cm Weight: 30 kg",{"$f":"LEFT($B21,SEARCH(\"height\",$B21,1)-2)","v":"Name: Jack"},"=LEFT($B21,SEARCH(\"height\",$B21,1)-2)",{"$f":"MID(B21,SEARCH(\"height\",$B21,1),SEARCH(\"Weight\",$B21,1) - SEARCH(\"height\",$B21,1))","v":"Height: 92 cm "},"=MID(B21,SEARCH(\"height\",$B21,1),SEARCH(\"Weight\",$B21,1) - SEARCH(\"height\",$B21,1))"]
[null,"Name: Marie Height: 172 cm Weight: 55 kg",{"$f":"LEFT($B22,SEARCH(\"height\",$B22,1)-2)","v":"Name: Marie"},"=LEFT($B22,SEARCH(\"height\",$B22,1)-2)",{"$f":"MID(B22,SEARCH(\"height\",$B22,1),SEARCH(\"Weight\",$B22,1) - SEARCH(\"height\",$B22,1))","v":"Height: 172 cm "},"=MID(B22,SEARCH(\"height\",$B22,1),SEARCH(\"Weight\",$B22,1) - SEARCH(\"height\",$B22,1))"]
[null,null,null,null,"RIGHT Function","Formula"]
[null,null,null,null,{"$f":"RIGHT(B21,LEN($B21) - SEARCH(\"Weight\", $B21, 1)+1)","v":"Weight: 30 kg"},"=RIGHT(B21,LEN($B21) - SEARCH(\"Weight\", $B21, 1)+1)"]
[null,null,null,null,{"$f":"RIGHT(B22,LEN($B22) - SEARCH(\"Weight\", $B22, 1)+1)","v":"Weight: 55 kg"},"=RIGHT(B22,LEN($B22) - SEARCH(\"Weight\", $B22, 1)+1)"]

{"sheet":"Extract text 2","index":5,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Jack940123456789",0,1,2,3,4,5,6,7,8,9]
[null,"Example","Postion of \nfirst number","Formula",null,"=FIND(G1,$F$1)",{"$f":"FIND(G1,$F$1)","v":7},8,9,10,6,12,13,14,15,5]
[null,"Jack94",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},B3&\"0123456789\"))","v":5},"=MIN(FIND({0,1,2,3,4,5,6,7,8,9},B3&\"0123456789\"))",null,"=FIND({0,1,2,3,4,5,6,7,8,9},B3&\"0123456789\")",{"$f":"FIND({0,1,2,3,4,5,6,7,8,9},B3&\"0123456789\")","v":7},8,9,10,6,12,13,14,15,5]
[null,"Marie98",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},B4&\"0123456789\"))","v":6},"=MIN(FIND({0,1,2,3,4,5,6,7,8,9},B4&\"0123456789\"))"]
[null,"Hurry",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\"))","v":6},"=MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\"))"]
[]
[null,null,"Text","Formula","Score ","Formula"]
[null,null,{"$f":"LEFT(B3,C3-1)","v":"Jack"},"=LEFT(B3,C3-1)",{"$f":"RIGHT(B3, LEN(B3)-C3+1)","v":"94"},"=RIGHT(B3, LEN(B3)-C3+1)"]
[null,null,{"$f":"LEFT(B4,C4-1)","v":"Marie"},"=LEFT(B4,C4-1)",{"$f":"RIGHT(B4, LEN(B4)-C4+1)","v":"98"},"=RIGHT(B4, LEN(B4)-C4+1)"]
[null,null,{"$f":"LEFT(B5,C5-1)","v":"Hurry"},"=LEFT(B5,E5-1)",{"$f":"RIGHT(B5, LEN(B5)-C5+1)","v":""}]

{"sheet":"Extract text 3","index":6,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Text","Letter","Digit","Other"]
["c1o2n3bina4\u000b\b\u000etion","conbination",1234,"\u000b\b\u000e"]
["1mor2n3ing","morning",123]
["Good904letter","Goodletter",904]

{"sheet":"Extract text 4","index":7,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Text"]
["Apple30Peach40Banana50pen 3","Apple",30,"Peach",40,"Banana",50,"pen ",3]
["Students Number30 Class 1hours12","Students Number",30," Class ",1,"hours",12]

{"sheet":"Extract text 5","index":8,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Text","Symbol","+"]
["Apple 30 + Banana 40 + Peach 50","Apple 30 "," Banana 40 "," Peach 50"]
["30 + 40 + 50",30,40,50]
["30+40+50",30,40,50]
["A+B+C","A","B","C"]
["A + B +C","A "," B ","C"]

{"sheet":"Concatenation","index":9,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Num","City",null,"Result","Formula"]
[1,"New York",null,{"$f":"CONCATENATE(\"If num = \" & $A2 & \" then city = '\" & B2 & \"';\")","v":"If num = 1 then city = 'New York';"},"=CONCATENATE(\"If num = \" & $A2 & \" then city = '\" & B2 & \"';\")"]
[2,"London",null,{"$f":"CONCATENATE(\"else If num = \" & $A3 & \" then city = '\" & B3 & \"';\")","v":"else If num = 2 then city = 'London';"},"=CONCATENATE(\"else If num = \" & $A3 & \" then city = '\" & B3 & \"';\")"]
[3,"Hongkong",null,{"$f":"CONCATENATE(\"else If num = \" & $A4 & \" then city = '\" & B4 & \"';\")","v":"else If num = 3 then city = 'Hongkong';"},"=CONCATENATE(\"else If num = \" & $A4 & \" then city = '\" & B4 & \"';\")"]
[4,"Toyoko",null,{"$f":"CONCATENATE(\"else If num = \" & $A5 & \" then city = '\" & B5 & \"';\")","v":"else If num = 4 then city = 'Toyoko';"},"=CONCATENATE(\"else If num = \" & $A5 & \" then city = '\" & B5 & \"';\")"]
[5,"Beijing",null,{"$f":"CONCATENATE(\"else If num = \" & $A6 & \" then city = '\" & B6 & \"';\")","v":"else If num = 5 then city = 'Beijing';"},"=CONCATENATE(\"else If num = \" & $A6 & \" then city = '\" & B6 & \"';\")"]