{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["TRIM Function","Find & Replace Tool","Removing Line Breaks"," Removing Non-Breaking Spaces","Removing All Spaces","Removing Leading Spaces","Erase Leading Space with VBA","Erase Trailing Space with VBA","Removing Certain Space","Use of Power Query","Outpur of Power Query"],"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":"TRIM Function","index":0,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of TRIM Function",null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Text","Output",null,null,null,null,null,null,"Text","Output"]
[null,"  Have a   nice      day",{"$f":"TRIM(B5)","v":"Have a nice day"},null,null,null,null,null,null,"  Have a   nice      day"]
[null,"Have a  nice         day  ",{"$f":"TRIM(B6)","v":"Have a nice day"},null,null,null,null,null,null,"Have a  nice         day  "]
[null,"        Have a nice            day","Have a nice day",null,null,null,null,null,null,"        Have a nice            day"]

{"sheet":"Find & Replace Tool","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Find and Replace Tool",null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Text",null,null,null,null,null,null,"Text"]
[null," Have a nice day.",null,null,null,null,null,null,"         Have                      a nice day."]
[null,"Good morning, Alex!",null,null,null,null,null,null,"Good             morning,          Alex!"]
[null," Germany won the 5th title.",null,null,null,null,null,null,"                                 Germany won the 5th           title."]

{"sheet":"Removing Line Breaks","index":2,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Removing Extra Spaces & Line Breaks",null,null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Text","Output",null,null,null,null,null,null,null,"Text","Output"]
[null,{"$f":"\"Have a      nice\"&CHAR(10)&\"             day\"","v":"Have a      nice\n             day"},{"$f":"TRIM(CLEAN(B5))","v":"Have a nice day"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TRIM(CLEAN(B5))"},null,null,null,null,null,null,{"$f":"\"Have a      nice\"&CHAR(10)&\"             day\"","v":"Have a      nice\n             day"}]
[null,"    Good          morning,\n                          Alex",{"$f":"TRIM(CLEAN(B6))","v":"Good morning, Alex"},null,null,null,null,null,null,null,"    Good          morning,\n                          Alex"]
[null,"Germany won               the\n5th title","Germany won the5th title",null,null,null,null,null,null,null,"Germany won               the\n5th title"]

{"sheet":" Removing Non-Breaking Spaces","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Removal of Non-Breaking Spaces",null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Text","Output",null,null,null,null,null,null,"Text","Output"]
[null,{"$f":"\"  Brendon  \"&CHAR(160)&CHAR(160)&CHAR(160)&CHAR(160)&CHAR(10)&\"   Rodgers  \"","v":"  Brendon      \n   Rodgers  "},{"$f":"TRIM(CLEAN((SUBSTITUTE(B5,CHAR(160),\" \"))))","v":"Brendon Rodgers"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TRIM(CLEAN((SUBSTITUTE(B5,CHAR(160),\" \"))))"},null,null,null,null,null,{"$f":"\"  Brendon  \"&CHAR(160)&CHAR(160)&CHAR(160)&CHAR(160)&CHAR(10)&\"   Rodgers  \"","v":"  Brendon      \n   Rodgers  "}]
[null,{"$f":"\"  Jurgen  \"&CHAR(160)&CHAR(160)&CHAR(160)&\"   Klopp  \"","v":"  Jurgen        Klopp  "},{"$f":"TRIM(CLEAN((SUBSTITUTE(B6,CHAR(160),\" \"))))","v":"Jurgen Klopp"},null,null,null,null,null,null,{"$f":"\"  Jurgen  \"&CHAR(160)&CHAR(160)&CHAR(160)&\"   Klopp  \"","v":"  Jurgen        Klopp  "}]
[null,{"$f":"\"  Hans  \"&CHAR(160)&CHAR(160)&CHAR(160)&\"   Flick  \"","v":"  Hans        Flick  "},"Hans Flick",null,null,null,null,null,null,{"$f":"\"  Hans  \"&CHAR(160)&CHAR(160)&CHAR(160)&\"   Flick  \"","v":"  Hans        Flick  "}]

{"sheet":"Removing All Spaces","index":4,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Removing All Sapces",null,null,null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Text","Output",null,null,null,null,null,null,null,null,"Text","Output"]
[null,"   Adam    Milne    ",{"$f":"SUBSTITUTE(B5,\" \",\"\")","v":"AdamMilne"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=SUBSTITUTE(B5,\" \",\"\")"},null,null,null,null,null,null,null,"   Adam    Milne    "]
[null,"46 EK 3 L 09 HJ",{"$f":"SUBSTITUTE(B6,\" \",\"\")","v":"46EK3L09HJ"},null,null,null,null,null,null,null,null,"46 EK 3 L 09 HJ"]
[null,"9 000 000 000","9000000000",null,null,null,null,null,null,null,null,"9 000 000 000"]

{"sheet":"Removing Leading Spaces","index":5,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Removal of Leading Sapces",null,null,null,null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Text","Output",null,null,null,null,null,null,null,null,null,"Text","Output"]
[null,"          Adam Milne",{"$f":"MID(B5,FIND(MID(TRIM(B5),1,1),B5),LEN(B5))","v":"Adam Milne"},"=MID(B5,FIND(MID(TRIM(B5),1,1),B5),LEN(B5))",null,null,null,null,null,null,null,null,"          Adam Milne"]
[null," Kyle Jamieson",{"$f":"MID(B6,FIND(MID(TRIM(B6),1,1),B6),LEN(B6))","v":"Kyle Jamieson"},null,null,null,null,null,null,null,null,null," Kyle Jamieson"]
[null,"                 Henry Nicholls","Henry Nicholls",null,null,null,null,null,null,null,null,null,"                 Henry Nicholls"]

{"sheet":"Erase Leading Space with VBA","index":6,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removal of Leading Sapces with VBA",null,null,null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Text",null,null,null,null,null,null,null,null,null,"Text"]
[null,"Adam Milne",null,null,null,null,null,null,null,null,null,"          Adam Milne"]
[null,"Kyle Jamieson",null,null,null,null,null,null,null,null,null," Kyle Jamieson"]
[null,"Henry Nicholls",null,null,null,null,null,null,null,null,null,"                 Henry Nicholls"]

{"sheet":"Erase Trailing Space with VBA","index":7,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removal of Leading Sapces with VBA",null,null,null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Text",null,null,null,null,null,null,null,null,null,"Text"]
[null,"Adam Milne",null,null,null,null,null,null,null,null,null,"Adam Milne                "]
[null,"Kyle Jamieson",null,null,null,null,null,null,null,null,null,"Kyle Jamieson           "]
[null,"Henry Nicholls",null,null,null,null,null,null,null,null,null,"Henry Nicholls                "]

{"sheet":"Removing Certain Space","index":8,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Removing Specific Space",null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Text","Output",null,null,null,null,null,null,"Text","Output"]
[null,"Thomas Muller , Bayern Munchen",{"$f":"SUBSTITUTE(B5,\" \",\"\",2)","v":"Thomas Muller, Bayern Munchen"},null,null,null,null,null,null,"Thomas Muller , Bayern Munchen"]
[null,"Florean Neuhaus , Monchengladbach",{"$f":"SUBSTITUTE(B6,\" \",\"\",2)","v":"Florean Neuhaus, Monchengladbach"},null,null,null,null,null,null,"Florean Neuhaus , Monchengladbach"]
[null,"Antonio Rudiger , Chelsea","Antonio Rudiger, Chelsea",null,null,null,null,null,null,"Antonio Rudiger , Chelsea"]

{"sheet":"Use of Power Query","index":9,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removal of Extra Spaces with Power Query"]
[]
[null,"Name","Email Address"]
[null,"Patrick","               patrick96       @gmail.     com"]
[null,"Allan","allan .wilshere @ yahoo.com"]
[null,"Kate","      kate32@           outlook           .com"]

{"sheet":"Outpur of Power Query","index":10,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Name","Email Address"]
["Patrick","patrick96@gmail.com"]
["Allan","allan.wilshere@yahoo.com"]
["Kate","kate32@outlook.com"]