{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Sample Datasheet","TRIM Function","SUBSTITUTE Function","Find and Replace","Delimited Option","Power Query","Power Query Table","VBA Code","Summary","Remove Space Before Number"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Sample Datasheet","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Removing Space After Numbers"]
[]
[null,"Company Name","Product ID","Outcome (Removing Space)"]
[null,"Kaspersky","6589 XCRE"]
[null,"MS Office","2368    PEXJ"]
[null,"WinRAR","45233       UTDCZCX"]
[null,"McAfee","8787     KLPOWQX"]
[null,"Filmora 11","98789        OUYIBKMY"]
[null,"Windows 11","4123243    NBXCTYW"]
[null,"AutoCAD","43456  CFDSA"]

{"sheet":"TRIM Function","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Removing Space After Numbers",null,null,null,null,"For Practice"]
[]
[null,"Company Name","Product ID","Outcome (Removing Space)",null,null,"Company Name","Product ID","Outcome (Removing Space)"]
[null,"Kaspersky","6589 XCRE",{"$f":"TRIM(C6)","v":"6589 XCRE"},null,null,"Kaspersky","6589 XCRE"]
[null,"MS Office","2368    PEXJ",{"$f":"TRIM(C7)","v":"2368 PEXJ"},null,null,"MS Office","2368    PEXJ"]
[null,"WinRAR","45233       UTDCZCX","45233 UTDCZCX",null,null,"WinRAR","45233       UTDCZCX"]
[null,"McAfee","8787     KLPOWQX","8787 KLPOWQX",null,null,"McAfee","8787     KLPOWQX"]
[null,"Filmora 11","98789        OUYIBKMY","98789 OUYIBKMY",null,null,"Filmora 11","98789        OUYIBKMY"]
[null,"Windows 11","4123243    NBXCTYW","4123243 NBXCTYW",null,null,"Windows 11","4123243    NBXCTYW"]
[null,"AutoCAD","43456  CFDSA","43456 CFDSA",null,null,"AutoCAD","43456  CFDSA"]

{"sheet":"SUBSTITUTE Function","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Removing Space After Numbers",null,null,null,null,"For Practice"]
[]
[null,"Company Name","Product ID","Outcome (Removing Space)",null,null,"Company Name","Product ID","Outcome (Removing Space)"]
[null,"Kaspersky","6589 XCRE",{"$f":"SUBSTITUTE(C6,\" \",\"\")","v":"6589XCRE"},null,null,"Kaspersky","6589 XCRE"]
[null,"MS Office","2368    PEXJ",{"$f":"SUBSTITUTE(C7,\" \",\"\")","v":"2368PEXJ"},null,null,"MS Office","2368    PEXJ"]
[null,"WinRAR","45233       UTDCZCX","45233UTDCZCX",null,null,"WinRAR","45233       UTDCZCX"]
[null,"McAfee","8787     KLPOWQX","8787KLPOWQX",null,null,"McAfee","8787     KLPOWQX"]
[null,"Filmora 11","98789        OUYIBKMY","98789OUYIBKMY",null,null,"Filmora 11","98789        OUYIBKMY"]
[null,"Windows 11","4123243    NBXCTYW","4123243NBXCTYW",null,null,"Windows 11","4123243    NBXCTYW"]
[null,"AutoCAD","43456  CFDSA","43456CFDSA",null,null,"AutoCAD","43456  CFDSA"]

{"sheet":"Find and Replace","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Removing Space After Numbers",null,null,null,null,"For Practice"]
[]
[null,"Company Name","Product ID","Outcome (Removing Space)",null,null,"Company Name","Product ID","Outcome (Removing Space)"]
[null,"Kaspersky","6589 XCRE","6589XCRE",null,null,"Kaspersky","6589 XCRE"]
[null,"MS Office","2368    PEXJ","2368PEXJ",null,null,"MS Office","2368    PEXJ"]
[null,"WinRAR","45233       UTDCZCX","45233UTDCZCX",null,null,"WinRAR","45233       UTDCZCX"]
[null,"McAfee","8787     KLPOWQX","8787KLPOWQX",null,null,"McAfee","8787     KLPOWQX"]
[null,"Filmora 11","98789        OUYIBKMY","98789OUYIBKMY",null,null,"Filmora 11","98789        OUYIBKMY"]
[null,"Windows 11","4123243    NBXCTYW","4123243NBXCTYW",null,null,"Windows 11","4123243    NBXCTYW"]
[null,"AutoCAD","43456  CFDSA","43456CFDSA",null,null,"AutoCAD","43456  CFDSA"]

{"sheet":"Delimited Option","index":4,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,5,2,6],[4,2,4,3],[2,1,2,3]]}
[]
[]
[null,"Removing Space After Numbers",null,null,null,"For Practice"]
[]
[null,"Company Name","Product ID",null,null,"Company Name","Product ID"]
[null,"Kaspersky",6589,"XCRE",null,"Kaspersky","6589 XCRE"]
[null,"MS Office",2368,"PEXJ",null,"MS Office","2368    PEXJ"]
[null,"WinRAR",45233,"UTDCZCX",null,"WinRAR","45233       UTDCZCX"]
[null,"McAfee",8787,"KLPOWQX",null,"McAfee","8787     KLPOWQX"]
[null,"Filmora 11",98789,"OUYIBKMY",null,"Filmora 11","98789        OUYIBKMY"]
[null,"Windows 11",4123243,"NBXCTYW",null,"Windows 11","4123243    NBXCTYW"]
[null,"AutoCAD",43456,"CFDSA",null,"AutoCAD","43456  CFDSA"]

{"sheet":"Power Query","index":5,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Removing Space After Numbers",null,null,null,"For Practice"]
[]
[null,"Company Name","Product ID ",null,null,"Company Name","Product ID"]
[null,"Kaspersky","6589 XCRE",null,null,"Kaspersky","6589 XCRE"]
[null,"MS Office","2368    PEXJ",null,null,"MS Office","2368    PEXJ"]
[null,"WinRAR","45233       UTDCZCX",null,null,"WinRAR","45233       UTDCZCX"]
[null,"McAfee","8787     KLPOWQX",null,null,"McAfee","8787     KLPOWQX"]
[null,"Filmora 11","98789        OUYIBKMY",null,null,"Filmora 11","98789        OUYIBKMY"]
[null,"Windows 11","4123243    NBXCTYW",null,null,"Windows 11","4123243    NBXCTYW"]
[null,"AutoCAD","43456  CFDSA",null,null,"AutoCAD","43456  CFDSA"]

{"sheet":"Power Query Table","index":6,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Company Name","Product ID (With Space)"]
["Kaspersky","6589XCRE"]
["MS Office","2368PEXJ"]
["WinRAR","45233UTDCZCX"]
["McAfee","8787KLPOWQX"]
["Filmora 11","98789OUYIBKMY"]
["Windows 11","4123243NBXCTYW"]
["AutoCAD","43456CFDSA"]

{"sheet":"VBA Code","index":7,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Removing Space After Numbers",null,null,null,"For Practice"]
[]
[null,"Company Name","Product ID",null,null,"Company Name","Product ID"]
[null,"Kaspersky","6589XCRE",null,null,"Kaspersky","6589 XCRE"]
[null,"MS Office","2368PEXJ",null,null,"MS Office","2368    PEXJ"]
[null,"WinRAR","45233UTDCZCX",null,null,"WinRAR","45233       UTDCZCX"]
[null,"McAfee","8787KLPOWQX",null,null,"McAfee","8787     KLPOWQX"]
[null,"Filmora 11","98789OUYIBKMY",null,null,"Filmora 11","98789        OUYIBKMY"]
[null,"Windows 11","4123243NBXCTYW",null,null,"Windows 11","4123243    NBXCTYW"]
[null,"AutoCAD","43456CFDSA",null,null,"AutoCAD","43456  CFDSA"]

{"sheet":"Summary","index":8,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,2,20,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[19,2,19,3],[10,2,10,4],[11,2,11,4],[2,1,2,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4]]}
[]
[]
[null,"Removing Space After Numbers"]
[]
[null,"Company Name","Product ID "]
[null,"Kaspersky","6589 XCRE"]
[null,"MS Office","2368    PEXJ"]
[null,"WinRAR","45233       UTDCZCX"]
[null,"McAfee","8787     KLPOWQX"]
[null,"Filmora 11","98789        OUYIBKMY"]
[null,"Windows 11","4123243    NBXCTYW"]
[null,"AutoCAD","43456  CFDSA"]
[]
[]
[null,"Method","Outcome (Removing Space)",null,"Formula"]
[null,"TRIM Function",{"$f":"TRIM(C6)","v":"6589 XCRE"},null,{"$f":"_xlfn.FORMULATEXT(C16)","v":"=TRIM(C6)"}]
[null,"SUBSTITUTE Function",{"$f":"SUBSTITUTE(C6,\" \",\"\")","v":"6589XCRE"},null,{"$f":"_xlfn.FORMULATEXT(C17)","v":"=SUBSTITUTE(C6,\" \",\"\")"}]
[null,"Find and Replace Option","6589XCRE"]
[null,"Delimited Option",6589,"XCRE"]
[null,"Power Query","6589XCRE"]
[null,"VBA Code","6589XCRE"]

{"sheet":"Remove Space Before Number","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Removing Space Before Numbers"]
[]
[null,"Company Name","Product ID","Outcome (Removing Space)"]
[null,"Kaspersky","      6589 XCRE",{"$f":"SUBSTITUTE(C6,\" \",\"\")","v":"6589XCRE"}]
[null,"MS Office","          2368PEXJ",{"$f":"SUBSTITUTE(C7,\" \",\"\")","v":"2368PEXJ"}]
[null,"WinRAR","    45233UTDCZCX","45233UTDCZCX"]
[null,"McAfee","          8787KLPOWQX","8787KLPOWQX"]
[null,"Filmora 11","        98789OUYIBKMY","98789OUYIBKMY"]
[null,"Windows 11","    4123243NBXCTYW","4123243NBXCTYW"]
[null,"AutoCAD","        43456 CFDSA","43456CFDSA"]