{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Real Dataset","1. Using TRIM","1.2 Using VALUE with TRIM ","2.Using TRIM with SUBSTITUTE","3. Using Find & Replace","Using Left TRIM","Find & Replace for Single Space","Find & Replace Double Space","5.Using VBA","Practice Sheet ","Practice Sheet  (2)"],"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":"1. 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":"1.2 Using VALUE with TRIM ","index":2,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Combination of VALUE & TRIM Functions"]
[]
[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",3100]
[null,"Houston",1201,1201]
[null,"San Antonio","  4321",4321,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(TRIM(C5))","v":2005}]
[null,"Dallas","      4001",4001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(TRIM(C6))","v":3100}]
[null,"Austin","  5001",5001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(TRIM(C7))","v":1201}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(TRIM(C8))","v":4321}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(TRIM(C9))","v":4001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(TRIM(C10))","v":5001}]

{"sheet":"2.Using TRIM with SUBSTITUTE","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Combination of SUBSTITUTE & TRIM Functions"]
[]
[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","Gulliver's Travels by Jonathan Swift"]
[null,"        Clarissa by Samuel Richardson ","Clarissa by Samuel Richardson"]
[null,"     Tom Jones by Henry Fielding ","Tom Jones by Henry Fielding"]
[]
[]
[]
[null,null,null,null,null,"`"]

{"sheet":"3. Using Find & Replace","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,7,0,9]]}
[null,"Use of Find & Replace Tool",null,null,null,null,null,"Practise Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,"First Name","Last Name","Full Name"]
[null," Steve","Jobs",{"$f":"_xlfn.CONCAT(B4,C4)","v":" SteveJobs"},null,null,null," Steve","    Jobs",{"$f":"_xlfn.CONCAT(H4,I4)","v":" Steve    Jobs"}]
[null," Bill","Gates",{"$f":"_xlfn.CONCAT(B5,C5)","v":" BillGates"},null,null,null," Bill","  Gates",{"$f":"_xlfn.CONCAT(H5,I5)","v":" Bill  Gates"}]
[null," Jack ","Ma"," Jack Ma",null,null,null," Jack ","    Ma"," Jack     Ma"]
[null," Richard","Branson"," RichardBranson",null,null,null," Richard","         Branson"," Richard         Branson"]
[null," Walt","Disney"," WaltDisney",null,null,null," Walt"," Disney"," Walt Disney"]
[null," Elon","Musk"," ElonMusk",null,null,null," Elon","  Musk"," Elon  Musk"]
[null," Abraham ","Lincoln"," Abraham Lincoln",null,null,null," Abraham ","  Lincoln"," Abraham   Lincoln"]

{"sheet":"Using Left TRIM","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"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",{"$f":"_xlfn.CONCAT(B6,C6)","v":"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":"Find & Replace for Single Space","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"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":true,"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":"5.Using VBA","index":8,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,5,0,7]]}
[null,"Using VBA to Remove Leading Spaces ",null,null,null,"Practise Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,"First Name","Last Name","Full Name"]
[null,"Steve","Jobs",{"$f":"_xlfn.CONCAT(B4,C4)","v":"SteveJobs"},null,"  Steve","    Jobs",{"$f":"_xlfn.CONCAT(F4,G4)","v":"  Steve    Jobs"}]
[null,"Bill","Gates",{"$f":"_xlfn.CONCAT(B5,C5)","v":"BillGates"},null,"   Bill","  Gates",{"$f":"_xlfn.CONCAT(F5,G5)","v":"   Bill  Gates"}]
[null,"Jack ","Ma","Jack Ma",null,"Jack ","    Ma","Jack     Ma"]
[null,"Richard","Branson","RichardBranson",null,"  Richard","         Branson","  Richard         Branson"]
[null,"Walt","Disney","WaltDisney",null,"   Walt"," Disney","   Walt Disney"]
[null,"Elon","Musk","ElonMusk",null,"    Elon","  Musk","    Elon  Musk"]
[null,"Abraham ","Lincoln","Abraham Lincoln",null,"  Abraham ","  Lincoln","  Abraham   Lincoln"]

{"sheet":"Practice Sheet ","index":9,"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"]

{"sheet":"Practice Sheet  (2)","index":10,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[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"]