{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","Question","BillTry","MikeTry","BillTry3","WrapUp"],"not_rendered":{"charts":0,"images":6,"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,186]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Pexels / Pixabay"]

{"sheet":"Question","index":1,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Code","Change"]
["BXB0","Yes"]
["wSEP9","Yes"]
["Hwkj","No"]
["RcdgM","No"]
["lTSc","No"]
["br86Z5tQ","Yes"]
["EvdnaBTg","No"]
["qn17r89f","Yes"]
["KsbeLd","No"]
["htagh","No"]
["tjaoEmr","No"]
["wJnv","No"]
["Mdotblh","No"]
["li419","Yes"]
["S0Hh8","Yes"]
["0TuW","Yes"]
["hPdJtAgK","No"]
["gpRqr","No"]
["tXzcZ","No"]
["uQIymo","No"]
["i8v08","Yes"]
["dLKBb","No"]
["0DeBe1Lb","Yes"]
["ldwD","No"]
["cycNV","No"]
["xMLGtc","No"]
["VvnP","No"]
["3sFY9Q","Yes"]
["oBjq","No"]
["TlnTzkK","No"]
["Dl3t6EJ","Yes"]
["2tI4Dd","Yes"]
["DHt1VV7hh","Yes"]
["IRpsK","No"]
["uleVVx","No"]
["ufuOTKpV","No"]
["gUjp2C","Yes"]
["UBfUp","No"]
["C5GDH","Yes"]
["QDfWg","No"]
["NO488B1","Yes"]
["HpcMQEJKV","No"]
["640586Xk7","Yes"]
["bGKvynJQd","No"]

{"sheet":"BillTry","index":2,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Code"]
["BXB0"]
["wSEP9"]
["Hwkj"]
["RcdgM"]
["lTSc"]
["br86Z5tQ"]
["EvdnaBTg"]
["qn17r89f"]
["KsbeLd"]
["htagh"]
["tjaoEmr"]
["wJnv"]
["Mdotblh"]
["li419"]
["S0Hh8"]
["0TuW"]
["hPdJtAgK"]
["gpRqr"]
["tXzcZ"]
["uQIymo"]
["i8v08"]
["dLKBb"]
["0DeBe1Lb"]
["ldwD"]
["cycNV"]
["xMLGtc"]
["VvnP"]
["3sFY9Q"]
["oBjq"]
["TlnTzkK"]
["Dl3t6EJ"]
["2tI4Dd"]
["DHt1VV7hh"]
["IRpsK"]
["uleVVx"]
["ufuOTKpV"]
["gUjp2C"]
["UBfUp"]
["C5GDH"]
["QDfWg"]
["NO488B1"]
["HpcMQEJKV"]
["640586Xk7"]
["bGKvynJQd"]

{"sheet":"MikeTry","index":3,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Code"]
["BXB0"]
["wSEP9"]
["Hwkj"]
["RcdgM"]
["lTSc"]
["br86Z5tQ"]
["EvdnaBTg"]
["qn17r89f"]
["KsbeLd"]
["htagh"]
["tjaoEmr"]
["wJnv"]
["Mdotblh"]
["li419"]
["S0Hh8"]
["0TuW"]
["hPdJtAgK"]
["gpRqr"]
["tXzcZ"]
["uQIymo"]
["i8v08"]
["dLKBb"]
["0DeBe1Lb"]
["ldwD"]
["cycNV"]
["xMLGtc"]
["VvnP"]
["3sFY9Q"]
["oBjq"]
["TlnTzkK"]
["Dl3t6EJ"]
["2tI4Dd"]
["DHt1VV7hh"]
["IRpsK"]
["uleVVx"]
["ufuOTKpV"]
["gUjp2C"]
["UBfUp"]
["C5GDH"]
["QDfWg"]
["NO488B1"]
["HpcMQEJKV"]
["640586Xk7"]
["bGKvynJQd"]

{"sheet":"BillTry3","index":4,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Code","Result"]
["BXB0",{"$f":"HasNumbers(A2)","v":"Numbers"}]
["wSEP9",{"$f":"HasNumbers(A3)","v":"Numbers"}]
["Hwkj","Alpha"]
["RcdgM","Alpha"]
["lTSc","Alpha"]
["br86Z5tQ","Numbers"]
["EvdnaBTg","Alpha"]
["qn17r89f","Numbers"]
["KsbeLd","Alpha"]
["htagh","Alpha"]
["tjaoEmr","Alpha"]
["wJnv","Alpha"]
["Mdotblh","Alpha"]
["li419","Numbers"]
["S0Hh8","Numbers"]
["0TuW","Numbers"]
["hPdJtAgK","Alpha"]
["gpRqr","Alpha"]
["tXzcZ","Alpha"]
["uQIymo","Alpha"]
["i8v08","Numbers"]
["dLKBb","Alpha"]
["0DeBe1Lb","Numbers"]
["ldwD","Alpha"]
["cycNV","Alpha"]
["xMLGtc","Alpha"]
["VvnP","Alpha"]
["3sFY9Q","Numbers"]
["oBjq","Alpha"]
["TlnTzkK","Alpha"]
["Dl3t6EJ","Numbers"]
["2tI4Dd","Numbers"]
["DHt1VV7hh","Numbers"]
["IRpsK","Alpha"]
["uleVVx","Alpha"]
["ufuOTKpV","Alpha"]
["gUjp2C","Numbers"]
["UBfUp","Alpha"]
["C5GDH","Numbers"]
["QDfWg","Alpha"]
["NO488B1","Numbers"]
["HpcMQEJKV","Alpha"]
["640586Xk7","Numbers"]
["bGKvynJQd","Alpha"]

{"sheet":"WrapUp","index":5,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Wrap Up"]
[]
[null,"Check a column to see if there are any digits in the code"]
[null,"Bill Method 1:"]
[null,"Flash Fill"]
[]
[null,"Mike Method:"]
[null,"Use the SUBSTITUTE function with an Array Constant."]
[null,"You will not have to use Ctrl+Shift+Enter because it is an array constant"]
[null,"This will remove one digit at a time"]
[null,"Use the AND function to see if every item in the resultant array is equal to the original item"]
[]
[null,"Bill Method 3:"]
[null,"Use a VBA Function to check for digits"]