{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Right","Replace","VBA_Left_Trim","RIGHT_LEN","FIND_MID_TRIM_LEN","REPLACE, FIND, LEFT & TRIM","VBA_Leading Space"],"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":"Right","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of  Right Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code","Color",null,null,null,null,null,null,null,"Code","Color"]
[null,"123ABCBlue",{"$f":"RIGHT(B5,4)","v":"Blue"},null,null,null,null,null,null,null,"123ABCBlue"]
[null,"678FGHBGrey",{"$f":"RIGHT(B6,4)","v":"Grey"},null,null,null,null,null,null,null,"678FGHBGrey"]
[null,"789GYJPink","Pink",null,null,null,null,null,null,null,"789GYJPink"]

{"sheet":"Replace","index":1,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of  Replace Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code","Number to Trim","Color",null,null,null,null,null,null,"Code","Number to Trim","Color"]
[null,"123ABCBlue",6,{"$f":"REPLACE(B5,1,C5,\"\")","v":"Blue"},null,null,null,null,null,null,"123ABCBlue",6]
[null,"678FGHBGrey",3,{"$f":"REPLACE(B6,1,C6,\"\")","v":"FGHBGrey"},null,null,null,null,null,null,"678FGHBGrey",3]
[null,"789GYJPink",2,"9GYJPink",null,null,null,null,null,null,"789GYJPink",2]

{"sheet":"VBA_Left_Trim","index":2,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use VBA to Left Trim",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code",null,null,null,null,null,null,null,"Code"]
[null,"3PastelBlue",null,null,null,null,null,null,null,"3PasteBlue"]

{"sheet":"RIGHT_LEN","index":3,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Combination of RIGHT & LEN Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code","Number to Trim","Color",null,null,null,null,null,null,"Code","Number to Trim","Color"]
[null,"123ABCYellow",6,{"$f":"RIGHT(B5,LEN(B5)-C5)","v":"Yellow"},null,null,null,null,null,null,"123ABCYellow",6]
[null,"678FGHBGrey",3,{"$f":"RIGHT(B6,LEN(B6)-C6)","v":"FGHBGrey"},null,null,null,null,null,null,"678FGHBGrey",3]
[null,"789GYJPink",2,"9GYJPink",null,null,null,null,null,null,"789GYJPink",2]

{"sheet":"FIND_MID_TRIM_LEN","index":4,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use FIND, MID, TRIM & LEN Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code","Result",null,null,null,null,null,null,null,"Code","Result"]
[null,"         123ABC   Blue",{"$f":"MID(B5,FIND(MID(TRIM(B5),1,1),B5),LEN(B5))","v":"123ABC   Blue"},null,null,null,null,null,null,null,"         123ABC   Blue"]

{"sheet":"REPLACE, FIND, LEFT & TRIM","index":5,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use REPLACE, FIND, LEFT & TRIM Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code","Result",null,null,null,null,null,null,null,"Code","Result"]
[null,"         123ABC   Blue",{"$f":"REPLACE(B5,1,FIND(LEFT(TRIM(B5),2),B5)-1,\"\")","v":"123ABC   Blue"},null,null,null,null,null,null,null,"         123ABC   Blue"]

{"sheet":"VBA_Leading Space","index":6,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use VBA to Remove Leading Space",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Text",null,null,null,null,null,null,null,null,"Text"]
[null,"100 years of Solitude",null,null,null,null,null,null,null,null,"    100 years of Solitude"]
[null,"And the Mountain Echoes",null,null,null,null,null,null,null,null,"              And the Mountain Echoes"]