{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["nr to letter","letter to number","nr to letter vba","letter to nr vba"],"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":"nr to letter","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Column number","Cell address","Column letter"]
[null,1,{"$f":"ADDRESS(1,B3,4)","v":"A1"},{"$f":"LEFT(ADDRESS(1,B3,4),MATCH(B3,{1;27;703}))","v":"A"}]
[null,26,"Z1",{"$f":"LEFT(ADDRESS(1,B4,4),MATCH(B4,{1;27;703}))","v":"Z"}]
[null,27,"AA1",{"$f":"LEFT(ADDRESS(1,B5,4),MATCH(B5,{1;27;703}))","v":"AA"}]
[null,702,"ZZ1",{"$f":"LEFT(ADDRESS(1,B6,4),MATCH(B6,{1;27;703}))","v":"ZZ"}]
[null,703,"AAA1",{"$f":"LEFT(ADDRESS(1,B7,4),MATCH(B7,{1;27;703}))","v":"AAA"}]
[null,10000,"NTP1",{"$f":"LEFT(ADDRESS(1,B8,4),MATCH(B8,{1;27;703}))","v":"NTP"}]
[null,16384,"XFD1",{"$f":"LEFT(ADDRESS(1,B9,4),MATCH(B9,{1;27;703}))","v":"XFD"}]

{"sheet":"letter to number","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Column letter","Column number","Column number","Column number"]
[null,"A",{"$f":"MATCH(B3&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":1},{"$f":"COLUMN(INDIRECT(B3&\"1\"))","v":1},{"$f":"MATCH(B3&\"1\",INDEX(ADDRESS(1,INDEX(COLUMN($1:$1),),4),),0)","v":1}]
[null,"VD",{"$f":"MATCH(B4&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":576},{"$f":"COLUMN(INDIRECT(B4&\"1\"))","v":576},{"$f":"MATCH(B4&\"1\",INDEX(ADDRESS(1,INDEX(COLUMN($1:$1),),4),),0)","v":576}]
[null,"CS",{"$f":"MATCH(B5&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":97},{"$f":"COLUMN(INDIRECT(B5&\"1\"))","v":97},{"$f":"MATCH(B5&\"1\",INDEX(ADDRESS(1,INDEX(COLUMN($1:$1),),4),),0)","v":97}]
[null,"SDF",{"$f":"MATCH(B6&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":12954},{"$f":"COLUMN(INDIRECT(B6&\"1\"))","v":12954},{"$f":"MATCH(B6&\"1\",INDEX(ADDRESS(1,INDEX(COLUMN($1:$1),),4),),0)","v":12954}]
[null,"G",{"$f":"MATCH(B7&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":7},{"$f":"COLUMN(INDIRECT(B7&\"1\"))","v":7},{"$f":"MATCH(B7&\"1\",INDEX(ADDRESS(1,INDEX(COLUMN($1:$1),),4),),0)","v":7}]
[null,"UYT",{"$f":"MATCH(B8&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":14866},{"$f":"COLUMN(INDIRECT(B8&\"1\"))","v":14866},{"$f":"MATCH(B8&\"1\",INDEX(ADDRESS(1,INDEX(COLUMN($1:$1),),4),),0)","v":14866}]
[null,"ETR",{"$f":"MATCH(B9&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":3918},{"$f":"COLUMN(INDIRECT(B9&\"1\"))","v":3918},{"$f":"MATCH(B9&\"1\",INDEX(ADDRESS(1,INDEX(COLUMN($1:$1),),4),),0)","v":3918}]

{"sheet":"nr to letter vba","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Column number","Column letter"]
[null,1,{"$f":"ColumnLetter(B3)","v":"A"}]
[null,26,{"$f":"ColumnLetter(B4)","v":"Z"}]
[null,27,"AA"]
[null,702,"ZZ"]
[null,703,"AAA"]
[null,10000,"NTP"]
[null,16384,"XFD"]

{"sheet":"letter to nr vba","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Column letter","Column number"]
[null,"A",{"$f":"ColumnNumber(B3)","v":1}]
[null,"Z",{"$f":"ColumnNumber(B4)","v":26}]
[null,"AA",27]
[null,"ZZ",702]
[null,"AAA",703]
[null,"NTP",10000]
[null,"XFD",16384]