{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["REPLACE","CONCATENATE","MID","TEXT","TEXT LEN REPT","FORMAT","VBA1 ","VBA2"],"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":"REPLACE","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using REPLACE Function"]
[]
[null,"Data","Result"]
[null,133546,{"$f":"REPLACE(B5,4,0,\" \")","v":"133 546"}]
[null,898645,{"$f":"REPLACE(B6,4,0,\" \")","v":"898 645"}]
[null,435298,"435 298"]
[null,774386,"774 386"]
[null,967422,"967 422"]
[null,123456,"123 456"]

{"sheet":"CONCATENATE","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using CONCATENATE Function"]
[]
[null,"Data","Result"]
[null,133546,{"$f":"CONCATENATE(LEFT(B5,3) & \" \" & RIGHT(B5,3))","v":"133 546"}]
[null,898645,{"$f":"CONCATENATE(LEFT(B6,3) & \" \" & RIGHT(B6,3))","v":"898 645"}]
[null,435298,"435 298"]
[null,774389,"774 389"]
[null,967422,"967 422"]
[null,123456,"123 456"]

{"sheet":"MID","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using CONCATENATE & MID Function"]
[]
[null,"Data","Result"]
[null,133546,{"$f":"CONCATENATE(LEFT(B5,2) & \" \"&MID(B5,3,2)&\" \" & RIGHT(B5,2))","v":"13 35 46"}]
[null,898645,{"$f":"CONCATENATE(LEFT(B6,2) & \" \"&MID(B6,3,2)&\" \" & RIGHT(B6,2))","v":"89 86 45"}]
[null,435298,"43 52 98"]
[null,774389,"77 43 89"]
[null,967422,"96 74 22"]
[null,123456,"12 34 56"]

{"sheet":"TEXT","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using TEXT Function"]
[]
[null,"Data","Result",null,"Data","Result"]
[null,133546,{"$f":"TEXT(B5,\"## ## ##\")","v":"13 35 46"},null,133546,{"$f":"TEXT(E5,\"00 00 00\")","v":"13 35 46"}]
[null,898645,{"$f":"TEXT(B6,\"## ## ##\")","v":"89 86 45"},null,898645,{"$f":"TEXT(E6,\"00 00 00\")","v":"89 86 45"}]
[null,435298,"43 52 98",null,435298,"43 52 98"]
[null,774389,"77 43 89",null,774389,"77 43 89"]
[null,967422,"96 74 22",null,967422,"96 74 22"]
[null,123456,"12 34 56",null,123456,"12 34 56"]

{"sheet":"TEXT LEN REPT","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using TEXT, LEN & REPT Functions"]
[]
[null,"Data","Result"]
[null,133546,{"$f":"TEXT(B5,REPT(\"0 \",LEN(B5)))","v":"1 3 3 5 4 6 "}]
[null,898645,{"$f":"TEXT(B6,REPT(\"0 \",LEN(B6)))","v":"8 9 8 6 4 5 "}]
[null,435298,"4 3 5 2 9 8 "]
[null,777438,"7 7 7 4 3 8 "]
[null,967422,"9 6 7 4 2 2 "]
[null,123456,"1 2 3 4 5 6 "]

{"sheet":"FORMAT","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Number Format"]
[]
[null,"Data"]
[null,133546]
[null,898645]
[null,435298]
[null,774388]
[null,967422]
[null,123456]

{"sheet":"VBA1 ","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA Codes"]
[]
[null,"Data"]
[null,"1 3 3 5 4 6"]
[null,"8 9 8 6 4 5"]
[null,"4 3 5 2 9 8"]
[null,"7 7 7 4 3 8"]
[null,"9 6 7 4 2 2"]
[null,"1 2 3 4 5 6"]

{"sheet":"VBA2","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Codes (user's Choice)"]
[]
[null,"Data","Result"]
[null,133546,{"$f":"Space(B5,2)","v":"13 3546"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=Space(B5,2)"}]
[null,898645,{"$f":"Space(B6,3)","v":"898 645"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=Space(B6,3)"}]
[null,435298,{"$f":"Space(B7,4)","v":"4352 98"},"=Space(B7,4)"]
[null,774388,{"$f":"Space(B8,5)","v":"77438 8"},"=Space(B8,5)"]
[null,967422,{"$f":"Space(B9,1)","v":"9 67422"},"=Space(B9,1)"]
[null,123456,{"$f":"Space(B10,2)","v":"12 3456"},"=Space(B10,2)"]