{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Column letter - Examples","Simple formula","Versatile formula ","Custom function","Column letter of cell","Dynamic formula"],"not_rendered":{"charts":0,"images":4,"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":"Column letter - Examples","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,5],[5,1,5,2],[11,1,11,2],[12,1,12,2],[14,1,14,2],[15,1,15,2]]}
[]
[]
[]
[null,"Sample Workbook to Convert Column Number to Letter "]
[]
[null,"The workbook shows how to change column number to alphabet using Excel formulas and a custom VBA function."]
[null,"Author","Ablebits.com"]
[null,"Last update","2022-02-17"]
[null,"Tutorial URL","How to convert Excel column number to letter"]
[]
[null,"Examples:"]
["• ","Change column number to alphabet (for A to Z)"]
["• ","Convert column number to letter (for any column) "]
["• ","Custom function to change column number to letter "]
["• ","Get column letter of specific cell "]
["• ","Create dynamic range reference from column number "]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Simple formula","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Number","Column letter"]
[1,{"$f":"CHAR(64+A2)","v":"A"}]
[2,{"$f":"CHAR(64+A3)","v":"B"}]
[3,"C"]
[5,"E"]
[10,"J"]
[20,"T"]

{"sheet":"Versatile formula ","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Number","Column letter"]
[1,{"$f":"SUBSTITUTE(ADDRESS(1, A2, 4), \"1\", \"\")","v":"A"}]
[10,{"$f":"SUBSTITUTE(ADDRESS(1, A3, 4), \"1\", \"\")","v":"J"}]
[100,"CV"]
[1000,"ALL"]
[10000,"NTP"]
[16384,"XFD"]

{"sheet":"Custom function","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Number","Column letter"]
[1,{"$f":"ColumnLetter(A2)","v":"A"}]
[10,{"$f":"ColumnLetter(A3)","v":"J"}]
[100,{"$f":"ColumnLetter(A4)","v":"CV"}]
[1000,{"$f":"ColumnLetter(A5)","v":"ALL"}]
[10000,{"$f":"ColumnLetter(A6)","v":"NTP"}]
[16384,{"$f":"ColumnLetter(A7)","v":"XFD"}]

{"sheet":"Column letter of cell","index":4,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Column letter of current cell"]
[{"$f":"SUBSTITUTE(ADDRESS(1, COLUMN(), 4), \"1\", \"\")","v":"A"}]
[]
["Column letter of cell C5"]
[{"$f":"SUBSTITUTE(ADDRESS(1, COLUMN(C5), 4), \"1\", \"\")","v":"C"}]

{"sheet":"Dynamic formula","index":5,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,1,4]]}
["Profit",null,null,null,"Project"]
["Week 1","Week 2","Week 3","Week 4",null,null,"Project","Cascade"]
[989,501,624,698,"Bigfoot",null,"Week",3]
[603,967,355,916,"Cascade",null,"Profit",{"$f":"_xlfn.XLOOKUP(H2, E3:E8, INDIRECT(SUBSTITUTE(ADDRESS(1, H3, 4), \"1\", \"\") & \"3:\" & SUBSTITUTE(ADDRESS(1, H3, 4), \"1\", \"\") &\"8\"), \"Not found\")","v":355}]
[563,570,172,748,"Hornets"]
[245,646,498,936,"Mercury"]
[321,620,518,119,"Peak"]
[302,560,833,792,"Skill-Up"]