{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Title","Goal","Bill1","Mike1","Bill2","Mike2","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":0,"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,182]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: braetschit / Pixabay"]

{"sheet":"Goal","index":1,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data"]
[123,"Main Street "]
["Howard","End  "]
[234,"Second Ave "]
["Sioux","Li  "]
[345,"Third Blvd "]
["Hunter","Smith Jr "]
[123,"Main Street "]
["Howard","End  "]
[234,"Second Ave "]
["Sioux","Li  "]
[345,"Third Blvd "]
["Hunter","Smith Jr "]
[123,"Main Street "]
["Howard","End  "]
[234,"Second Ave "]
["Sioux","Li  "]
[345,"Third Blvd "]
["Hunter","Smith Jr "]
[123,"Main Street "]
["Howard","End  "]
[234,"Second Ave "]
["Sioux","Li  "]
[345,"Third Blvd "]
["Hunter","Smith Jr "]

{"sheet":"Bill1","index":2,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]

{"sheet":"Mike1","index":3,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]

{"sheet":"Bill2","index":4,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data","First Part","Second Part"]
["123 Main Street",123,"Main Street"]
["Howard End","Howard","End"]
["234 Second Ave",234,"Second Ave"]
["Sioux Li","Sioux","Li"]
["345 Third Blvd",345,"Third Blvd"]
["Hunter Smith Jr","Hunter","Smith Jr"]
["123 Main Street",123,"Main Street"]
["Howard End","Howard","End"]
["234 Second Ave",234,"Second Ave"]
["Sioux Li","Sioux","Li"]
["345 Third Blvd",345,"Third Blvd"]
["Hunter Smith Jr","Hunter","Smith Jr"]
["123 Main Street",123,"Main Street"]
["Howard End","Howard","End"]
["234 Second Ave",234,"Second Ave"]
["Sioux Li","Sioux","Li"]
["345 Third Blvd",345,"Third Blvd"]
["Hunter Smith Jr","Hunter","Smith Jr"]
["123 Main Street",123,"Main Street"]
["Howard End","Howard","End"]
["234 Second Ave",234,"Second Ave"]
["Sioux Li","Sioux","Li"]
["345 Third Blvd",345,"Third Blvd"]
["Hunter Smith Jr","Hunter","Smith Jr"]

{"sheet":"Mike2","index":5,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]
["123 Main Street"]
["Howard End"]
["234 Second Ave"]
["Sioux Li"]
["345 Third Blvd"]
["Hunter Smith Jr"]

{"sheet":"Wrap Up","index":6,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Bill's first method using Text to Columns (found on the Data tab)."]
[null,"In step 1, choose delimited. In step 2, choose a space. Skip step 3 by clicking finish. "]
[null,"The text will split at each space, so anything with three words will end up in 3 cells. Put those back together with =TEXTJOIN(\" \",True,B2:E2) or "]
[null,"with =B2&\" \"&C2&\" \"&D2"]
[null,"Mike's first method uses Power Query. Power Query is Get & Transform in 2016 or a free download for 2010 or 2013."]
[null,"First, convert your data to a table using Ctrl+T. Then, in Power Query, from Table. Split Column, by Delimiter. Select Space and then at the left-most delimiter."]
[null,"You can re-name a column by double-clicking!"]
[null,"Close & Load To… and choose a new spot on the worksheet."]
[null,"Bill's second method is to use Flash Fill. Type new headings in A, B & C. Flash Fill will not work if you don't have headings! Type a pattern for the first two rows."]
[null,"Go to the first blank cell in B and press Ctrl+e. Repeat for column C."]
[null,"Mike's second method is to use these formulas:"]
[null,"For the first part, use =LEFT(A2,SEARCH(\" \",A2)-1)"]
[null,"For the second part, use =SUBSTITUTE(A2,B2&\" \",\"\")"]