{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Title","Question","BillTry1","MikeTry2","BillTry3","MikeTry4","Wrap Up","MikeReaction"],"not_rendered":{"charts":0,"images":8,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,185]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Alexas_Fotos / Pixabay"]

{"sheet":"Question","index":1,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["Key","Center Part",null,"Anvar on YouTube"]
["A2K-MF5LM-I788-A5J",{"$f":"MidPart(A2)","v":"MF5LM-I788"}]
["A2K-P664-D558-N6-J5K"]
["A5-C5-D5L-L0L-I18-G31-B48"]
["A5-IN7HF-C817-LJ3CD-E7-K6N-LJ3CD"]
["A5-NM7AE-PM9BD-HK6BF"]
["B30-E159-F69-H57"]
["B30-O5-I227-L49-A5J-J3-K6N",null,null,"Thoughts:"]
["B93-FF0BJ-DP9LG-G9D-B30",null,null,"Easy to start at first dash with =MID(A2,FIND(A2,\"-\")+1,9999)"]
["B941-F09-GE4II-HN5LN-H110",null,null,"Hard to find the last dash"]
["BE6PM-NA4IB-E7-O5",null,null,null,"SUBSTITUTE(A2,\"-\",\"\")"]
["C5-E3-I74-G31-F09-N692-E406",null,null,null,"LEN(of that)"]
["C5-P9H-NA4IB-DA4LM-MH7EP",null,null,null,"Compared to LEN(A2)"]
["CM8KO-D558-B941-G9D-OP3GB-P664-J87",null,null,null,"Difference is number of dashes"]
["D3C-N0B-B48-P388-JN2EF-I676",null,null,null,"Now I know which dash to find"]
["D80-F69-K3-J6I-E7-H048",null,null,null,"FIND?"]
["D80-J5K-F9",null,null,null,"SEARCH?"]
["DA4LM-N9G-L0L-E3-I18-L868"]
["E159-CM8KO-J47-L0L-L7",null,null,"VBA UDF - Easy!"]
["E159-G62-L49-B48-I18",null,null,"Flash Fill"]
["E3-IN7HF-A26-BE6PM",null,null,"Fast Excel"]
["E3-L3-B93-D5L"]
["E406-C817-FF0BJ-MF5LM-H7-I728"]
["E406-I788-J5D-D5L"]
["E406-L361-LJ3CD"]
["E7-DP9LG-NA4IB-K3"]
["EI4JJ-F112-H110"]
["F09-GE4II-G9D"]
["F112-A7-J47-C94"]
["F112-N0B-F2H-P9H-H11-HH7HB-J6I"]
["F2H-J6I-B30-F69-GE4II"]
["F9-J16-D558"]
["G9D-A5-B48"]
["G9D-N0B-K6N-D3C-G9D-EI4JJ"]
["H048-CM8KO-LJ3CD-I2O"]
["H11-G4M-C5-J47-A7-NM7AE-M061"]
["H11-H110-I74"]
["H11-O5-E159"]
["H11-P2-OP3GB"]
["H11-P664-G4M-E3-E9"]
["H3-K11-OP3GB"]
["H57-B93-J3-M061-L49-EI4JJ"]
["H7-F69-F09-N6H-JN2EF-N493"]
["HK6BF-A2K-H11-P664-M061-DA4LM-E9"]
["HK6BF-C817-B941-HH7HB"]
["HK6BF-PM3AJ-D2-H57-M10-D782-J47"]
["HN5LN-L3-A26-H3-B941-D3C-B93"]
["I4-D782-A7"]
["I4-L0L-F2H-PM9BD-I18-H57-H7"]
["I788-J47-O5-K11-EI4JJ"]
["J16-E406-N31-E159-NA4IB-A7-I788"]
["J5K-N6H-K3-A5"]
["J6I-J47-L3-BE6PM-H048"]
["K11-PM9BD-G9D-BE6PM"]
["K3-E406-F69-G4M-N493"]
["K3-P2-C5"]
["L0L-H110-DP9LG-L868-G62"]
["L2M-L49-N9G-N31-H3-D558-E7"]
["L3-HH7HB-F2-M10-A5J-PM9BD"]
["L868-F112-PM9BD-D558-E3-EL7BJ"]
["M061-J5D-E7-K6N"]
["M10-I227-I728-L361-F626-I74"]
["MF5LM-E406-N9G-G4M"]
["N0B-F9-D2-HK6BF-MH7EP-N6-J87"]
["N0B-I2O-P664-M061-D8P-J5D"]
["N1-N6H-C94"]
["N692-D782-C5-G62-H11"]
["N692-K6N-DA4LM-I728-L361-B93-E7"]
["N6H-C817-D782-J6I-N6-E3"]
["N6H-GE4II-I676-GE4II-H11-J47"]
["N6H-I788-P2-F1G-DP9LG-PM9BD"]
["N9G-I227-J87-L361-D782"]
["NM7AE-J6I-N0B-D558-F112-E9"]
["O5-D8P-J5K-H3-I788"]
["P2-E7-P388-B30-C5"]
["P388-H21-N0B"]
["P9H-F626-G62"]
["P9H-J5K-NA4IB"]
["PM9BD-I676-HK6BF-HN5LN-N6-A5J"]
["PM9BD-K11-I788-I74"]

{"sheet":"BillTry1","index":2,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["Key","Center Part",null,"Anvar on YouTube"]
["A2K-MF5LM-I788-A5J","MF5LM-I788"]
["A2K-P664-D558-N6-J5K","P664-D558-N6"]
["A5-C5-D5L-L0L-I18-G31-B48","C5-D5L-L0L-I18-G31"]
["A5-IN7HF-C817-LJ3CD-E7-K6N-LJ3CD","IN7HF-C817-LJ3CD-E7-K6N"]
["A5-NM7AE-PM9BD-HK6BF","NM7AE-PM9BD"]
["B30-E159-F69-H57","E159-F69"]
["B30-O5-I227-L49-A5J-J3-K6N","O5-I227-L49-A5J-J3",null,"Thoughts:"]
["B93-FF0BJ-DP9LG-G9D-B30","FF0BJ-DP9LG-G9D",null,"Easy to start at first dash with =MID(A2,FIND(A2,\"-\")+1,9999)"]
["B941-F09-GE4II-HN5LN-H110","F09-GE4II-HN5LN",null,"Hard to find the last dash"]
["BE6PM-NA4IB-E7-O5","NA4IB-E7",null,null,"SUBSTITUTE(A2,\"-\",\"\")"]
["C5-E3-I74-G31-F09-N692-E406","E3-I74-G31-F09-N692",null,null,"LEN(of that)"]
["C5-P9H-NA4IB-DA4LM-MH7EP","P9H-NA4IB-DA4LM",null,null,"Compared to LEN(A2)"]
["CM8KO-D558-B941-G9D-OP3GB-P664-J87","D558-B941-G9D-OP3GB-P664",null,null,"Difference is number of dashes"]
["D3C-N0B-B48-P388-JN2EF-I676","N0B-B48-P388-JN2EF",null,null,"Now I know which dash to find"]
["D80-F69-K3-J6I-E7-H048","F69-K3-J6I-E7",null,null,"FIND?"]
["D80-J5K-F9","J5K",null,null,"SEARCH?"]
["DA4LM-N9G-L0L-E3-I18-L868","N9G-L0L-E3-I18",null,null,"ARGH!"]
["E159-CM8KO-J47-L0L-L7","CM8KO-J47-L0L",null,"VBA UDF - Easy!"]
["E159-G62-L49-B48-I18","G62-L49-B48",null,"Flash Fill"]
["E3-IN7HF-A26-BE6PM","IN7HF-A26",null,"Fast Excel"]
["E3-L3-B93-D5L","L3-B93"]
["E406-C817-FF0BJ-MF5LM-H7-I728","C817-FF0BJ-MF5LM-H7"]
["E406-I788-J5D-D5L","I788-J5D"]
["E406-L361-LJ3CD","L361"]
["E7-DP9LG-NA4IB-K3","DP9LG-NA4IB"]
["EI4JJ-F112-H110","F112"]
["F09-GE4II-G9D","GE4II"]
["F112-A7-J47-C94","A7-J47"]
["F112-N0B-F2H-P9H-H11-HH7HB-J6I","N0B-F2H-P9H-H11-HH7HB"]
["F2H-J6I-B30-F69-GE4II","J6I-B30-F69"]
["F9-J16-D558","J16"]
["G9D-A5-B48","A5"]
["G9D-N0B-K6N-D3C-G9D-EI4JJ","N0B-K6N-D3C-G9D"]
["H048-CM8KO-LJ3CD-I2O","CM8KO-LJ3CD"]
["H11-G4M-C5-J47-A7-NM7AE-M061","G4M-C5-J47-A7-NM7AE"]
["H11-H110-I74","H110"]
["H11-O5-E159","O5"]
["H11-P2-OP3GB","P2"]
["H11-P664-G4M-E3-E9","P664-G4M-E3"]
["H3-K11-OP3GB","K11"]
["H57-B93-J3-M061-L49-EI4JJ","B93-J3-M061-L49"]
["H7-F69-F09-N6H-JN2EF-N493","F69-F09-N6H-JN2EF"]
["HK6BF-A2K-H11-P664-M061-DA4LM-E9","A2K-H11-P664-M061-DA4LM"]
["HK6BF-C817-B941-HH7HB","C817-B941"]
["HK6BF-PM3AJ-D2-H57-M10-D782-J47","PM3AJ-D2-H57-M10-D782"]
["HN5LN-L3-A26-H3-B941-D3C-B93","L3-A26-H3-B941-D3C"]
["I4-D782-A7","D782"]
["I4-L0L-F2H-PM9BD-I18-H57-H7","L0L-F2H-PM9BD-I18-H57"]
["I788-J47-O5-K11-EI4JJ","J47-O5-K11"]
["J16-E406-N31-E159-NA4IB-A7-I788","E406-N31-E159-NA4IB-A7"]
["J5K-N6H-K3-A5","N6H-K3"]
["J6I-J47-L3-BE6PM-H048","J47-L3-BE6PM"]
["K11-PM9BD-G9D-BE6PM","PM9BD-G9D"]
["K3-E406-F69-G4M-N493","E406-F69-G4M"]
["K3-P2-C5","P2"]
["L0L-H110-DP9LG-L868-G62","H110-DP9LG-L868"]
["L2M-L49-N9G-N31-H3-D558-E7","L49-N9G-N31-H3-D558"]
["L3-HH7HB-F2-M10-A5J-PM9BD","HH7HB-F2-M10-A5J"]
["L868-F112-PM9BD-D558-E3-EL7BJ","F112-PM9BD-D558-E3"]
["M061-J5D-E7-K6N","J5D-E7"]
["M10-I227-I728-L361-F626-I74","I227-I728-L361-F626"]
["MF5LM-E406-N9G-G4M","E406-N9G"]
["N0B-F9-D2-HK6BF-MH7EP-N6-J87","F9-D2-HK6BF-MH7EP-N6"]
["N0B-I2O-P664-M061-D8P-J5D","I2O-P664-M061-D8P"]
["N1-N6H-C94","N6H"]
["N692-D782-C5-G62-H11","D782-C5-G62"]
["N692-K6N-DA4LM-I728-L361-B93-E7","K6N-DA4LM-I728-L361-B93"]
["N6H-C817-D782-J6I-N6-E3","C817-D782-J6I-N6"]
["N6H-GE4II-I676-GE4II-H11-J47","GE4II-I676-GE4II-H11"]
["N6H-I788-P2-F1G-DP9LG-PM9BD","I788-P2-F1G-DP9LG"]
["N9G-I227-J87-L361-D782","I227-J87-L361"]
["NM7AE-J6I-N0B-D558-F112-E9","J6I-N0B-D558-F112"]
["O5-D8P-J5K-H3-I788","D8P-J5K-H3"]
["P2-E7-P388-B30-C5","E7-P388-B30"]
["P388-H21-N0B","H21"]
["P9H-F626-G62","F626"]
["P9H-J5K-NA4IB","J5K"]
["PM9BD-I676-HK6BF-HN5LN-N6-A5J","I676-HK6BF-HN5LN-N6"]
["PM9BD-K11-I788-I74","K11-I788"]

{"sheet":"MikeTry2","index":3,"n_rows":80,"n_cols":4,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["Key","Center Part",null,"Anvar on YouTube"]
["A2K-MF5LM-I788-A5J",{"$f":"MidPart(A2)","v":"MF5LM-I788"}]
["A2K-P664-D558-N6-J5K"]
["A5-C5-D5L-L0L-I18-G31-B48"]
["A5-IN7HF-C817-LJ3CD-E7-K6N-LJ3CD"]
["A5-NM7AE-PM9BD-HK6BF"]
["B30-E159-F69-H57"]
["B30-O5-I227-L49-A5J-J3-K6N"]
["B93-FF0BJ-DP9LG-G9D-B30"]
["B941-F09-GE4II-HN5LN-H110"]
["BE6PM-NA4IB-E7-O5"]
["C5-E3-I74-G31-F09-N692-E406"]
["C5-P9H-NA4IB-DA4LM-MH7EP"]
["CM8KO-D558-B941-G9D-OP3GB-P664-J87"]
["D3C-N0B-B48-P388-JN2EF-I676"]
["D80-F69-K3-J6I-E7-H048"]
["D80-J5K-F9"]
["DA4LM-N9G-L0L-E3-I18-L868"]
["E159-CM8KO-J47-L0L-L7"]
["E159-G62-L49-B48-I18"]
["E3-IN7HF-A26-BE6PM"]
["E3-L3-B93-D5L"]
["E406-C817-FF0BJ-MF5LM-H7-I728"]
["E406-I788-J5D-D5L"]
["E406-L361-LJ3CD"]
["E7-DP9LG-NA4IB-K3"]
["EI4JJ-F112-H110"]
["F09-GE4II-G9D"]
["F112-A7-J47-C94"]
["F112-N0B-F2H-P9H-H11-HH7HB-J6I"]
["F2H-J6I-B30-F69-GE4II"]
["F9-J16-D558"]
["G9D-A5-B48"]
["G9D-N0B-K6N-D3C-G9D-EI4JJ"]
["H048-CM8KO-LJ3CD-I2O"]
["H11-G4M-C5-J47-A7-NM7AE-M061"]
["H11-H110-I74"]
["H11-O5-E159"]
["H11-P2-OP3GB"]
["H11-P664-G4M-E3-E9"]
["H3-K11-OP3GB"]
["H57-B93-J3-M061-L49-EI4JJ"]
["H7-F69-F09-N6H-JN2EF-N493"]
["HK6BF-A2K-H11-P664-M061-DA4LM-E9"]
["HK6BF-C817-B941-HH7HB"]
["HK6BF-PM3AJ-D2-H57-M10-D782-J47"]
["HN5LN-L3-A26-H3-B941-D3C-B93"]
["I4-D782-A7"]
["I4-L0L-F2H-PM9BD-I18-H57-H7"]
["I788-J47-O5-K11-EI4JJ"]
["J16-E406-N31-E159-NA4IB-A7-I788"]
["J5K-N6H-K3-A5"]
["J6I-J47-L3-BE6PM-H048"]
["K11-PM9BD-G9D-BE6PM"]
["K3-E406-F69-G4M-N493"]
["K3-P2-C5"]
["L0L-H110-DP9LG-L868-G62"]
["L2M-L49-N9G-N31-H3-D558-E7"]
["L3-HH7HB-F2-M10-A5J-PM9BD"]
["L868-F112-PM9BD-D558-E3-EL7BJ"]
["M061-J5D-E7-K6N"]
["M10-I227-I728-L361-F626-I74"]
["MF5LM-E406-N9G-G4M"]
["N0B-F9-D2-HK6BF-MH7EP-N6-J87"]
["N0B-I2O-P664-M061-D8P-J5D"]
["N1-N6H-C94"]
["N692-D782-C5-G62-H11"]
["N692-K6N-DA4LM-I728-L361-B93-E7"]
["N6H-C817-D782-J6I-N6-E3"]
["N6H-GE4II-I676-GE4II-H11-J47"]
["N6H-I788-P2-F1G-DP9LG-PM9BD"]
["N9G-I227-J87-L361-D782"]
["NM7AE-J6I-N0B-D558-F112-E9"]
["O5-D8P-J5K-H3-I788"]
["P2-E7-P388-B30-C5"]
["P388-H21-N0B"]
["P9H-F626-G62"]
["P9H-J5K-NA4IB"]
["PM9BD-I676-HK6BF-HN5LN-N6-A5J"]
["PM9BD-K11-I788-I74"]

{"sheet":"BillTry3","index":4,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["Key","Center Part"]
["A2K-MF5LM-I788-A5J",{"$f":"MidPart(A2)","v":"MF5LM-I788"}]
["A2K-P664-D558-N6-J5K",{"$f":"MidPart(A3)","v":"P664-D558-N6"}]
["A5-C5-D5L-L0L-I18-G31-B48","C5-D5L-L0L-I18-G31"]
["A5-IN7HF-C817-LJ3CD-E7-K6N-LJ3CD","IN7HF-C817-LJ3CD-E7-K6N"]
["A5-NM7AE-PM9BD-HK6BF","NM7AE-PM9BD"]
["B30-E159-F69-H57","E159-F69"]
["B30-O5-I227-L49-A5J-J3-K6N","O5-I227-L49-A5J-J3",null,"Thoughts:"]
["B93-FF0BJ-DP9LG-G9D-B30","FF0BJ-DP9LG-G9D",null,"Easy to start at first dash with =MID(A2,FIND(A2,\"-\")+1,9999)"]
["B941-F09-GE4II-HN5LN-H110","F09-GE4II-HN5LN",null,"Hard to find the last dash"]
["BE6PM-NA4IB-E7-O5","NA4IB-E7",null,null,"SUBSTITUTE(A2,\"-\",\"\")"]
["C5-E3-I74-G31-F09-N692-E406","E3-I74-G31-F09-N692",null,null,"LEN(of that)"]
["C5-P9H-NA4IB-DA4LM-MH7EP","P9H-NA4IB-DA4LM",null,null,"Compared to LEN(A2)"]
["CM8KO-D558-B941-G9D-OP3GB-P664-J87","D558-B941-G9D-OP3GB-P664",null,null,"Difference is number of dashes"]
["D3C-N0B-B48-P388-JN2EF-I676","N0B-B48-P388-JN2EF",null,null,"Now I know which dash to find"]
["D80-F69-K3-J6I-E7-H048","F69-K3-J6I-E7",null,null,"FIND?"]
["D80-J5K-F9","J5K",null,null,"SEARCH?"]
["DA4LM-N9G-L0L-E3-I18-L868","N9G-L0L-E3-I18"]
["E159-CM8KO-J47-L0L-L7","CM8KO-J47-L0L",null,"VBA UDF - Easy!"]
["E159-G62-L49-B48-I18",{"$f":"MidPart(A20)","v":"G62-L49-B48"},null,"Flash Fill"]
["E3-IN7HF-A26-BE6PM","IN7HF-A26",null,"Fast Excel"]
["E3-L3-B93-D5L","L3-B93"]
["E406-C817-FF0BJ-MF5LM-H7-I728","C817-FF0BJ-MF5LM-H7"]
["E406-I788-J5D-D5L","I788-J5D"]
["E406-L361-LJ3CD","L361"]
["E7-DP9LG-NA4IB-K3","DP9LG-NA4IB"]
["EI4JJ-F112-H110","F112"]
["F09-GE4II-G9D","GE4II"]
["F112-A7-J47-C94","A7-J47"]
["F112-N0B-F2H-P9H-H11-HH7HB-J6I","N0B-F2H-P9H-H11-HH7HB"]
["F2H-J6I-B30-F69-GE4II","J6I-B30-F69"]
["F9-J16-D558","J16"]
["G9D-A5-B48","A5"]
["G9D-N0B-K6N-D3C-G9D-EI4JJ","N0B-K6N-D3C-G9D"]
["H048-CM8KO-LJ3CD-I2O","CM8KO-LJ3CD"]
["H11-G4M-C5-J47-A7-NM7AE-M061","G4M-C5-J47-A7-NM7AE"]
["H11-H110-I74","H110"]
["H11-O5-E159","O5"]
["H11-P2-OP3GB","P2"]
["H11-P664-G4M-E3-E9","P664-G4M-E3"]
["H3-K11-OP3GB","K11"]
["H57-B93-J3-M061-L49-EI4JJ","B93-J3-M061-L49"]
["H7-F69-F09-N6H-JN2EF-N493","F69-F09-N6H-JN2EF"]
["HK6BF-A2K-H11-P664-M061-DA4LM-E9","A2K-H11-P664-M061-DA4LM"]
["HK6BF-C817-B941-HH7HB","C817-B941"]
["HK6BF-PM3AJ-D2-H57-M10-D782-J47","PM3AJ-D2-H57-M10-D782"]
["HN5LN-L3-A26-H3-B941-D3C-B93","L3-A26-H3-B941-D3C"]
["I4-D782-A7","D782"]
["I4-L0L-F2H-PM9BD-I18-H57-H7","L0L-F2H-PM9BD-I18-H57"]
["I788-J47-O5-K11-EI4JJ","J47-O5-K11"]
["J16-E406-N31-E159-NA4IB-A7-I788","E406-N31-E159-NA4IB-A7"]
["J5K-N6H-K3-A5","N6H-K3"]
["J6I-J47-L3-BE6PM-H048","J47-L3-BE6PM"]
["K11-PM9BD-G9D-BE6PM","PM9BD-G9D"]
["K3-E406-F69-G4M-N493","E406-F69-G4M"]
["K3-P2-C5","P2"]
["L0L-H110-DP9LG-L868-G62","H110-DP9LG-L868"]
["L2M-L49-N9G-N31-H3-D558-E7","L49-N9G-N31-H3-D558"]
["L3-HH7HB-F2-M10-A5J-PM9BD","HH7HB-F2-M10-A5J"]
["L868-F112-PM9BD-D558-E3-EL7BJ","F112-PM9BD-D558-E3"]
["M061-J5D-E7-K6N","J5D-E7"]
["M10-I227-I728-L361-F626-I74","I227-I728-L361-F626"]
["MF5LM-E406-N9G-G4M","E406-N9G"]
["N0B-F9-D2-HK6BF-MH7EP-N6-J87","F9-D2-HK6BF-MH7EP-N6"]
["N0B-I2O-P664-M061-D8P-J5D","I2O-P664-M061-D8P"]
["N1-N6H-C94","N6H"]
["N692-D782-C5-G62-H11",{"$f":"MidPart(A67)","v":"D782-C5-G62"}]
["N692-K6N-DA4LM-I728-L361-B93-E7","K6N-DA4LM-I728-L361-B93"]
["N6H-C817-D782-J6I-N6-E3","C817-D782-J6I-N6"]
["N6H-GE4II-I676-GE4II-H11-J47","GE4II-I676-GE4II-H11"]
["N6H-I788-P2-F1G-DP9LG-PM9BD","I788-P2-F1G-DP9LG"]
["N9G-I227-J87-L361-D782","I227-J87-L361"]
["NM7AE-J6I-N0B-D558-F112-E9","J6I-N0B-D558-F112"]
["O5-D8P-J5K-H3-I788","D8P-J5K-H3"]
["P2-E7-P388-B30-C5","E7-P388-B30"]
["P388-H21-N0B","H21"]
["P9H-F626-G62","F626"]
["P9H-J5K-NA4IB","J5K"]
["PM9BD-I676-HK6BF-HN5LN-N6-A5J","I676-HK6BF-HN5LN-N6"]
["PM9BD-K11-I788-I74","K11-I788"]

{"sheet":"MikeTry4","index":5,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["Key","Center Part",null,"Anvar on YouTube"]
["A2K-MF5LM-I788-A5J",{"$f":"MidPart(A2)","v":"MF5LM-I788"}]
["A2K-P664-D558-N6-J5K"]
["A5-C5-D5L-L0L-I18-G31-B48"]
["A5-IN7HF-C817-LJ3CD-E7-K6N-LJ3CD"]
["A5-NM7AE-PM9BD-HK6BF"]
["B30-E159-F69-H57"]
["B30-O5-I227-L49-A5J-J3-K6N"]
["B93-FF0BJ-DP9LG-G9D-B30"]
["B941-F09-GE4II-HN5LN-H110"]
["BE6PM-NA4IB-E7-O5",null,null,null,"SUBSTITUTE(A2,\"-\",\"\")"]
["C5-E3-I74-G31-F09-N692-E406",null,null,null,"LEN(of that)"]
["C5-P9H-NA4IB-DA4LM-MH7EP",null,null,null,"Compared to LEN(A2)"]
["CM8KO-D558-B941-G9D-OP3GB-P664-J87",null,null,null,"Difference is number of dashes"]
["D3C-N0B-B48-P388-JN2EF-I676",null,null,null,"Now I know which dash to find"]
["D80-F69-K3-J6I-E7-H048",null,null,null,"FIND?"]
["D80-J5K-F9",null,null,null,"SEARCH?"]
["DA4LM-N9G-L0L-E3-I18-L868"]
["E159-CM8KO-J47-L0L-L7"]
["E159-G62-L49-B48-I18"]
["E3-IN7HF-A26-BE6PM"]
["E3-L3-B93-D5L"]
["E406-C817-FF0BJ-MF5LM-H7-I728"]
["E406-I788-J5D-D5L"]
["E406-L361-LJ3CD"]
["E7-DP9LG-NA4IB-K3"]
["EI4JJ-F112-H110"]
["F09-GE4II-G9D"]
["F112-A7-J47-C94"]
["F112-N0B-F2H-P9H-H11-HH7HB-J6I"]
["F2H-J6I-B30-F69-GE4II"]
["F9-J16-D558"]
["G9D-A5-B48"]
["G9D-N0B-K6N-D3C-G9D-EI4JJ"]
["H048-CM8KO-LJ3CD-I2O"]
["H11-G4M-C5-J47-A7-NM7AE-M061"]
["H11-H110-I74"]
["H11-O5-E159"]
["H11-P2-OP3GB"]
["H11-P664-G4M-E3-E9"]
["H3-K11-OP3GB"]
["H57-B93-J3-M061-L49-EI4JJ"]
["H7-F69-F09-N6H-JN2EF-N493"]
["HK6BF-A2K-H11-P664-M061-DA4LM-E9"]
["HK6BF-C817-B941-HH7HB"]
["HK6BF-PM3AJ-D2-H57-M10-D782-J47"]
["HN5LN-L3-A26-H3-B941-D3C-B93"]
["I4-D782-A7"]
["I4-L0L-F2H-PM9BD-I18-H57-H7"]
["I788-J47-O5-K11-EI4JJ"]
["J16-E406-N31-E159-NA4IB-A7-I788"]
["J5K-N6H-K3-A5"]
["J6I-J47-L3-BE6PM-H048"]
["K11-PM9BD-G9D-BE6PM"]
["K3-E406-F69-G4M-N493"]
["K3-P2-C5"]
["L0L-H110-DP9LG-L868-G62"]
["L2M-L49-N9G-N31-H3-D558-E7"]
["L3-HH7HB-F2-M10-A5J-PM9BD"]
["L868-F112-PM9BD-D558-E3-EL7BJ"]
["M061-J5D-E7-K6N"]
["M10-I227-I728-L361-F626-I74"]
["MF5LM-E406-N9G-G4M"]
["N0B-F9-D2-HK6BF-MH7EP-N6-J87"]
["N0B-I2O-P664-M061-D8P-J5D"]
["N1-N6H-C94"]
["N692-D782-C5-G62-H11"]
["N692-K6N-DA4LM-I728-L361-B93-E7"]
["N6H-C817-D782-J6I-N6-E3"]
["N6H-GE4II-I676-GE4II-H11-J47"]
["N6H-I788-P2-F1G-DP9LG-PM9BD"]
["N9G-I227-J87-L361-D782"]
["NM7AE-J6I-N0B-D558-F112-E9"]
["O5-D8P-J5K-H3-I788"]
["P2-E7-P388-B30-C5"]
["P388-H21-N0B"]
["P9H-F626-G62"]
["P9H-J5K-NA4IB"]
["PM9BD-I676-HK6BF-HN5LN-N6-A5J"]
["PM9BD-K11-I788-I74"]

{"sheet":"Wrap Up","index":6,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Goal is to find the first & last dash and keep everything in between"]
[null,"The hard part here is finding the last dash"]
[null,"Bill Method 1: Flash Fill"]
[null,"Manually fill in the first few (including some with different numbers of dashes)"]
[null,"Select the blank cell below that"]
[null,"Ctrl+E to Flash Fill"]
[null,"Mike Method 2:"]
[null,"Use Power Query"]
[null,"In Excel 2016, Power Query is in the Get & Transform group in Excel 2016"]
[null,"In Excel 2010 & 2013, download Power Query from Microsoft. It creates a new Power Query tab in the Ribbon"]
[null,"Convert your data to a table using Ctrl+T"]
[null,"Use Split Data in Power Query - first to split at the leftmost dash, then to split at the right-most dash"]
[null,"Bill Method 3:"]
[null,"VBA Function that iterates from end of the cell backwards to find the last dash"]
[null,"Mike Method 4:"]
[null,"Use SUBSTITUTE to find the location of the Nth dash"]
[null,"SUBSTITUTE is the only text function that allows you to specify an Instance number"]
[null,"To find which instance number, use LEN(A2)-LEN(SUBSTITUTE)"]

{"sheet":"MikeReaction","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}