{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Military Alphabet Code (My Fav)","Links & Feedback","Military Alphabet Code (v2)","Military Alphabet Code (v3)","Pros and Cons"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":"Military Alphabet Code (My Fav)","index":0,"n_rows":28,"n_cols":22,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Letter","Code word",null,"Word","Whiskey, Oscar, Romeo, Delta",null,"Kevin's Formula Solutionv1",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["A","Alfa",null,"sumit","Sierra, Uniform, Mike, India, Tango",null,{"$f":"H2&I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2&S2&T2&U2&V2","v":"Sierra, Uniform, Mike, India, Tango, "},{"$f":"IFERROR(OFFSET($B$1,MATCH(MID($D2,H$1,1),$A$2:$A$27,0),0)&\", \",\"\")","v":"Sierra, "},"Uniform, ","Mike, ","India, ","Tango, ","","","","","","","","","",""]
["B","Bravo",null,"bansal","Bravo, Alfa, November, Sierra, Alfa, Lima",null,"Bravo, Alfa, November, Sierra, Alfa, Lima, ","Bravo, ","Alfa, ","November, ","Sierra, ","Alfa, ","Lima, ","","","","","","","","",""]
["C","Charlie",null,"excel","Echo, X-ray, Charlie, Echo, Lima",null,"Echo, X-ray, Charlie, Echo, Lima, ","Echo, ","X-ray, ","Charlie, ","Echo, ","Lima, ","","","","","","","","","",""]
["D","Delta",null,"Database","Delta, Alfa, Tango, Alfa, Bravo, Alfa, Sierra, Echo",null,"Delta, Alfa, Tango, Alfa, Bravo, Alfa, Sierra, Echo, ","Delta, ","Alfa, ","Tango, ","Alfa, ","Bravo, ","Alfa, ","Sierra, ","Echo, ","","","","","","",""]
["E","Echo",null,"Pivot Table","Papa, India, Victor, Oscar, Tango,  , Tango, Alfa, Bravo, Lima, Echo",null,{"$f":"H6&I6&J6&K6&L6&M6&N6&O6&P6&Q6&R6&S6&T6&U6&V6","v":"Papa, India, Victor, Oscar, Tango, Tango, Alfa, Bravo, Lima, Echo, "},{"$f":"IFERROR(OFFSET($B$1,MATCH(MID($D6,H$1,1),$A$2:$A$27,0),0)&\", \",\"\")","v":"Papa, "},"India, ","Victor, ","Oscar, ","Tango, ","","Tango, ","Alfa, ","Bravo, ","Lima, ","Echo, ","","","",""]
["F","Foxtrot",null,"Kevin","Kilo, Echo, Victor, India, November",null,{"$f":"H7&I7&J7&K7&L7&M7&N7&O7&P7&Q7&R7&S7&T7&U7&V7","v":"Kilo, Echo, Victor, India, November, "},{"$f":"IFERROR(OFFSET($B$1,MATCH(MID($D7,H$1,1),$A$2:$A$27,0),0)&\", \",\"\")","v":"Kilo, "},"Echo, ","Victor, ","India, ","November, ","","","","","","","","","",""]
["G","Golf",null,"Formula","Foxtrot, Oscar, Romeo, Mike, Uniform, Lima, Alfa",null,"Foxtrot, Oscar, Romeo, Mike, Uniform, Lima, Alfa, ","Foxtrot, ","Oscar, ","Romeo, ","Mike, ","Uniform, ","Lima, ","Alfa, ","","","","","","","",""]
["H","Hotel",null,"or","Oscar, Romeo",null,"Oscar, Romeo, ","Oscar, ","Romeo, ","","","","","","","","","","","","",""]
["I","India",null,"VBA","Victor, Bravo, Alfa",null,"Victor, Bravo, Alfa, ","Victor, ","Bravo, ","Alfa, ","","","","","","","","","","","",""]
["J","Juliett",null,null,null,null,{"$f":"H11&I11&J11&K11&L11&M11&N11&O11&P11&Q11&R11&S11&T11&U11&V11","v":""},"","","","","","","","","","","","","","",""]
["K","Kilo"]
["L","Lima"]
["M","Mike"]
["N","November"]
["O","Oscar"]
["P","Papa"]
["Q","Quebec"]
["R","Romeo",null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G2)","v":"=H2&I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2&S2&T2&U2&V2"},{"$f":"_xlfn.FORMULATEXT(H2)","v":"=IFERROR(OFFSET($B$1,MATCH(MID($D2,H$1,1),$A$2:$A$27,0),0)&\", \",\"\")"}]
["S","Sierra",null,null,null,null,"Concatenate all the words together","a)Use MID function take out one letter at a time (numbers in row 1= 1st, 2nd, 3rd, etc.)"]
["T","Tango",null,null,null,null,"The last comma is there but can be removed (see v2)","b)Use MATCH function to find the position of letter in range A2:A27"]
["U","Uniform",null,null,null,null,null,"c)Use OFFSET function to get 'Code word' from column B"]
["V","Victor",null,null,null,null,null,"d)IFERROR function puts a blank instead of possible error"]
["W","Whiskey"]
["X","X-ray"]
["Y","Yankee"]
["Z","Zulu",null,null,null,"Note: my formula solutions are only dragged down to row 11 to make room for comments."]
[null,null,null,null,null,"To see Sumit's VBA code: 1)Right click on sheet name, 2)'View Code'"]

{"sheet":"Links & Feedback","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[22,3,22,8],[25,3,25,8],[18,3,18,13],[19,3,19,8],[20,3,20,8],[21,3,21,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"COURSES FROM TRUMPEXCEL"]
[]
[null,null,null,"'Excel Course (Basic to Advanced)  by Sumit Bansal"]
[null,null,null,"'Excel Dashboard Course  by Sumit Bansal"]
[null,null,null,"'Excel VBA Jetpack Course  by Sumit Bansal"]
[]
[]
[null,null,null,"Click here to see my Excel files",null,null,null,null,null,"<---My free Excel files on Onedrive"]

{"sheet":"Military Alphabet Code (v2)","index":2,"n_rows":28,"n_cols":23,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Letter","Code word",null,"Word","Whiskey, Oscar, Romeo, Delta",null,"Kevin's Formula Solutionv2","Len",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["A","Alfa",null,"sumit","Sierra, Uniform, Mike, India, Tango",null,{"$f":"IF(H2=0,\"\",LEFT(I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2&S2&T2&U2&V2&W2,H2-2))","v":"Sierra, Uniform, Mike, India, Tango"},{"$f":"SUM(LEN(I2:W2))","v":37},{"$f":"IFERROR(OFFSET($B$1,MATCH(MID($D2,I$1,1),$A$2:$A$27,0),0)&\", \",\"\")","v":"Sierra, "},"Uniform, ","Mike, ","India, ","Tango, ","","","","","","","","","",""]
["B","Bravo",null,"bansal","Bravo, Alfa, November, Sierra, Alfa, Lima",null,{"$f":"IF(H3=0,\"\",LEFT(I3&J3&K3&L3&M3&N3&O3&P3&Q3&R3&S3&T3&U3&V3&W3,H3-2))","v":"Bravo, Alfa, November, Sierra, Alfa, Lima"},{"$f":"SUM(LEN(I3:W3))","v":43},"Bravo, ","Alfa, ","November, ","Sierra, ","Alfa, ","Lima, ","","","","","","","","",""]
["C","Charlie",null,"excel","Echo, X-ray, Charlie, Echo, Lima",null,"Echo, X-ray, Charlie, Echo, Lima",{"$f":"SUM(LEN(I4:W4))","v":34},"Echo, ","X-ray, ","Charlie, ","Echo, ","Lima, ","","","","","","","","","",""]
["D","Delta",null,"Database","Delta, Alfa, Tango, Alfa, Bravo, Alfa, Sierra, Echo",null,"Delta, Alfa, Tango, Alfa, Bravo, Alfa, Sierra, Echo",{"$f":"SUM(LEN(I5:W5))","v":53},"Delta, ","Alfa, ","Tango, ","Alfa, ","Bravo, ","Alfa, ","Sierra, ","Echo, ","","","","","","",""]
["E","Echo",null,"Pivot Table","Papa, India, Victor, Oscar, Tango,  , Tango, Alfa, Bravo, Lima, Echo",null,"Papa, India, Victor, Oscar, Tango, Tango, Alfa, Bravo, Lima, Echo",{"$f":"SUM(LEN(I6:W6))","v":67},{"$f":"IFERROR(OFFSET($B$1,MATCH(MID($D6,I$1,1),$A$2:$A$27,0),0)&\", \",\"\")","v":"Papa, "},"India, ","Victor, ","Oscar, ","Tango, ","","Tango, ","Alfa, ","Bravo, ","Lima, ","Echo, ","","","",""]
["F","Foxtrot",null,"Kevin","Kilo, Echo, Victor, India, November",null,"Kilo, Echo, Victor, India, November",{"$f":"SUM(LEN(I7:W7))","v":37},{"$f":"IFERROR(OFFSET($B$1,MATCH(MID($D7,I$1,1),$A$2:$A$27,0),0)&\", \",\"\")","v":"Kilo, "},"Echo, ","Victor, ","India, ","November, ","","","","","","","","","",""]
["G","Golf",null,"Formula","Foxtrot, Oscar, Romeo, Mike, Uniform, Lima, Alfa",null,"Foxtrot, Oscar, Romeo, Mike, Uniform, Lima, Alfa",{"$f":"SUM(LEN(I8:W8))","v":50},"Foxtrot, ","Oscar, ","Romeo, ","Mike, ","Uniform, ","Lima, ","Alfa, ","","","","","","","",""]
["H","Hotel",null,"or","Oscar, Romeo",null,"Oscar, Romeo",{"$f":"SUM(LEN(I9:W9))","v":14},"Oscar, ","Romeo, ","","","","","","","","","","","","",""]
["I","India",null,"VBA","Victor, Bravo, Alfa",null,"Victor, Bravo, Alfa",{"$f":"SUM(LEN(I10:W10))","v":21},"Victor, ","Bravo, ","Alfa, ","","","","","","","","","","","",""]
["J","Juliett",null,null,null,null,"",{"$f":"SUM(LEN(I11:W11))","v":0},"","","","","","","","","","","","","","",""]
["K","Kilo"]
["L","Lima"]
["M","Mike"]
["N","November"]
["O","Oscar"]
["P","Papa"]
["Q","Quebec"]
["R","Romeo",null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G2)","v":"=IF(H2=0,\"\",LEFT(I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2&S2&T2&U2&V2&W2,H2-2))"},{"$f":"_xlfn.FORMULATEXT(H2)","v":"{=SUM(LEN(I2:W2))}"},null,null,null,{"$f":"_xlfn.FORMULATEXT(I2)","v":"=IFERROR(OFFSET($B$1,MATCH(MID($D2,I$1,1),$A$2:$A$27,0),0)&\", \",\"\")"}]
["S","Sierra",null,null,null,null,"a)Concatenate all the words together using &","a)Length of Code Words",null,null,null,"a)Use MID function take out one letter at a time (numbers in row 1= 1st, 2nd, 3rd, etc.)"]
["T","Tango",null,null,null,null,"b)LEFT uses column H number to remove last , (comma)",null,null,null,null,"b)Use MATCH function to find the position of letter in range A2:A27"]
["U","Uniform",null,null,null,null,null,null,null,null,null,"c)Use OFFSET function to get 'Code word' from column B"]
["V","Victor",null,null,null,null,null,null,null,null,null,"d)IFERROR function puts a blank instead of possible error"]
["W","Whiskey"]
["X","X-ray"]
["Y","Yankee"]
["Z","Zulu",null,null,null,"Note: my formula solutions are only dragged down to row 11 to make room for comments."]
[null,null,null,null,null,"To see Sumit's VBA code: 1)Right click on sheet name, 2)'View Code'"]

{"sheet":"Military Alphabet Code (v3)","index":3,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Letter","Code word",null,"Word","Whiskey, Oscar, Romeo, Delta",null,"Kevin's Formula Solutionv3","Len",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["A","Alfa",null,"sumit","Sierra, Uniform, Mike, India, Tango",null,{"$f":"IF(D2=\"\",\"\",SUBSTITUTE(I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2,\",\",\"\",H2))","v":"Sierra, Uniform, Mike, India, Tango "},{"$f":"LEN(D2)","v":5},{"$f":"IF($H2<I$1,\"\",IFERROR(INDEX($B$2:$B$27,INDEX(MATCH(MID($D2,ROW(INDIRECT(1&\":\"&$H2)),1),$A$2:$A$27,0),I$1))&\", \",\"\"))","v":"Sierra, "},"Uniform, ","Mike, ","India, ","Tango, ","","","","","",{"$f":"IF($H2<S$1,\"\",IFERROR(INDEX($B$2:$B$27,INDEX(MATCH(MID($D2,ROW(INDIRECT(1&\":\"&$H2)),1),$A$2:$A$27,0),S$1))&\", \",\"\"))","v":""},"","","",""]
["B","Bravo",null,"bansal","Bravo, Alfa, November, Sierra, Alfa, Lima",null,"Bravo, Alfa, November, Sierra, Alfa, Lima ",6,"Bravo, ","Alfa, ","November, ","Sierra, ","Alfa, ","Lima, ","","","","","","","","",""]
["C","Charlie",null,"excel","Echo, X-ray, Charlie, Echo, Lima",null,"Echo, X-ray, Charlie, Echo, Lima ",{"$f":"LEN(D4)","v":5},"Echo, ","X-ray, ","Charlie, ","Echo, ","Lima, ","","","","","","","","","",""]
["D","Delta",null,"Database","Delta, Alfa, Tango, Alfa, Bravo, Alfa, Sierra, Echo",null,"Delta, Alfa, Tango, Alfa, Bravo, Alfa, Sierra, Echo ",{"$f":"LEN(D5)","v":8},"Delta, ","Alfa, ","Tango, ","Alfa, ","Bravo, ","Alfa, ","Sierra, ","Echo, ","","","","","","",""]
["E","Echo",null,"Pivot Table","Papa, India, Victor, Oscar, Tango,  , Tango, Alfa, Bravo, Lima, Echo",null,"Papa, India, Victor, Oscar, Tango, Tango, Alfa, Bravo, Lima, ",11,"Papa, ","India, ","Victor, ","Oscar, ","Tango, ","","Tango, ","Alfa, ","Bravo, ","Lima, ","Echo, ","","","",""]
["F","Foxtrot",null,"Kevin","Kilo, Echo, Victor, India, November",null,"Kilo, Echo, Victor, India, November ",5,"Kilo, ","Echo, ","Victor, ","India, ","November, ","","","","","","","","","",""]
["G","Golf",null,"Formula","Foxtrot, Oscar, Romeo, Mike, Uniform, Lima, Alfa",null,"Foxtrot, Oscar, Romeo, Mike, Uniform, Lima, Alfa ",7,"Foxtrot, ","Oscar, ","Romeo, ","Mike, ","Uniform, ","Lima, ","Alfa, ","","","","","","","",""]
["H","Hotel",null,"or","Oscar, Romeo",null,"Oscar, Romeo ",2,"Oscar, ","Romeo, ","","","","","","","","","","","","",""]
["I","India",null,"VBA","Victor, Bravo, Alfa",null,"Victor, Bravo, Alfa ",3,"Victor, ","Bravo, ","Alfa, ","","","","","","","","","","","",""]
["J","Juliett",null,null,null,null,"",0,"","","","","","","","","","","","","","",""]
["K","Kilo"]
["L","Lima"]
["M","Mike"]
["N","November"]
["O","Oscar"]
["P","Papa"]
["Q","Quebec"]
["R","Romeo",null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G2)","v":"=IF(D2=\"\",\"\",SUBSTITUTE(I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2,\",\",\"\",H2))"},{"$f":"_xlfn.FORMULATEXT(H2)","v":"=LEN(D2)"},null,null,null,{"$f":"_xlfn.FORMULATEXT(I2)","v":"=IF($H2<I$1,\"\",IFERROR(INDEX($B$2:$B$27,INDEX(MATCH(MID($D2,ROW(INDIRECT(1&\":\"&$H2)),1),$A$2:$A$27,0),I$1))&\", \",\"\"))"}]
["S","Sierra",null,null,null,null,"a)Concatenate all the words together using &","a)Length of Code Words",null,null,null,"NOTE: this formula is much more complicated. Why did I create this???"]
["T","Tango",null,null,null,null,"b)Use SUBSTITUTE function to remove last \", \" value.",null,null,null,null,"Now that I think about it…I probably did this to experiment with extracting all letters from the word, looking them all up and then picking the nth one depending on the counter"]
["U","Uniform",null,null,null,null,"Rare use of optional [instance_num] parameter",null,null,null,null,"This is NOT a friendly solution but study the MATCH part ([lookup_value] & [lookup_array]) to see what's going on."]
["V","Victor",null,null,null,null,null,null,null,null,null,"Also, check out the combination of ROW, INDIRECT and LEN functions below."]
["W","Whiskey"]
["X","X-ray"]
["Y","Yankee"]
["Z","Zulu",null,null,null,"Note: my formula solutions are only dragged down to row 11 to make room for comments."]
[null,null,null,null,null,"To see Sumit's VBA code: 1)Right click on sheet name, 2)'View Code'",null,null,null,null,null,null,null,{"$f":"ROW(INDIRECT(1&\":\"&LEN(D2)))","v":1},{"$f":"MID($D$2,N28:N32,1)","v":"s"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,"u"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4,"i"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,"t"]

{"sheet":"Pros and Cons","index":4,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,"Pros","Cons"]
[null,"VBA","Works in any cell in column D (shorter range could be specified)","If column is inserted left of column D code runs in this new column \"D\".\nMacros must be enabled."]
[null,"Formula","Will work in non macro workbooks (i.e. xlsx)","Would require a lot of formulas in a large dataset"]