{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Add Blank Space","Justified Text","VBA","CONCATENATE","Different Parts","Space Before First Number","Extra Padding"],"not_rendered":{"charts":0,"images":0,"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":"Add Blank Space","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Add Blank Space Using Excel Formula"]
[]
[null,"First Name","Last Name","Full Name","ID No"]
[null,"Walter","White",null,"HIN39821"]
[null,"Jesse ","Pinkman",null,"YIN29719"]
[null,"Hank","Schrader",null,"DIN51801"]
[null,"Mike","Ehrmantraut",null,"BIN18925"]
[null,"Gus","Fring",null,"OIN82719"]
[null,"Sheldon","Cooper",null,"SIN10927"]
[null,"Stuart","Bloom",null,"CIN38012"]
[null,"Rachel","Green",null,"RIN19021"]
[null,"Joey","Tribbiani",null,"FIN289151"]
[null,"Phoebe","Buffay",null,"RIN29810"]

{"sheet":"Justified Text","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Add Trailing Blank Space Using Excel Formula"]
[]
[null,"First Name","Added Space","Last Name","ID No"]
[null,"Walter ",{"$f":"LEFT(B5 & REPT(\" \",10),10)","v":"Walter    "},"White","HIN39821"]
[null,"Jesse ",{"$f":"LEFT(B6 & REPT(\" \",10),10)","v":"Jesse     "},"Pinkman","YIN29719"]
[null,"Hank","Hank      ","Schrader","DIN51801"]
[null,"Mike ","Mike      ","Ehrmantraut","BIN18925"]
[null,"Gus ","Gus       ","Fring","OIN82719"]
[null,"Sheldon","Sheldon   ","Cooper","SIN10927"]
[null,"Stuart","Stuart    ","Bloom","CIN38012"]
[null,"Rachel ","Rachel    ","Green","RIN19021"]
[null,"Joey","Joey      ","Tribbiani","FIN289151"]
[null,"Phoebe","Phoebe    ","Buffay","RIN29810"]

{"sheet":"VBA","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use VBA to Add Blank Space in Excel"]
[]
[null,"First Name","Last Name","Full Name","ID No"]
[null,"Walter","White","Walter White","HIN39821"]
[null,"Jesse","Pinkman","Jesse Pinkman","YIN29719"]
[null,"Hank","Schrader","Hank Schrader","DIN51801"]
[null,"Mike","Ehrmantraut","Mike Ehrmantraut","BIN18925"]
[null,"Gus","Fring","Gus Fring","OIN82719"]
[null,"Sheldon","Cooper","Sheldon Cooper","SIN10927"]
[null,"Stuart","Bloom","Stuart Bloom","CIN38012"]
[null,"Rachel","Green","Rachel Green","RIN19021"]
[null,"Joey","Tribbiani","Joey Tribbiani","FIN289151"]
[null,"Phoebe","Buffay","Phoebe Buffay","RIN29810"]

{"sheet":"CONCATENATE","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Add Blank Space Using Excel CONCATENATE Formula"]
[]
[null,"First Name","Last Name","Full Name","ID No"]
[null,"Walter","White",{"$f":"CONCATENATE(B5, \" \", C5)","v":"Walter White"},"HIN39821"]
[null,"Jesse","Pinkman",{"$f":"CONCATENATE(B6, \" \", C6)","v":"Jesse Pinkman"},"YIN29719"]
[null,"Hank","Schrader","Hank Schrader","DIN51801"]
[null,"Mike","Ehrmantraut","Mike Ehrmantraut","BIN18925"]
[null,"Gus","Fring","Gus Fring","OIN82719"]
[null,"Sheldon","Cooper","Sheldon Cooper","SIN10927"]
[null,"Stuart","Bloom","Stuart Bloom","CIN38012"]
[null,"Rachel","Green","Rachel Green","RIN19021"]
[null,"Joey","Tribbiani","Joey Tribbiani","FIN289151"]
[null,"Phoebe","Buffay","Phoebe Buffay","RIN29810"]

{"sheet":"Different Parts","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Add Space to Separate a Value in Different Parts"]
[]
[null,"First Name","Last Name","ID No","Separated ID No"]
[null,"Walter","White","HIN39821",{"$f":"LEFT(D5,3)& \" \"&RIGHT(D5,5)","v":"HIN 39821"}]
[null,"Jesse ","Pinkman","YIN29719",{"$f":"LEFT(D6,3)& \" \"&RIGHT(D6,5)","v":"YIN 29719"}]
[null,"Hank","Schrader","DIN51801","DIN 51801"]
[null,"Mike","Ehrmantraut","BIN18925","BIN 18925"]
[null,"Gus","Fring","OIN82719","OIN 82719"]
[null,"Sheldon","Cooper","SIN10927","SIN 10927"]
[null,"Stuart","Bloom","CIN38012","CIN 38012"]
[null,"Rachel","Green","RIN19021","RIN 19021"]
[null,"Joey","Tribbiani","FIN289151","FIN 89151"]
[null,"Phoebe","Buffay","RIN29810","RIN 29810"]

{"sheet":"Space Before First Number","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Add Blank Space Before First Number in Excel"]
[]
[null,"First Name","Last Name","ID No","Separated ID No"]
[null,"Walter","White","H82I1N39",{"$f":"TRIM(REPLACE(D5,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D5&\"1234567890\")),0,\" \"))","v":"H 82I1N39"}]
[null,"Jesse ","Pinkman","YI19N297",{"$f":"TRIM(REPLACE(D6,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D6&\"1234567890\")),0,\" \"))","v":"YI 19N297"}]
[null,"Hank","Schrader","DI180N51",{"$f":"TRIM(REPLACE(D7,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D7&\"1234567890\")),0,\" \"))","v":"DI 180N51"}]
[null,"Mike","Ehrmantraut","B5I9N182",{"$f":"TRIM(REPLACE(D8,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D8&\"1234567890\")),0,\" \"))","v":"B 5I9N182"}]
[null,"Gus","Fring","O27I9N81",{"$f":"TRIM(REPLACE(D9,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D9&\"1234567890\")),0,\" \"))","v":"O 27I9N81"}]
[null,"Sheldon","Cooper","S27I109N",{"$f":"TRIM(REPLACE(D10,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D10&\"1234567890\")),0,\" \"))","v":"S 27I109N"}]
[null,"Stuart","Bloom","NC380I12",{"$f":"TRIM(REPLACE(D11,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D11&\"1234567890\")),0,\" \"))","v":"NC 380I12"}]
[null,"Rachel","Green","R1I190N2",{"$f":"TRIM(REPLACE(D12,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D12&\"1234567890\")),0,\" \"))","v":"R 1I190N2"}]
[null,"Joey","Tribbiani","F91I15N28",{"$f":"TRIM(REPLACE(D13,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D13&\"1234567890\")),0,\" \"))","v":"F 91I15N28"}]
[null,"Phoebe","Buffay","RI810N29",{"$f":"TRIM(REPLACE(D14,MIN(FIND({1,2,3,4,5,6,7,8,9,0},D14&\"1234567890\")),0,\" \"))","v":"RI 810N29"}]

{"sheet":"Extra Padding","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Add Space Between Cell Values and Boundaries"]
[]
[null,"First Name","Last Name","Full Name","ID No"]
[null,"Walter","White",{"$f":"CONCATENATE(B5, \" \", C5)","v":"Walter White"},"HIN39821"]
[null,"Jesse ","Pinkman",{"$f":"CONCATENATE(B6, \" \", C6)","v":"Jesse  Pinkman"},"YIN29719"]
[null,"Hank","Schrader","Hank Schrader","DIN51801"]
[null,"Mike","Ehrmantraut","Mike Ehrmantraut","BIN18925"]
[null,"Gus","Fring","Gus Fring","OIN82719"]
[null,"Sheldon","Cooper","Sheldon Cooper","SIN10927"]
[null,"Stuart","Bloom","Stuart Bloom","CIN38012"]
[null,"Rachel","Green","Rachel Green","RIN19021"]
[null,"Joey","Tribbiani","Joey Tribbiani","FIN289151"]
[null,"Phoebe","Buffay","Phoebe Buffay","RIN29810"]