{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","CHAR Function","SUBSTITUE Function","LEFT Function","Combined Function","VBA","Practice"],"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":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"How to Autofill Sequential Letters in Excel"]
[]
[null,"Watchman's Name","Gate No"]
[null,"Anthony"]
[null,"Bryan"]
[null,"Cummins"]
[null,"Draxler"]
[null,"Elgar"]
[null,"Duminy"]
[null,"Philander"]
[null,"Strac"]
[null,"Hazelwood"]
[null,"Shaun"]

{"sheet":"CHAR Function","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"How to Autofill Sequential Letters in Excel"]
[]
[null,"Watchman's Name","Gate No"]
[null,"Anthony","A"]
[null,"Bryan",{"$f":"CHAR(CODE(C5)+1)","v":"B"}]
[null,"Cummins",{"$f":"CHAR(CODE(C6)+1)","v":"C"}]
[null,"Draxler",{"$f":"CHAR(CODE(C7)+1)","v":"D"}]
[null,"Elgar","E"]
[null,"Duminy","F"]
[null,"Philander","G"]
[null,"Strac","H"]
[null,"Hazelwood","I"]
[null,"Shaun","J"]

{"sheet":"SUBSTITUE Function","index":2,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"How to Autofill Sequential Letters in Excel"]
[]
[null,"Watchman's Name","Gate No"]
[null,"Anthony",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A1),4),1,\"\")","v":"A"}]
[null,"Bryan",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A2),4),1,\"\")","v":"B"}]
[null,"Cummins",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A3),4),1,\"\")","v":"C"}]
[null,"Draxler",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A4),4),1,\"\")","v":"D"}]
[null,"Elgar",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A5),4),1,\"\")","v":"E"}]
[null,"Duminy",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A6),4),1,\"\")","v":"F"}]
[null,"Philander",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A7),4),1,\"\")","v":"G"}]
[null,"Strac",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A8),4),1,\"\")","v":"H"}]
[null,"Hazelwood",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A9),4),1,\"\")","v":"I"}]
[null,"Shaun",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A10),4),1,\"\")","v":"J"}]
[null,"Eduardo",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A11),4),1,\"\")","v":"K"}]
[null,"Gonzalez",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A12),4),1,\"\")","v":"L"}]
[null,"Laura",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A13),4),1,\"\")","v":"M"}]
[null,"Elisa",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A14),4),1,\"\")","v":"N"}]
[null,"Perry",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A15),4),1,\"\")","v":"O"}]
[null,"Messi",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A16),4),1,\"\")","v":"P"}]
[null,"Ronaldo",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A17),4),1,\"\")","v":"Q"}]
[null,"Neymar",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A18),4),1,\"\")","v":"R"}]
[null,"Suarez",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A19),4),1,\"\")","v":"S"}]
[null,"Marnus",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A20),4),1,\"\")","v":"T"}]
[null,"Cafu",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A21),4),1,\"\")","v":"U"}]
[null,"Silva",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A22),4),1,\"\")","v":"V"}]
[null,"Bernardo",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A23),4),1,\"\")","v":"W"}]
[null,"Andres",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A24),4),1,\"\")","v":"X"}]
[null,"Sebastian",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A25),4),1,\"\")","v":"Y"}]
[null,"Haller",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A26),4),1,\"\")","v":"Z"}]
[null,"Rodrygo",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A27),4),1,\"\")","v":"AA"}]
[null,"Benzema",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A28),4),1,\"\")","v":"AB"}]
[null,"Lewandowski",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A29),4),1,\"\")","v":"AC"}]
[null,"Tadic",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A30),4),1,\"\")","v":"AD"}]
[null,"Tagliafico",{"$f":"SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A31),4),1,\"\")","v":"AE"}]

{"sheet":"LEFT Function","index":3,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"How to Autofill Sequential Letters in Excel"]
[]
[null,"Watchman's Name","Gate No"]
[null,"Anthony",{"$f":"LEFT(ADDRESS(1,ROW(A1),4,1),(ROW(A1)>26)+1)","v":"A"}]
[null,"Bryan",{"$f":"LEFT(ADDRESS(1,ROW(A2),4,1),(ROW(A2)>26)+1)","v":"B"}]
[null,"Cummins","C"]
[null,"Draxler","D"]
[null,"Elgar","E"]
[null,"Duminy","F"]
[null,"Philander","G"]
[null,"Strac","H"]
[null,"Hazelwood","I"]
[null,"Shaun","J"]
[null,"Eduardo","K"]
[null,"Gonzalez","L"]
[null,"Laura","M"]
[null,"Elisa","N"]
[null,"Perry","O"]
[null,"Messi","P"]
[null,"Ronaldo","Q"]
[null,"Neymar","R"]
[null,"Suarez","S"]
[null,"Marnus","T"]
[null,"Cafu","U"]
[null,"Silva","V"]
[null,"Bernardo","W"]
[null,"Andres","X"]
[null,"Sebastian","Y"]
[null,"Haller","Z"]
[null,"Rodrygo","AA"]
[null,"Benzema","AB"]
[null,"Lewandowski","AC"]
[null,"Tadic","AD"]
[null,"Tagliafico","AE"]

{"sheet":"Combined Function","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combined Function to AutoFill Sequential Letters"]
[]
[null,"Watchman's Name","Gate No"]
[null,"Anthony","AB"]
[null,"Bryan",{"$f":"IF(RIGHT($C5,1)=\"Z\", CHAR(CODE(LEFT(C5,1))+1),LEFT(C5,1))&CHAR(65+MOD(CODE(RIGHT(C5,1))+1-65,26))","v":"AC"}]
[null,"Cummins",{"$f":"IF(RIGHT($C6,1)=\"Z\", CHAR(CODE(LEFT(C6,1))+1),LEFT(C6,1))&CHAR(65+MOD(CODE(RIGHT(C6,1))+1-65,26))","v":"AD"}]
[null,"Draxler","AE"]
[null,"Elgar","AF"]
[null,"Duminy","AG"]
[null,"Philander","AH"]
[null,"Strac","AI"]
[null,"Hazelwood","AJ"]
[null,"Shaun","AK"]

{"sheet":"VBA","index":5,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[null,null,null,null,null,{"$f":"AutoFill(ROW())","v":"A"}]
[null,"How to Autofill Sequential Letters in Excel",null,null,null,{"$f":"AutoFill(ROW())","v":"B"}]
[null,null,null,null,null,"C"]
[null,"Watchman's Name","Gate No",null,null,"D"]
[null,"Anthony",{"$f":"AutoFill(ROW())","v":"E"},null,null,"E"]
[null,"Bryan",{"$f":"AutoFill(ROW())","v":"F"},null,null,"F"]
[null,"Cummins","G",null,null,"G"]
[null,"Draxler","H",null,null,"H"]
[null,"Elgar","I",null,null,"I"]
[null,"Duminy","J",null,null,"J"]
[null,"Philander","K",null,null,"K"]
[null,"Strac","L",null,null,"L"]
[null,"Hazelwood","M",null,null,"M"]
[null,"Shaun","N",null,null,"N"]
[null,"Eduardo","O"]
[null,"Gonzalez","P"]
[null,"Laura","Q"]
[null,"Elisa","R"]
[null,"Perry","S"]
[null,"Messi","T"]
[null,"Ronaldo","U"]
[null,"Neymar","V"]
[null,"Suarez","W"]
[null,"Marnus","X"]
[null,"Cafu","Y"]
[null,"Silva","Z"]
[null,"Bernardo","AA"]
[null,"Andres","AB"]
[null,"Sebastian","AC"]
[null,"Haller","AD"]
[null,"Rodrygo","AE"]
[null,"Benzema","AF"]
[null,"Lewandowski","AG"]
[null,"Tadic","AH"]
[null,"Tagliafico","AI"]

{"sheet":"Practice","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Do It Yourself"]
[]
[null,"Watchman's Name","Gate No"]
[null,"Anthony"]
[null,"Bryan"]
[null,"Cummins"]
[null,"Draxler"]
[null,"Elgar"]
[null,"Duminy"]
[null,"Philander"]
[null,"Strac"]
[null,"Hazelwood"]
[null,"Shaun"]