{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Real Dataset","Using TRIM","Using TRIM with SUBSTITUTE","Using Left TRIM","Using VALUE with TRIM ","Using Find & Replace","Find & Replace for Single Space","Find & Replace Double Space","Using VBA","Practice Sheet  (2)","Practice Sheet "],"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":"Real Dataset","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Remove Leading Spaces in Excel"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"  Steve","    Jobs",{"$f":"_xlfn.CONCAT(B4,C4)","v":"  Steve    Jobs"}]
[null,"   Bill","  Gates",{"$f":"_xlfn.CONCAT(B5,C5)","v":"   Bill  Gates"}]
[null,"Jack ","    Ma","Jack     Ma"]
[null,"  Richard","         Branson","  Richard         Branson"]
[null,"   Walt"," Disney","   Walt Disney"]
[null,"    Elon","  Musk","    Elon  Musk"]
[null,"  Abraham ","  Lincoln","  Abraham   Lincoln"]

{"sheet":"Using TRIM","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using TRIM to Remove Leading Spaces "]
[]
[null,"First Name","Last Name","Full Name","Removed Spaces"]
[null,"  Steve","    Jobs",{"$f":"_xlfn.CONCAT(B4,C4)","v":"  Steve    Jobs"},{"$f":"'Using Left TRIM'!E4","v":"Steve    Jobs"}]
[null,"   Bill","  Gates",{"$f":"_xlfn.CONCAT(B5,C5)","v":"   Bill  Gates"},{"$f":"TRIM(D5)","v":"Bill Gates"}]
[null,"Jack ","    Ma","Jack     Ma","Jack Ma"]
[null,"  Richard","       Branson","  Richard       Branson","Richard Branson"]
[null,"   Walt"," Disney","   Walt Disney","Walt Disney"]
[null,"    Elon","  Musk","    Elon  Musk","Elon Musk"]
[null,"  Abraham ","  Lincoln","  Abraham   Lincoln","Abraham Lincoln"]

{"sheet":"Using TRIM with SUBSTITUTE","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Using TRIM with SUBSTITUTE to Remove Leading Spaces "]
[]
[null,"Book with Author Name","Removed Spaces"]
[null,"       The Pilgrim's Progress by John Bunyan ",{"$f":"TRIM(SUBSTITUTE(B4, CHAR(160), \"\"))","v":"The Pilgrim's Progress by John Bunyan"}]
[null,"           Robinson Crusoe by Daniel Defoe ",{"$f":"TRIM(SUBSTITUTE(B5, CHAR(160), \"\"))","v":"Robinson Crusoe by Daniel Defoe"}]
[null,"   Gulliver's Travels by Jonathan Swift",{"$f":"TRIM(SUBSTITUTE(B6, CHAR(160), \"\"))","v":"Gulliver's Travels by Jonathan Swift"}]
[null,"        Clarissa by Samuel Richardson ",{"$f":"TRIM(SUBSTITUTE(B7, CHAR(160), \"\"))","v":"Clarissa by Samuel Richardson"}]
[null,"     Tom Jones by Henry Fielding ",{"$f":"TRIM(SUBSTITUTE(B8, CHAR(160), \"\"))","v":"Tom Jones by Henry Fielding"}]

{"sheet":"Using Left TRIM","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Left TRIM to Remove Leading Spaces "]
[]
[null,"First Name","Last Name","Full Name","Removed Spaces"]
[null,"  Steve","    Jobs",{"$f":"_xlfn.CONCAT(B4,C4)","v":"  Steve    Jobs"},{"$f":"MID(D4,FIND(MID(TRIM(D4),1,1),D4),LEN(D4))","v":"Steve    Jobs"}]
[null,"   Bill","  Gates",{"$f":"_xlfn.CONCAT(B5,C5)","v":"   Bill  Gates"},{"$f":"MID(D5,FIND(MID(TRIM(D5),1,1),D5),LEN(D5))","v":"Bill  Gates"}]
[null,"Jack ","    Ma","Jack     Ma","Jack     Ma"]
[null,"  Richard","       Branson","  Richard       Branson","Richard       Branson"]
[null,"   Walt"," Disney","   Walt Disney","Walt Disney"]
[null,"    Elon","  Musk","    Elon  Musk","Elon  Musk"]
[null,"  Abraham ","  Lincoln","  Abraham   Lincoln","Abraham   Lincoln"]

{"sheet":"Using VALUE with TRIM ","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Using VALUE within TRIM to Remove Leading Spaces "]
[]
[null,"City Name ","ZIP Code","Removed Spaces"]
[null,"New York","    1001",{"$f":"VALUE(TRIM(C4))","v":1001}]
[null,"Los Angeles","   2005",{"$f":"VALUE(TRIM(C5))","v":2005}]
[null,"Chicago","      3100",{"$f":"VALUE(TRIM(C6))","v":3100}]
[null,"Houston",1201,{"$f":"VALUE(TRIM(C7))","v":1201}]
[null,"San Antonio","  4321",{"$f":"VALUE(TRIM(C8))","v":4321}]
[null,"Dallas","      4001",{"$f":"VALUE(TRIM(C9))","v":4001}]
[null,"Austin","  5001",{"$f":"VALUE(TRIM(C10))","v":5001}]

{"sheet":"Using Find & Replace","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Using FIND & REPLACE to Remove Leading Spaces "]
[]
[null,"First Name","Last Name","Full Name"]
[null," Steve","    Jobs",{"$f":"_xlfn.CONCAT(B4,C4)","v":" Steve    Jobs"}]
[null," Bill","  Gates",{"$f":"_xlfn.CONCAT(B5,C5)","v":" Bill  Gates"}]
[null,"Jack ","    Ma","Jack     Ma"]
[null," Richard","         Branson"," Richard         Branson"]
[null," Walt"," Disney"," Walt Disney"]
[null," Elon","  Musk"," Elon  Musk"]
[null," Abraham ","  Lincoln"," Abraham   Lincoln"]

{"sheet":"Find & Replace for Single Space","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Using FIND & REPLACE to Remove Leading Spaces "]
[]
[null,"First Name","Last Name","Full Name"]
[null,"  Steve","Jobs",{"$f":"_xlfn.CONCAT(B4,C4)","v":"  SteveJobs"}]
[null,"   Bill","Gates",{"$f":"_xlfn.CONCAT(B5,C5)","v":"   BillGates"}]
[null,"Jack ","Ma","Jack Ma"]
[null,"  Richard","Branson","  RichardBranson"]
[null,"   Walt","Disney","   WaltDisney"]
[null,"    Elon","Musk","    ElonMusk"]
[null,"  Abraham ","Lincoln","  Abraham Lincoln"]

{"sheet":"Find & Replace Double Space","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Using FIND & REPLACE to Remove Leading Spaces "]
[]
[null,"First Name","Last Name","Full Name"]
[null,"  Steve","  Jobs",{"$f":"_xlfn.CONCAT(B4,C4)","v":"  Steve  Jobs"}]
[null,"   Bill"," Gates",{"$f":"_xlfn.CONCAT(B5,C5)","v":"   Bill Gates"}]
[null,"Jack ","  Ma","Jack   Ma"]
[null,"  Richard","     Branson","  Richard     Branson"]
[null,"   Walt"," Disney","   Walt Disney"]
[null,"    Elon"," Musk","    Elon Musk"]
[null,"  Abraham "," Lincoln","  Abraham  Lincoln"]

{"sheet":"Using VBA","index":8,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using VBA to Remove Leading Spaces "]
[]
[null,"First Name","Last Name","Full Name"]
[null,"  Steve","Jobs","Steve    Jobs"]
[null,"   Bill","Gates","Bill  Gates"]
[null,"Jack ","Ma","Jack     Ma"]
[null,"  Richard","Branson","Richard         Branson"]
[null,"   Walt","Disney","Walt Disney"]
[null,"    Elon","Musk","Elon  Musk"]
[null,"  Abraham ","Lincoln","Abraham   Lincoln"]

{"sheet":"Practice Sheet  (2)","index":9,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Do it YourSelf"]
[]
[null,"City Name ","ZIP Code","Removed Spaces"]
[null,"New York","    1001"]
[null,"Los Angeles","   2005"]
[null,"Chicago","      3100"]
[null,"Houston",1201]
[null,"San Antonio","  4321"]
[null,"Dallas","      4001"]
[null,"Austin","  5001"]

{"sheet":"Practice Sheet ","index":10,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Do it YourSelf"]
[]
[null,"First Name","Last Name","Full Name","Removed Spaces"]
[null,"  Steve","    Jobs",{"$f":"_xlfn.CONCAT(B4,C4)","v":"  Steve    Jobs"}]
[null,"   Bill","  Gates",{"$f":"_xlfn.CONCAT(B5,C5)","v":"   Bill  Gates"}]
[null,"Jack ","    Ma","Jack     Ma"]
[null,"  Richard","       Branson","  Richard       Branson"]
[null,"   Walt"," Disney","   Walt Disney"]
[null,"    Elon","  Musk","    Elon  Musk"]
[null,"  Abraham ","  Lincoln","  Abraham   Lincoln"]