{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Title","Goal","Try","Bill1","Mike1","Bill2","Mike2","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":1,"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":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,182]

{"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":"Try","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":"Bill1","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data",null,"Data",null,null,null,"TEXTJOIN",null,"Ampersand"]
["123 Main Street",null,123,"Main","Street",null,{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,D2:F2)","v":"Main Street"},null,{"$f":"D2&\" \" &E2","v":"Main Street"}]
["Howard End",null,"Howard","End",null,null,{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,D3:F3)","v":"End"},null,{"$f":"D3&\" \" &E3","v":"End "}]
["234 Second Ave",null,234,"Second","Ave",null,"Second Ave",null,"Second Ave"]
["Sioux Li",null,"Sioux","Li",null,null,"Li",null,"Li "]
["345 Third Blvd",null,345,"Third","Blvd",null,"Third Blvd",null,"Third Blvd"]
["Hunter Smith Jr",null,"Hunter","Smith","Jr",null,"Smith Jr",null,"Smith Jr"]
["123 Main Street",null,123,"Main","Street",null,"Main Street",null,"Main Street"]
["Howard End",null,"Howard","End",null,null,"End",null,"End "]
["234 Second Ave",null,234,"Second","Ave",null,"Second Ave",null,"Second Ave"]
["Sioux Li",null,"Sioux","Li",null,null,"Li",null,"Li "]
["345 Third Blvd",null,345,"Third","Blvd",null,"Third Blvd",null,"Third Blvd"]
["Hunter Smith Jr",null,"Hunter","Smith","Jr",null,"Smith Jr",null,"Smith Jr"]
["123 Main Street",null,123,"Main","Street",null,"Main Street",null,"Main Street"]
["Howard End",null,"Howard","End",null,null,"End",null,"End "]
["234 Second Ave",null,234,"Second","Ave",null,"Second Ave",null,"Second Ave"]
["Sioux Li",null,"Sioux","Li",null,null,"Li",null,"Li "]
["345 Third Blvd",null,345,"Third","Blvd",null,"Third Blvd",null,"Third Blvd"]
["Hunter Smith Jr",null,"Hunter","Smith","Jr",null,"Smith Jr",null,"Smith Jr"]
["123 Main Street",null,123,"Main","Street",null,"Main Street",null,"Main Street"]
["Howard End",null,"Howard","End",null,null,"End",null,"End "]
["234 Second Ave",null,234,"Second","Ave",null,"Second Ave",null,"Second Ave"]
["Sioux Li",null,"Sioux","Li",null,null,"Li",null,"Li "]
["345 Third Blvd",null,345,"Third","Blvd",null,"Third Blvd",null,"Third Blvd"]
["Hunter Smith Jr",null,"Hunter","Smith","Jr",null,"Smith Jr",null,"Smith Jr"]

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

{"sheet":"Bill2","index":5,"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":6,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data","First Part","Second Part"]
["123 Main Street",{"$f":"LEFT(A2,SEARCH(\" \",A2)-1)","v":"123"},{"$f":"SUBSTITUTE(A2,B2&\" \",\"\")","v":"Main Street"}]
["Howard End",{"$f":"LEFT(A3,SEARCH(\" \",A3)-1)","v":"Howard"},{"$f":"SUBSTITUTE(A3,B3&\" \",\"\")","v":"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":"Wrap Up","index":7,"n_rows":16,"n_cols":2,"rows_kept":16,"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&\" \",\"\")"]