{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Question","Try","MrExcel","excelisfun","1177","1177 (an)"],"not_rendered":{"charts":0,"images":1,"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":"Question","index":0,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["ThomasStewart"]
["BillJelen"]
["JonTessmer"]
["SusanHalloran"]
["AmyMcmaster"]
["TammyRossi"]
["RandolfCoffin"]
["FrankDoyle"]
["ToyaWhite"]
["StephanieLennon"]
["NicoleBialek"]
["CharlesUrsone"]
["ClaraHill"]
["JamesSantamour"]
["KacieCoffin"]
["LynnFarber"]
["AnjaKennedy"]
["TraceyCarroll"]
["AnnBowman"]
["HaroldDelacruz"]
["FredDotson"]
["SaraGlover"]
["EuniceThompson"]
["EllaDay"]
["GeraldBailey"]

{"sheet":"Try","index":1,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["ThomasStewart"]
["BillJelen"]
["JonTessmer"]
["SusanHalloran"]
["AmyMcmaster"]
["TammyRossi"]
["RandolfCoffin"]
["FrankDoyle"]
["ToyaWhite"]
["StephanieLennon"]
["NicoleBialek"]
["CharlesUrsone"]
["ClaraHill"]
["JamesSantamour"]
["KacieCoffin"]
["LynnFarber"]
["AnjaKennedy"]
["TraceyCarroll"]
["AnnBowman"]
["HaroldDelacruz"]
["FredDotson"]
["SaraGlover"]
["EuniceThompson"]
["EllaDay"]
["GeraldBailey"]

{"sheet":"MrExcel","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["ThomasStewart",{"$f":"findCap(A1,2)","v":7},{"$f":"LEFT(A1,B1-1)","v":"Thomas"},{"$f":"MID(A1,B1,50)","v":"Stewart"}]
["BillJelen",{"$f":"findCap(A2,2)","v":5},{"$f":"LEFT(A2,B2-1)","v":"Bill"},{"$f":"MID(A2,B2,50)","v":"Jelen"},"A",{"$f":"CODE(E2)","v":65}]
["JonTessmer",4,"Jon","Tessmer","Z",{"$f":"CODE(E3)","v":90}]
["SusanHalloran",6,"Susan","Halloran","a",{"$f":"CODE(E4)","v":97}]
["AmyMcmaster",4,"Amy","Mcmaster","z",{"$f":"CODE(E5)","v":122}]
["TammyRossi",6,"Tammy","Rossi"]
["RandolfCoffin",8,"Randolf","Coffin"]
["FrankDoyle",6,"Frank","Doyle"]
["ToyaWhite",5,"Toya","White"]
["StephanieLennon",10,"Stephanie","Lennon"]
["NicoleBialek",7,"Nicole","Bialek"]
["CharlesUrsone",8,"Charles","Ursone"]
["ClaraHill",6,"Clara","Hill"]
["JamesSantamour",6,"James","Santamour"]
["KacieCoffin",6,"Kacie","Coffin"]
["LynnFarber",5,"Lynn","Farber"]
["AnjaKennedy",5,"Anja","Kennedy"]
["TraceyCarroll",7,"Tracey","Carroll"]
["AnnBowman",4,"Ann","Bowman"]
["HaroldDelacruz",7,"Harold","Delacruz"]
["FredDotson",5,"Fred","Dotson"]
["SaraGlover",5,"Sara","Glover"]
["EuniceThompson",7,"Eunice","Thompson"]
["EllaDay",5,"Ella","Day"]
["GeraldBailey",7,"Gerald","Bailey"]

{"sheet":"excelisfun","index":3,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Names","Position Second Cap","First","Last",{"$f":"CHAR(64+ROW())","v":"A"},null,"Bill Szysz Formula",null,"Alternative",null,null,"Jorge Piris & Adeel Siddiqui"]
["ThomasStewart",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A2,LEN(A2)-1)))+1","v":7},{"$f":"LEFT(A2,B2-1)","v":"Thomas"},{"$f":"REPLACE(A2,1,B2-1,\"\")","v":"Stewart"},{"$f":"CHAR(64+ROW())","v":"B"},null,{"$f":"LEFT(A2,MATCH(1,IF(CODE(MID(A2,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A2,ROW($A$2:$A$100),1))),1),0))","v":"Thomas"},null,{"$f":"LEFT(A2,MATCH(TRUE,CODE(MID(A2,ROW(INDIRECT(\"2:\"&LEN(A2))),1))=CODE(UPPER(MID(A2,ROW(INDIRECT(\"2:\"&LEN(A2))),1))),0))","v":"Thomas"},{"$f":"SUBSTITUTE(A2,I2,\"\")","v":"Stewart"},null,"Flash Fill"]
["BillJelen",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A3,LEN(A3)-1)))+1","v":5},{"$f":"LEFT(A3,B3-1)","v":"Bill"},{"$f":"REPLACE(A3,1,B3-1,\"\")","v":"Jelen"},"C",null,{"$f":"LEFT(A3,MATCH(1,IF(CODE(MID(A3,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A3,ROW($A$2:$A$100),1))),1),0))","v":"Bill"},null,{"$f":"LEFT(A3,MATCH(TRUE,CODE(MID(A3,ROW(INDIRECT(\"2:\"&LEN(A3))),1))=CODE(UPPER(MID(A3,ROW(INDIRECT(\"2:\"&LEN(A3))),1))),0))","v":"Bill"},{"$f":"SUBSTITUTE(A3,I3,\"\")","v":"Jelen"}]
["JonTessmer",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A4,LEN(A4)-1)))+1","v":4},"Jon","Tessmer","D",null,{"$f":"LEFT(A4,MATCH(1,IF(CODE(MID(A4,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A4,ROW($A$2:$A$100),1))),1),0))","v":"Jon"},null,{"$f":"LEFT(A4,MATCH(TRUE,CODE(MID(A4,ROW(INDIRECT(\"2:\"&LEN(A4))),1))=CODE(UPPER(MID(A4,ROW(INDIRECT(\"2:\"&LEN(A4))),1))),0))","v":"Jon"},"Tessmer"]
["SusanHalloran",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A5,LEN(A5)-1)))+1","v":6},"Susan","Halloran","E",null,{"$f":"LEFT(A5,MATCH(1,IF(CODE(MID(A5,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A5,ROW($A$2:$A$100),1))),1),0))","v":"Susan"},null,{"$f":"LEFT(A5,MATCH(TRUE,CODE(MID(A5,ROW(INDIRECT(\"2:\"&LEN(A5))),1))=CODE(UPPER(MID(A5,ROW(INDIRECT(\"2:\"&LEN(A5))),1))),0))","v":"Susan"},"Halloran"]
["AmyMcmaster",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A6,LEN(A6)-1)))+1","v":4},"Amy","Mcmaster","F",null,{"$f":"LEFT(A6,MATCH(1,IF(CODE(MID(A6,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A6,ROW($A$2:$A$100),1))),1),0))","v":"Amy"},null,{"$f":"LEFT(A6,MATCH(TRUE,CODE(MID(A6,ROW(INDIRECT(\"2:\"&LEN(A6))),1))=CODE(UPPER(MID(A6,ROW(INDIRECT(\"2:\"&LEN(A6))),1))),0))","v":"Amy"},"Mcmaster"]
["TammyRossi",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A7,LEN(A7)-1)))+1","v":6},"Tammy","Rossi","G","number 2^15 = 32768. 32768 is one more",{"$f":"LEFT(A7,MATCH(1,IF(CODE(MID(A7,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A7,ROW($A$2:$A$100),1))),1),0))","v":"Tammy"},null,{"$f":"LEFT(A7,MATCH(TRUE,CODE(MID(A7,ROW(INDIRECT(\"2:\"&LEN(A7))),1))=CODE(UPPER(MID(A7,ROW(INDIRECT(\"2:\"&LEN(A7))),1))),0))","v":"Tammy"},"Rossi"]
["RandolfCoffin",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A8,LEN(A8)-1)))+1","v":8},"Randolf","Coffin","H","character than is allowed in a cell. 32767",{"$f":"LEFT(A8,MATCH(1,IF(CODE(MID(A8,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A8,ROW($A$2:$A$100),1))),1),0))","v":"Randolf"},null,{"$f":"LEFT(A8,MATCH(TRUE,CODE(MID(A8,ROW(INDIRECT(\"2:\"&LEN(A8))),1))=CODE(UPPER(MID(A8,ROW(INDIRECT(\"2:\"&LEN(A8))),1))),0))","v":"Randolf"},"Coffin"]
["FrankDoyle",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A9,LEN(A9)-1)))+1","v":6},"Frank","Doyle","I","characters are allowed in a cell. ",{"$f":"LEFT(A9,MATCH(1,IF(CODE(MID(A9,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A9,ROW($A$2:$A$100),1))),1),0))","v":"Frank"},null,{"$f":"LEFT(A9,MATCH(TRUE,CODE(MID(A9,ROW(INDIRECT(\"2:\"&LEN(A9))),1))=CODE(UPPER(MID(A9,ROW(INDIRECT(\"2:\"&LEN(A9))),1))),0))","v":"Frank"},"Doyle"]
["ToyaWhite",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A10,LEN(A10)-1)))+1","v":5},"Toya","White","J",null,{"$f":"LEFT(A10,MATCH(1,IF(CODE(MID(A10,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A10,ROW($A$2:$A$100),1))),1),0))","v":"Toya"},null,{"$f":"LEFT(A10,MATCH(TRUE,CODE(MID(A10,ROW(INDIRECT(\"2:\"&LEN(A10))),1))=CODE(UPPER(MID(A10,ROW(INDIRECT(\"2:\"&LEN(A10))),1))),0))","v":"Toya"},"White"]
["StephanieLennon",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A11,LEN(A11)-1)))+1","v":10},"Stephanie","Lennon","K",null,{"$f":"LEFT(A11,MATCH(1,IF(CODE(MID(A11,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A11,ROW($A$2:$A$100),1))),1),0))","v":"Stephanie"},null,{"$f":"LEFT(A11,MATCH(TRUE,CODE(MID(A11,ROW(INDIRECT(\"2:\"&LEN(A11))),1))=CODE(UPPER(MID(A11,ROW(INDIRECT(\"2:\"&LEN(A11))),1))),0))","v":"Stephanie"},"Lennon"]
["NicoleBialek",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A12,LEN(A12)-1)))+1","v":7},"Nicole","Bialek","L",null,{"$f":"LEFT(A12,MATCH(1,IF(CODE(MID(A12,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A12,ROW($A$2:$A$100),1))),1),0))","v":"Nicole"},null,{"$f":"LEFT(A12,MATCH(TRUE,CODE(MID(A12,ROW(INDIRECT(\"2:\"&LEN(A12))),1))=CODE(UPPER(MID(A12,ROW(INDIRECT(\"2:\"&LEN(A12))),1))),0))","v":"Nicole"},"Bialek"]
["CharlesUrsone",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A13,LEN(A13)-1)))+1","v":8},"Charles","Ursone","M",null,{"$f":"LEFT(A13,MATCH(1,IF(CODE(MID(A13,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A13,ROW($A$2:$A$100),1))),1),0))","v":"Charles"},null,{"$f":"LEFT(A13,MATCH(TRUE,CODE(MID(A13,ROW(INDIRECT(\"2:\"&LEN(A13))),1))=CODE(UPPER(MID(A13,ROW(INDIRECT(\"2:\"&LEN(A13))),1))),0))","v":"Charles"},"Ursone"]
["ClaraHill",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A14,LEN(A14)-1)))+1","v":6},"Clara","Hill","N",null,{"$f":"LEFT(A14,MATCH(1,IF(CODE(MID(A14,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A14,ROW($A$2:$A$100),1))),1),0))","v":"Clara"},null,{"$f":"LEFT(A14,MATCH(TRUE,CODE(MID(A14,ROW(INDIRECT(\"2:\"&LEN(A14))),1))=CODE(UPPER(MID(A14,ROW(INDIRECT(\"2:\"&LEN(A14))),1))),0))","v":"Clara"},"Hill"]
["JamesSantamour",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A15,LEN(A15)-1)))+1","v":6},"James","Santamour","O",null,{"$f":"LEFT(A15,MATCH(1,IF(CODE(MID(A15,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A15,ROW($A$2:$A$100),1))),1),0))","v":"James"},null,{"$f":"LEFT(A15,MATCH(TRUE,CODE(MID(A15,ROW(INDIRECT(\"2:\"&LEN(A15))),1))=CODE(UPPER(MID(A15,ROW(INDIRECT(\"2:\"&LEN(A15))),1))),0))","v":"James"},"Santamour"]
["KacieCoffin",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A16,LEN(A16)-1)))+1","v":6},"Kacie","Coffin","P",null,{"$f":"LEFT(A16,MATCH(1,IF(CODE(MID(A16,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A16,ROW($A$2:$A$100),1))),1),0))","v":"Kacie"},null,{"$f":"LEFT(A16,MATCH(TRUE,CODE(MID(A16,ROW(INDIRECT(\"2:\"&LEN(A16))),1))=CODE(UPPER(MID(A16,ROW(INDIRECT(\"2:\"&LEN(A16))),1))),0))","v":"Kacie"},"Coffin"]
["LynnFarber",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A17,LEN(A17)-1)))+1","v":5},"Lynn","Farber","Q",null,{"$f":"LEFT(A17,MATCH(1,IF(CODE(MID(A17,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A17,ROW($A$2:$A$100),1))),1),0))","v":"Lynn"},null,{"$f":"LEFT(A17,MATCH(TRUE,CODE(MID(A17,ROW(INDIRECT(\"2:\"&LEN(A17))),1))=CODE(UPPER(MID(A17,ROW(INDIRECT(\"2:\"&LEN(A17))),1))),0))","v":"Lynn"},"Farber"]
["AnjaKennedy",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A18,LEN(A18)-1)))+1","v":5},"Anja","Kennedy","R",null,{"$f":"LEFT(A18,MATCH(1,IF(CODE(MID(A18,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A18,ROW($A$2:$A$100),1))),1),0))","v":"Anja"},null,{"$f":"LEFT(A18,MATCH(TRUE,CODE(MID(A18,ROW(INDIRECT(\"2:\"&LEN(A18))),1))=CODE(UPPER(MID(A18,ROW(INDIRECT(\"2:\"&LEN(A18))),1))),0))","v":"Anja"},"Kennedy"]
["TraceyCarroll",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A19,LEN(A19)-1)))+1","v":7},"Tracey","Carroll","S",null,{"$f":"LEFT(A19,MATCH(1,IF(CODE(MID(A19,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A19,ROW($A$2:$A$100),1))),1),0))","v":"Tracey"},null,{"$f":"LEFT(A19,MATCH(TRUE,CODE(MID(A19,ROW(INDIRECT(\"2:\"&LEN(A19))),1))=CODE(UPPER(MID(A19,ROW(INDIRECT(\"2:\"&LEN(A19))),1))),0))","v":"Tracey"},"Carroll"]
["AnnBowman",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A20,LEN(A20)-1)))+1","v":4},"Ann","Bowman","T",null,{"$f":"LEFT(A20,MATCH(1,IF(CODE(MID(A20,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A20,ROW($A$2:$A$100),1))),1),0))","v":"Ann"},null,{"$f":"LEFT(A20,MATCH(TRUE,CODE(MID(A20,ROW(INDIRECT(\"2:\"&LEN(A20))),1))=CODE(UPPER(MID(A20,ROW(INDIRECT(\"2:\"&LEN(A20))),1))),0))","v":"Ann"},"Bowman"]
["HaroldDelacruz",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A21,LEN(A21)-1)))+1","v":7},"Harold","Delacruz","U",null,{"$f":"LEFT(A21,MATCH(1,IF(CODE(MID(A21,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A21,ROW($A$2:$A$100),1))),1),0))","v":"Harold"},null,{"$f":"LEFT(A21,MATCH(TRUE,CODE(MID(A21,ROW(INDIRECT(\"2:\"&LEN(A21))),1))=CODE(UPPER(MID(A21,ROW(INDIRECT(\"2:\"&LEN(A21))),1))),0))","v":"Harold"},"Delacruz"]
["FredDotson",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A22,LEN(A22)-1)))+1","v":5},"Fred","Dotson","V",null,{"$f":"LEFT(A22,MATCH(1,IF(CODE(MID(A22,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A22,ROW($A$2:$A$100),1))),1),0))","v":"Fred"},null,{"$f":"LEFT(A22,MATCH(TRUE,CODE(MID(A22,ROW(INDIRECT(\"2:\"&LEN(A22))),1))=CODE(UPPER(MID(A22,ROW(INDIRECT(\"2:\"&LEN(A22))),1))),0))","v":"Fred"},"Dotson"]
["SaraGlover",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A23,LEN(A23)-1)))+1","v":5},"Sara","Glover","W",null,{"$f":"LEFT(A23,MATCH(1,IF(CODE(MID(A23,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A23,ROW($A$2:$A$100),1))),1),0))","v":"Sara"},null,{"$f":"LEFT(A23,MATCH(TRUE,CODE(MID(A23,ROW(INDIRECT(\"2:\"&LEN(A23))),1))=CODE(UPPER(MID(A23,ROW(INDIRECT(\"2:\"&LEN(A23))),1))),0))","v":"Sara"},"Glover"]
["EuniceThompson",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A24,LEN(A24)-1)))+1","v":7},"Eunice","Thompson","X",null,{"$f":"LEFT(A24,MATCH(1,IF(CODE(MID(A24,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A24,ROW($A$2:$A$100),1))),1),0))","v":"Eunice"},null,{"$f":"LEFT(A24,MATCH(TRUE,CODE(MID(A24,ROW(INDIRECT(\"2:\"&LEN(A24))),1))=CODE(UPPER(MID(A24,ROW(INDIRECT(\"2:\"&LEN(A24))),1))),0))","v":"Eunice"},"Thompson"]
["EllaDay",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A25,LEN(A25)-1)))+1","v":5},"Ella","Day","Y",null,{"$f":"LEFT(A25,MATCH(1,IF(CODE(MID(A25,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A25,ROW($A$2:$A$100),1))),1),0))","v":"Ella"},null,{"$f":"LEFT(A25,MATCH(TRUE,CODE(MID(A25,ROW(INDIRECT(\"2:\"&LEN(A25))),1))=CODE(UPPER(MID(A25,ROW(INDIRECT(\"2:\"&LEN(A25))),1))),0))","v":"Ella"},"Day"]
["GeraldBailey",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A26,LEN(A26)-1)))+1","v":7},"Gerald","Bailey","Z",null,{"$f":"LEFT(A26,MATCH(1,IF(CODE(MID(A26,ROW($A$2:$A$100),1))=CODE(UPPER(MID(A26,ROW($A$2:$A$100),1))),1),0))","v":"Gerald"},null,{"$f":"LEFT(A26,MATCH(TRUE,CODE(MID(A26,ROW(INDIRECT(\"2:\"&LEN(A26))),1))=CODE(UPPER(MID(A26,ROW(INDIRECT(\"2:\"&LEN(A26))),1))),0))","v":"Gerald"},"Bailey"]

{"sheet":"1177","index":4,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Mr Excel & excelisfun Trick 171: Split First & Last Name Based on Second Capital Letter ",null,null,null,null,"Jorge Piris & Adeel Siddiqui"]
[]
["https://www.youtube.com/watch?v=9Sskc7cZzwk",null,null,null,null,"Flash Fill"]
[]
["Names","Position Second Cap","First","Last",null,"Names","First","Last",null,"Names","Bill Szysz Formula",null,null,null,null,"Bill Szysz Original Formula"]
["ThomasStewart",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A6,LEN(A6)-1)))+1","v":7},{"$f":"LEFT(A6,B6-1)","v":"Thomas"},{"$f":"REPLACE(A6,1,B6-1,\"\")","v":"Stewart"},null,"ThomasStewart",null,null,null,"ThomasStewart",null,null,null,null,null,{"$f":"LEFT(A6,MATCH(1,IF(CODE(MID(A6,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A6,ROW($A$3:$A$101),1))),1),0))","v":"Thoma"}]
["BillJelen",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A7,LEN(A7)-1)))+1","v":5},{"$f":"LEFT(A7,B7-1)","v":"Bill"},{"$f":"REPLACE(A7,1,B7-1,\"\")","v":"Jelen"},null,"BillJelen",null,null,null,"BillJelen",null,null,null,null,null,{"$f":"LEFT(A7,MATCH(1,IF(CODE(MID(A7,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A7,ROW($A$3:$A$101),1))),1),0))","v":"Bil"}]
["JonTessmer",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A8,LEN(A8)-1)))+1","v":4},"Jon","Tessmer",null,"JonTessmer",null,null,null,"JonTessmer",null,null,null,null,null,{"$f":"LEFT(A8,MATCH(1,IF(CODE(MID(A8,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A8,ROW($A$3:$A$101),1))),1),0))","v":"Jo"}]
["SusanHalloran",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A9,LEN(A9)-1)))+1","v":6},"Susan","Halloran",null,"SusanHalloran",null,null,null,"SusanHalloran",null,null,null,null,null,{"$f":"LEFT(A9,MATCH(1,IF(CODE(MID(A9,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A9,ROW($A$3:$A$101),1))),1),0))","v":"Susa"}]
["AmyMcmaster",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A10,LEN(A10)-1)))+1","v":4},"Amy","Mcmaster",null,"AmyMcmaster",null,null,null,"AmyMcmaster",null,null,null,null,null,{"$f":"LEFT(A10,MATCH(1,IF(CODE(MID(A10,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A10,ROW($A$3:$A$101),1))),1),0))","v":"Am"}]
["TammyRossi",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A11,LEN(A11)-1)))+1","v":6},"Tammy","Rossi",null,"TammyRossi",null,null,null,"TammyRossi",null,null,null,null,null,{"$f":"LEFT(A11,MATCH(1,IF(CODE(MID(A11,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A11,ROW($A$3:$A$101),1))),1),0))","v":"Tamm"}]
["RandolfCoffin",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A12,LEN(A12)-1)))+1","v":8},"Randolf","Coffin",null,"RandolfCoffin",null,null,null,"RandolfCoffin",null,null,null,null,null,{"$f":"LEFT(A12,MATCH(1,IF(CODE(MID(A12,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A12,ROW($A$3:$A$101),1))),1),0))","v":"Randol"}]
["FrankDoyle",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A13,LEN(A13)-1)))+1","v":6},"Frank","Doyle",null,"FrankDoyle",null,null,null,"FrankDoyle",null,null,null,null,null,{"$f":"LEFT(A13,MATCH(1,IF(CODE(MID(A13,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A13,ROW($A$3:$A$101),1))),1),0))","v":"Fran"}]
["ToyaWhite",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A14,LEN(A14)-1)))+1","v":5},"Toya","White",null,"ToyaWhite",null,null,null,"ToyaWhite",null,null,null,null,null,{"$f":"LEFT(A14,MATCH(1,IF(CODE(MID(A14,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A14,ROW($A$3:$A$101),1))),1),0))","v":"Toy"}]
["StephanieLennon",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A15,LEN(A15)-1)))+1","v":10},"Stephanie","Lennon",null,"StephanieLennon",null,null,null,"StephanieLennon",null,null,null,null,null,{"$f":"LEFT(A15,MATCH(1,IF(CODE(MID(A15,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A15,ROW($A$3:$A$101),1))),1),0))","v":"Stephani"}]
["NicoleBialek",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A16,LEN(A16)-1)))+1","v":7},"Nicole","Bialek",null,"NicoleBialek",null,null,null,"NicoleBialek",null,null,null,null,null,{"$f":"LEFT(A16,MATCH(1,IF(CODE(MID(A16,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A16,ROW($A$3:$A$101),1))),1),0))","v":"Nicol"}]
["CharlesUrsone",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A17,LEN(A17)-1)))+1","v":8},"Charles","Ursone",null,"CharlesUrsone",null,null,null,"CharlesUrsone",null,null,null,null,null,{"$f":"LEFT(A17,MATCH(1,IF(CODE(MID(A17,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A17,ROW($A$3:$A$101),1))),1),0))","v":"Charle"}]
["ClaraHill",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A18,LEN(A18)-1)))+1","v":6},"Clara","Hill",null,"ClaraHill",null,null,null,"ClaraHill",null,null,null,null,null,{"$f":"LEFT(A18,MATCH(1,IF(CODE(MID(A18,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A18,ROW($A$3:$A$101),1))),1),0))","v":"Clar"}]
["JamesSantamour",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A19,LEN(A19)-1)))+1","v":6},"James","Santamour",null,"JamesSantamour",null,null,null,"JamesSantamour",null,null,null,null,null,{"$f":"LEFT(A19,MATCH(1,IF(CODE(MID(A19,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A19,ROW($A$3:$A$101),1))),1),0))","v":"Jame"}]
["KacieCoffin",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A20,LEN(A20)-1)))+1","v":6},"Kacie","Coffin",null,"KacieCoffin",null,null,null,"KacieCoffin",null,null,null,null,null,{"$f":"LEFT(A20,MATCH(1,IF(CODE(MID(A20,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A20,ROW($A$3:$A$101),1))),1),0))","v":"Kaci"}]
["LynnFarber",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A21,LEN(A21)-1)))+1","v":5},"Lynn","Farber",null,"LynnFarber",null,null,null,"LynnFarber",null,null,null,null,null,{"$f":"LEFT(A21,MATCH(1,IF(CODE(MID(A21,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A21,ROW($A$3:$A$101),1))),1),0))","v":"Lyn"}]
["AnjaKennedy",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A22,LEN(A22)-1)))+1","v":5},"Anja","Kennedy",null,"AnjaKennedy",null,null,null,"AnjaKennedy",null,null,null,null,null,{"$f":"LEFT(A22,MATCH(1,IF(CODE(MID(A22,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A22,ROW($A$3:$A$101),1))),1),0))","v":"Anj"}]
["TraceyCarroll",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A23,LEN(A23)-1)))+1","v":7},"Tracey","Carroll",null,"TraceyCarroll",null,null,null,"TraceyCarroll",null,null,null,null,null,{"$f":"LEFT(A23,MATCH(1,IF(CODE(MID(A23,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A23,ROW($A$3:$A$101),1))),1),0))","v":"Trace"}]
["AnnBowman",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A24,LEN(A24)-1)))+1","v":4},"Ann","Bowman",null,"AnnBowman",null,null,null,"AnnBowman",null,null,null,null,null,{"$f":"LEFT(A24,MATCH(1,IF(CODE(MID(A24,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A24,ROW($A$3:$A$101),1))),1),0))","v":"An"}]
["HaroldDelacruz",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A25,LEN(A25)-1)))+1","v":7},"Harold","Delacruz",null,"HaroldDelacruz",null,null,null,"HaroldDelacruz",null,null,null,null,null,{"$f":"LEFT(A25,MATCH(1,IF(CODE(MID(A25,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A25,ROW($A$3:$A$101),1))),1),0))","v":"Harol"}]
["FredDotson",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A26,LEN(A26)-1)))+1","v":5},"Fred","Dotson",null,"FredDotson",null,null,null,"FredDotson",null,null,null,null,null,{"$f":"LEFT(A26,MATCH(1,IF(CODE(MID(A26,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A26,ROW($A$3:$A$101),1))),1),0))","v":"Fre"}]
["SaraGlover",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A27,LEN(A27)-1)))+1","v":5},"Sara","Glover",null,"SaraGlover",null,null,null,"SaraGlover",null,null,null,null,null,{"$f":"LEFT(A27,MATCH(1,IF(CODE(MID(A27,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A27,ROW($A$3:$A$101),1))),1),0))","v":"Sar"}]
["EuniceThompson",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A28,LEN(A28)-1)))+1","v":7},"Eunice","Thompson",null,"EuniceThompson",null,null,null,"EuniceThompson",null,null,null,null,null,{"$f":"LEFT(A28,MATCH(1,IF(CODE(MID(A28,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A28,ROW($A$3:$A$101),1))),1),0))","v":"Eunic"}]
["EllaDay",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A29,LEN(A29)-1)))+1","v":5},"Ella","Day",null,"EllaDay",null,null,null,"EllaDay",null,null,null,null,null,{"$f":"LEFT(A29,MATCH(1,IF(CODE(MID(A29,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A29,ROW($A$3:$A$101),1))),1),0))","v":"Ell"}]
["GeraldBailey",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A30,LEN(A30)-1)))+1","v":7},"Gerald","Bailey",null,"GeraldBailey",null,null,null,"GeraldBailey",null,null,null,null,null,{"$f":"LEFT(A30,MATCH(1,IF(CODE(MID(A30,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A30,ROW($A$3:$A$101),1))),1),0))","v":"Geral"}]

{"sheet":"1177 (an)","index":5,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Mr Excel & excelisfun Trick 171: Split First & Last Name Based on Second Capital Letter ",null,null,null,null,"Jorge Piris & Adeel Siddiqui"]
[]
["https://www.youtube.com/watch?v=9Sskc7cZzwk",null,null,null,null,"Flash Fill"]
[]
["Names","Position Second Cap","First","Last",null,"Names","First","Last",null,"Names","Bill Szysz Formula",null,null,null,null,"Bill Szysz Original Formula"]
["ThomasStewart",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A6,LEN(A6)-1)))+1","v":7},{"$f":"LEFT(A6,B6-1)","v":"Thomas"},{"$f":"REPLACE(A6,1,B6-1,\"\")","v":"Stewart"},null,"ThomasStewart","Thomas","Stewart",null,"ThomasStewart",{"$f":"LEFT(J6,MATCH(TRUE,CODE(MID(J6,ROW(INDIRECT(\"2:\"&LEN(J6))),1))=CODE(UPPER(MID(J6,ROW(INDIRECT(\"2:\"&LEN(J6))),1))),0))","v":"Thomas"},{"$f":"SUBSTITUTE(J6,K6,\"\")","v":"Stewart"},null,null,null,{"$f":"LEFT(A6,MATCH(1,IF(CODE(MID(A6,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A6,ROW($A$3:$A$101),1))),1),0))","v":"Thoma"}]
["BillJelen",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A7,LEN(A7)-1)))+1","v":5},{"$f":"LEFT(A7,B7-1)","v":"Bill"},{"$f":"REPLACE(A7,1,B7-1,\"\")","v":"Jelen"},null,"BillJelen","Bill","Jelen",null,"BillJelen",{"$f":"LEFT(J7,MATCH(TRUE,CODE(MID(J7,ROW(INDIRECT(\"2:\"&LEN(J7))),1))=CODE(UPPER(MID(J7,ROW(INDIRECT(\"2:\"&LEN(J7))),1))),0))","v":"Bill"},{"$f":"SUBSTITUTE(J7,K7,\"\")","v":"Jelen"},null,null,null,{"$f":"LEFT(A7,MATCH(1,IF(CODE(MID(A7,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A7,ROW($A$3:$A$101),1))),1),0))","v":"Bil"}]
["JonTessmer",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A8,LEN(A8)-1)))+1","v":4},"Jon","Tessmer",null,"JonTessmer","Jon","Tessmer",null,"JonTessmer",{"$f":"LEFT(J8,MATCH(TRUE,CODE(MID(J8,ROW(INDIRECT(\"2:\"&LEN(J8))),1))=CODE(UPPER(MID(J8,ROW(INDIRECT(\"2:\"&LEN(J8))),1))),0))","v":"Jon"},"Tessmer",null,null,null,{"$f":"LEFT(A8,MATCH(1,IF(CODE(MID(A8,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A8,ROW($A$3:$A$101),1))),1),0))","v":"Jo"}]
["SusanHalloran",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A9,LEN(A9)-1)))+1","v":6},"Susan","Halloran",null,"SusanHalloran","Susan","Halloran",null,"SusanHalloran",{"$f":"LEFT(J9,MATCH(TRUE,CODE(MID(J9,ROW(INDIRECT(\"2:\"&LEN(J9))),1))=CODE(UPPER(MID(J9,ROW(INDIRECT(\"2:\"&LEN(J9))),1))),0))","v":"Susan"},"Halloran",null,null,null,{"$f":"LEFT(A9,MATCH(1,IF(CODE(MID(A9,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A9,ROW($A$3:$A$101),1))),1),0))","v":"Susa"}]
["AmyMcmaster",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A10,LEN(A10)-1)))+1","v":4},"Amy","Mcmaster",null,"AmyMcmaster","Amy","Mcmaster",null,"AmyMcmaster",{"$f":"LEFT(J10,MATCH(TRUE,CODE(MID(J10,ROW(INDIRECT(\"2:\"&LEN(J10))),1))=CODE(UPPER(MID(J10,ROW(INDIRECT(\"2:\"&LEN(J10))),1))),0))","v":"Amy"},"Mcmaster",null,null,null,{"$f":"LEFT(A10,MATCH(1,IF(CODE(MID(A10,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A10,ROW($A$3:$A$101),1))),1),0))","v":"Am"}]
["TammyRossi",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A11,LEN(A11)-1)))+1","v":6},"Tammy","Rossi",null,"TammyRossi","Tammy","Rossi",null,"TammyRossi",{"$f":"LEFT(J11,MATCH(TRUE,CODE(MID(J11,ROW(INDIRECT(\"2:\"&LEN(J11))),1))=CODE(UPPER(MID(J11,ROW(INDIRECT(\"2:\"&LEN(J11))),1))),0))","v":"Tammy"},"Rossi",null,null,null,{"$f":"LEFT(A11,MATCH(1,IF(CODE(MID(A11,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A11,ROW($A$3:$A$101),1))),1),0))","v":"Tamm"}]
["RandolfCoffin",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A12,LEN(A12)-1)))+1","v":8},"Randolf","Coffin",null,"RandolfCoffin","Randolf","Coffin",null,"RandolfCoffin",{"$f":"LEFT(J12,MATCH(TRUE,CODE(MID(J12,ROW(INDIRECT(\"2:\"&LEN(J12))),1))=CODE(UPPER(MID(J12,ROW(INDIRECT(\"2:\"&LEN(J12))),1))),0))","v":"Randolf"},"Coffin",null,null,null,{"$f":"LEFT(A12,MATCH(1,IF(CODE(MID(A12,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A12,ROW($A$3:$A$101),1))),1),0))","v":"Randol"}]
["FrankDoyle",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A13,LEN(A13)-1)))+1","v":6},"Frank","Doyle",null,"FrankDoyle","Frank","Doyle",null,"FrankDoyle",{"$f":"LEFT(J13,MATCH(TRUE,CODE(MID(J13,ROW(INDIRECT(\"2:\"&LEN(J13))),1))=CODE(UPPER(MID(J13,ROW(INDIRECT(\"2:\"&LEN(J13))),1))),0))","v":"Frank"},"Doyle",null,null,null,{"$f":"LEFT(A13,MATCH(1,IF(CODE(MID(A13,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A13,ROW($A$3:$A$101),1))),1),0))","v":"Fran"}]
["ToyaWhite",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A14,LEN(A14)-1)))+1","v":5},"Toya","White",null,"ToyaWhite","Toya","White",null,"ToyaWhite",{"$f":"LEFT(J14,MATCH(TRUE,CODE(MID(J14,ROW(INDIRECT(\"2:\"&LEN(J14))),1))=CODE(UPPER(MID(J14,ROW(INDIRECT(\"2:\"&LEN(J14))),1))),0))","v":"Toya"},"White",null,null,null,{"$f":"LEFT(A14,MATCH(1,IF(CODE(MID(A14,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A14,ROW($A$3:$A$101),1))),1),0))","v":"Toy"}]
["StephanieLennon",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A15,LEN(A15)-1)))+1","v":10},"Stephanie","Lennon",null,"StephanieLennon","Stephanie","Lennon",null,"StephanieLennon",{"$f":"LEFT(J15,MATCH(TRUE,CODE(MID(J15,ROW(INDIRECT(\"2:\"&LEN(J15))),1))=CODE(UPPER(MID(J15,ROW(INDIRECT(\"2:\"&LEN(J15))),1))),0))","v":"Stephanie"},"Lennon",null,null,null,{"$f":"LEFT(A15,MATCH(1,IF(CODE(MID(A15,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A15,ROW($A$3:$A$101),1))),1),0))","v":"Stephani"}]
["NicoleBialek",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A16,LEN(A16)-1)))+1","v":7},"Nicole","Bialek",null,"NicoleBialek","Nicole","Bialek",null,"NicoleBialek",{"$f":"LEFT(J16,MATCH(TRUE,CODE(MID(J16,ROW(INDIRECT(\"2:\"&LEN(J16))),1))=CODE(UPPER(MID(J16,ROW(INDIRECT(\"2:\"&LEN(J16))),1))),0))","v":"Nicole"},"Bialek",null,null,null,{"$f":"LEFT(A16,MATCH(1,IF(CODE(MID(A16,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A16,ROW($A$3:$A$101),1))),1),0))","v":"Nicol"}]
["CharlesUrsone",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A17,LEN(A17)-1)))+1","v":8},"Charles","Ursone",null,"CharlesUrsone","Charles","Ursone",null,"CharlesUrsone",{"$f":"LEFT(J17,MATCH(TRUE,CODE(MID(J17,ROW(INDIRECT(\"2:\"&LEN(J17))),1))=CODE(UPPER(MID(J17,ROW(INDIRECT(\"2:\"&LEN(J17))),1))),0))","v":"Charles"},"Ursone",null,null,null,{"$f":"LEFT(A17,MATCH(1,IF(CODE(MID(A17,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A17,ROW($A$3:$A$101),1))),1),0))","v":"Charle"}]
["ClaraHill",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A18,LEN(A18)-1)))+1","v":6},"Clara","Hill",null,"ClaraHill","Clara","Hill",null,"ClaraHill",{"$f":"LEFT(J18,MATCH(TRUE,CODE(MID(J18,ROW(INDIRECT(\"2:\"&LEN(J18))),1))=CODE(UPPER(MID(J18,ROW(INDIRECT(\"2:\"&LEN(J18))),1))),0))","v":"Clara"},"Hill",null,null,null,{"$f":"LEFT(A18,MATCH(1,IF(CODE(MID(A18,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A18,ROW($A$3:$A$101),1))),1),0))","v":"Clar"}]
["JamesSantamour",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A19,LEN(A19)-1)))+1","v":6},"James","Santamour",null,"JamesSantamour","James","Santamour",null,"JamesSantamour",{"$f":"LEFT(J19,MATCH(TRUE,CODE(MID(J19,ROW(INDIRECT(\"2:\"&LEN(J19))),1))=CODE(UPPER(MID(J19,ROW(INDIRECT(\"2:\"&LEN(J19))),1))),0))","v":"James"},"Santamour",null,null,null,{"$f":"LEFT(A19,MATCH(1,IF(CODE(MID(A19,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A19,ROW($A$3:$A$101),1))),1),0))","v":"Jame"}]
["KacieCoffin",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A20,LEN(A20)-1)))+1","v":6},"Kacie","Coffin",null,"KacieCoffin","Kacie","Coffin",null,"KacieCoffin",{"$f":"LEFT(J20,MATCH(TRUE,CODE(MID(J20,ROW(INDIRECT(\"2:\"&LEN(J20))),1))=CODE(UPPER(MID(J20,ROW(INDIRECT(\"2:\"&LEN(J20))),1))),0))","v":"Kacie"},"Coffin",null,null,null,{"$f":"LEFT(A20,MATCH(1,IF(CODE(MID(A20,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A20,ROW($A$3:$A$101),1))),1),0))","v":"Kaci"}]
["LynnFarber",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A21,LEN(A21)-1)))+1","v":5},"Lynn","Farber",null,"LynnFarber","Lynn","Farber",null,"LynnFarber",{"$f":"LEFT(J21,MATCH(TRUE,CODE(MID(J21,ROW(INDIRECT(\"2:\"&LEN(J21))),1))=CODE(UPPER(MID(J21,ROW(INDIRECT(\"2:\"&LEN(J21))),1))),0))","v":"Lynn"},"Farber",null,null,null,{"$f":"LEFT(A21,MATCH(1,IF(CODE(MID(A21,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A21,ROW($A$3:$A$101),1))),1),0))","v":"Lyn"}]
["AnjaKennedy",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A22,LEN(A22)-1)))+1","v":5},"Anja","Kennedy",null,"AnjaKennedy","Anja","Kennedy",null,"AnjaKennedy",{"$f":"LEFT(J22,MATCH(TRUE,CODE(MID(J22,ROW(INDIRECT(\"2:\"&LEN(J22))),1))=CODE(UPPER(MID(J22,ROW(INDIRECT(\"2:\"&LEN(J22))),1))),0))","v":"Anja"},"Kennedy",null,null,null,{"$f":"LEFT(A22,MATCH(1,IF(CODE(MID(A22,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A22,ROW($A$3:$A$101),1))),1),0))","v":"Anj"}]
["TraceyCarroll",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A23,LEN(A23)-1)))+1","v":7},"Tracey","Carroll",null,"TraceyCarroll","Tracey","Carroll",null,"TraceyCarroll",{"$f":"LEFT(J23,MATCH(TRUE,CODE(MID(J23,ROW(INDIRECT(\"2:\"&LEN(J23))),1))=CODE(UPPER(MID(J23,ROW(INDIRECT(\"2:\"&LEN(J23))),1))),0))","v":"Tracey"},"Carroll",null,null,null,{"$f":"LEFT(A23,MATCH(1,IF(CODE(MID(A23,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A23,ROW($A$3:$A$101),1))),1),0))","v":"Trace"}]
["AnnBowman",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A24,LEN(A24)-1)))+1","v":4},"Ann","Bowman",null,"AnnBowman","Ann","Bowman",null,"AnnBowman",{"$f":"LEFT(J24,MATCH(TRUE,CODE(MID(J24,ROW(INDIRECT(\"2:\"&LEN(J24))),1))=CODE(UPPER(MID(J24,ROW(INDIRECT(\"2:\"&LEN(J24))),1))),0))","v":"Ann"},"Bowman",null,null,null,{"$f":"LEFT(A24,MATCH(1,IF(CODE(MID(A24,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A24,ROW($A$3:$A$101),1))),1),0))","v":"An"}]
["HaroldDelacruz",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A25,LEN(A25)-1)))+1","v":7},"Harold","Delacruz",null,"HaroldDelacruz","Harold","Delacruz",null,"HaroldDelacruz",{"$f":"LEFT(J25,MATCH(TRUE,CODE(MID(J25,ROW(INDIRECT(\"2:\"&LEN(J25))),1))=CODE(UPPER(MID(J25,ROW(INDIRECT(\"2:\"&LEN(J25))),1))),0))","v":"Harold"},"Delacruz",null,null,null,{"$f":"LEFT(A25,MATCH(1,IF(CODE(MID(A25,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A25,ROW($A$3:$A$101),1))),1),0))","v":"Harol"}]
["FredDotson",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A26,LEN(A26)-1)))+1","v":5},"Fred","Dotson",null,"FredDotson","Fred","Dotson",null,"FredDotson",{"$f":"LEFT(J26,MATCH(TRUE,CODE(MID(J26,ROW(INDIRECT(\"2:\"&LEN(J26))),1))=CODE(UPPER(MID(J26,ROW(INDIRECT(\"2:\"&LEN(J26))),1))),0))","v":"Fred"},"Dotson",null,null,null,{"$f":"LEFT(A26,MATCH(1,IF(CODE(MID(A26,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A26,ROW($A$3:$A$101),1))),1),0))","v":"Fre"}]
["SaraGlover",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A27,LEN(A27)-1)))+1","v":5},"Sara","Glover",null,"SaraGlover","Sara","Glover",null,"SaraGlover",{"$f":"LEFT(J27,MATCH(TRUE,CODE(MID(J27,ROW(INDIRECT(\"2:\"&LEN(J27))),1))=CODE(UPPER(MID(J27,ROW(INDIRECT(\"2:\"&LEN(J27))),1))),0))","v":"Sara"},"Glover",null,null,null,{"$f":"LEFT(A27,MATCH(1,IF(CODE(MID(A27,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A27,ROW($A$3:$A$101),1))),1),0))","v":"Sar"}]
["EuniceThompson",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A28,LEN(A28)-1)))+1","v":7},"Eunice","Thompson",null,"EuniceThompson","Eunice","Thompson",null,"EuniceThompson",{"$f":"LEFT(J28,MATCH(TRUE,CODE(MID(J28,ROW(INDIRECT(\"2:\"&LEN(J28))),1))=CODE(UPPER(MID(J28,ROW(INDIRECT(\"2:\"&LEN(J28))),1))),0))","v":"Eunice"},"Thompson",null,null,null,{"$f":"LEFT(A28,MATCH(1,IF(CODE(MID(A28,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A28,ROW($A$3:$A$101),1))),1),0))","v":"Eunic"}]
["EllaDay",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A29,LEN(A29)-1)))+1","v":5},"Ella","Day",null,"EllaDay","Ella","Day",null,"EllaDay",{"$f":"LEFT(J29,MATCH(TRUE,CODE(MID(J29,ROW(INDIRECT(\"2:\"&LEN(J29))),1))=CODE(UPPER(MID(J29,ROW(INDIRECT(\"2:\"&LEN(J29))),1))),0))","v":"Ella"},"Day",null,null,null,{"$f":"LEFT(A29,MATCH(1,IF(CODE(MID(A29,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A29,ROW($A$3:$A$101),1))),1),0))","v":"Ell"}]
["GeraldBailey",{"$f":"LOOKUP(2^15,FIND({\"A\";\"B\";\"C\";\"D\";\"E\";\"F\";\"G\";\"H\";\"I\";\"J\";\"K\";\"L\";\"M\";\"N\";\"O\";\"P\";\"Q\";\"R\";\"S\";\"T\";\"U\";\"V\";\"W\";\"X\";\"Y\";\"Z\"},RIGHT(A30,LEN(A30)-1)))+1","v":7},"Gerald","Bailey",null,"GeraldBailey","Gerald","Bailey",null,"GeraldBailey",{"$f":"LEFT(J30,MATCH(TRUE,CODE(MID(J30,ROW(INDIRECT(\"2:\"&LEN(J30))),1))=CODE(UPPER(MID(J30,ROW(INDIRECT(\"2:\"&LEN(J30))),1))),0))","v":"Gerald"},"Bailey",null,null,null,{"$f":"LEFT(A30,MATCH(1,IF(CODE(MID(A30,ROW($A$3:$A$101),1))=CODE(UPPER(MID(A30,ROW($A$3:$A$101),1))),1),0))","v":"Geral"}]