{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","ProgramNote","ProgramNote (2)","Names","Companies","Recap"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":1,"defined_names":15,"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,2041]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Free-Photos / Pixabay"]

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

{"sheet":"ProgramNote (2)","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Names","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Name","F. Last"]
["ALEX PILAR","A. Pilar"]
["GARY KANE","G. Kane"]
["DENNIS P. JANCSY","D. P. Jancsy"]
["ALLEN MATZ","A. Matz"]
["MIKE GIRVIN","M. Girvin"]
["CAROLINE BONNER","C. Bonner"]
["GRAHAM STENT","G. Stent"]
["MARTHA K. WENDEL","M. K. Wendel"]
["PETER SUSEN","P. Susen"]
["BRIAN CANES","B. Canes"]

{"sheet":"Companies","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Customer","Type","Number"]
["900 bradedgar.com - consulting","Consulting",900]
["1164 Frontline Systems - applications","Applications",1164]
["1156 California Blazing Chile Farms - retail","Retail",1156]
["1175 Safety Elements Ltd. - services","Services",1175]
["918 Hybrid Software - applications","Applications",918]
["947 IMA Houston Chapter - associations","Associations",947]
["1048 Fintega Financial Modelling - consulting","Consulting",1048]
["1001 Roto-Rooter - services","Services",1001]
["1103 MN Excel Consulting - consulting","Consulting",1103]
["1145 Open Sky Martial Arts - training","Training",1145]

{"sheet":"Recap","index":5,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Episode Recap"]
[]
[null,"Flash Fill was introduced in Excel 2013"]
[null,"It is great for parsing (breaking apart) text"]
[null,"It is great for concatenating as well"]
[null,"Make sure the new column has a heading"]
[null,"Type the entry for the first row"]
[null,"Start to type the entry for the second row - the results will grey in."]
[null,"Press enter to accept the results"]
[null,"You can correct an entry after Flash Fill and it will correct others that match the new pattern."]
[null,"You can invoke Flash Fill with Ctrl+E"]
[null,"Flash fill tends not to work automatically with numbers."]
[null,"But you can still use it for numbers by using Ctrl+E"]