{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Using Ampersand","TODAY Function and Ampersand","Line Break Between Two Formulas","Using CONCAT Function","Using CONCATENATE Function","TEXTJOIN Function","Using VBA Macros","Using Flash Fill","LEFT and MID Function","REPLACE Function"],"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":"Dataset","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sample Dataset"]
[]
[null,"First Name","Last Name","January","February","March ","Total Expenses "]
[null,"Wade ","Harris",2500,78,6000]
[null,"Dave","Walker",1400,1245,477]
[null,"Paul","Shelton",1450,17,455]
[null,"Lucy","Wood",1700,1800,147]
[null,"Sabrina","Roberts",1900,2200,255]
[null,"Miles","Dudley",5000,3000,177]
[null,"Brian","Sheppard",4500,1430,478]

{"sheet":"Using Ampersand","index":1,"n_rows":11,"n_cols":18,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Using Ampersand Operator to Add a Text Before a Formula",null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","January","February","March ","Total Expenses ",null,null,null,null,null,"First Name","Last Name","January","February","March ","Total Expenses "]
[null,"Wade ","Harris",2500,78,6000,{"$f":"\"The Total Expenses of \"&B5&C5&\" is \"&\"$\"&SUM(D5,E5,F5)","v":"The Total Expenses of Wade Harris is $8578"},null,null,null,null,null,"Wade ","Harris",2500,78,6000]
[null,"Dave","Walker",1400,1245,477,{"$f":"\"The Total Expenses of \"&B6&C6&\" is \"&\"$\"&SUM(D6,E6,F6)","v":"The Total Expenses of DaveWalker is $3122"},null,null,null,null,null,"Dave","Walker",1400,1245,477]
[null,"Paul","Shelton",1450,17,455,"The Total Expenses of PaulShelton is $1922",null,null,null,null,null,"Paul","Shelton",1450,17,455]
[null,"Lucy","Wood",1700,1800,147,"The Total Expenses of LucyWood is $3647",null,null,null,null,null,"Lucy","Wood",1700,1800,147]
[null,"Sabrina","Roberts",1900,2200,255,"The Total Expenses of SabrinaRoberts is $4355",null,null,null,null,null,"Sabrina","Roberts",1900,2200,255]
[null,"Miles","Dudley",5000,3000,177,"The Total Expenses of MilesDudley is $8177",null,null,null,null,null,"Miles","Dudley",5000,3000,177]
[null,"Brian","Sheppard",4500,1430,478,"The Total Expenses of BrianSheppard is $6408",null,null,null,null,null,"Brian","Sheppard",4500,1430,478]

{"sheet":"TODAY Function and Ampersand","index":2,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using TODAY Function and Ampersand",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","January","February","March ","Total Expenses ",null,null,null,null,"First Name","Last Name","January","February","March ","Total Expenses "]
[null,"Wade ","Harris",2500,78,6000,{"$f":"TEXT(TODAY(), \"mmmm dd, yyyy\")&\" Expenses is $\"&SUM(D5,E5,F5)","v":"October 19, 2022 Expenses is $8578"},null,null,null,null,"Wade ","Harris",2500,78,6000]
[null,"Dave","Walker",1400,1245,477,{"$f":"TEXT(TODAY(), \"mmmm dd, yyyy\")&\" Expenses is $\"&SUM(D6,E6,F6)","v":"October 19, 2022 Expenses is $3122"},null,null,null,null,"Dave","Walker",1400,1245,477]
[null,"Paul","Shelton",1450,17,455,"October 19, 2022 Expenses is $1922",null,null,null,null,"Paul","Shelton",1450,17,455]
[null,"Lucy","Wood",1700,1800,147,"October 19, 2022 Expenses is $3647",null,null,null,null,"Lucy","Wood",1700,1800,147]
[null,"Sabrina","Roberts",1900,2200,255,"October 19, 2022 Expenses is $4355",null,null,null,null,"Sabrina","Roberts",1900,2200,255]
[null,"Miles","Dudley",5000,3000,177,"October 19, 2022 Expenses is $8177",null,null,null,null,"Miles","Dudley",5000,3000,177]
[null,"Brian","Sheppard",4500,1430,478,"October 19, 2022 Expenses is $6408",null,null,null,null,"Brian","Sheppard",4500,1430,478]

{"sheet":"Line Break Between Two Formulas","index":3,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Adding Line Break Between Two Formulas",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","January","February","March ","Total Expenses ",null,null,null,null,"First Name","Last Name","January","February","March ","Total Expenses "]
[null,"Wade ","Harris",2500,78,6000,{"$f":"TEXT(TODAY(), \"mmmm dd, yyyy\")&CHAR(10)&\" Expenses is $\"&SUM(D5,E5,F5)","v":"October 19, 2022\n Expenses is $8578"},null,null,null,null,"Wade ","Harris",2500,78,6000]
[null,"Dave","Walker",1400,1245,477,{"$f":"TEXT(TODAY(), \"mmmm dd, yyyy\")&CHAR(10)&\" Expenses is $\"&SUM(D6,E6,F6)","v":"October 19, 2022\n Expenses is $3122"},null,null,null,null,"Dave","Walker",1400,1245,477]
[null,"Paul","Shelton",1450,17,455,"October 19, 2022\n Expenses is $1922",null,null,null,null,"Paul","Shelton",1450,17,455]
[null,"Lucy","Wood",1700,1800,147,"October 19, 2022\n Expenses is $3647",null,null,null,null,"Lucy","Wood",1700,1800,147]
[null,"Sabrina","Roberts",1900,2200,255,"October 19, 2022\n Expenses is $4355",null,null,null,null,"Sabrina","Roberts",1900,2200,255]
[null,"Miles","Dudley",5000,3000,177,"October 19, 2022\n Expenses is $8177",null,null,null,null,"Miles","Dudley",5000,3000,177]
[null,"Brian","Sheppard",4500,1430,478,"October 19, 2022\n Expenses is $6408",null,null,null,null,"Brian","Sheppard",4500,1430,478]

{"sheet":"Using CONCAT Function","index":4,"n_rows":11,"n_cols":18,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Using CONCAT Function to Add Text in a Formula",null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","January","February","March ","Total Expenses ",null,null,null,null,null,"First Name","Last Name","January","February","March ","Total Expenses "]
[null,"Wade ","Harris",2500,78,6000,{"$f":"_xlfn.CONCAT(\"The Total Expenses of \",B5, C5,\" is $\",SUM(D5,E5,F5))","v":"The Total Expenses of Wade Harris is $8578"},null,null,null,null,null,"Wade ","Harris",2500,78,6000]
[null,"Dave","Walker",1400,1245,477,{"$f":"_xlfn.CONCAT(\"The Total Expenses of \",B6, C6,\" is $\",SUM(D6,E6,F6))","v":"The Total Expenses of DaveWalker is $3122"},null,null,null,null,null,"Dave","Walker",1400,1245,477]
[null,"Paul","Shelton",1450,17,455,"The Total Expenses of PaulShelton is $1922",null,null,null,null,null,"Paul","Shelton",1450,17,455]
[null,"Lucy","Wood",1700,1800,147,"The Total Expenses of LucyWood is $3647",null,null,null,null,null,"Lucy","Wood",1700,1800,147]
[null,"Sabrina","Roberts",1900,2200,255,"The Total Expenses of SabrinaRoberts is $4355",null,null,null,null,null,"Sabrina","Roberts",1900,2200,255]
[null,"Miles","Dudley",5000,3000,177,"The Total Expenses of MilesDudley is $8177",null,null,null,null,null,"Miles","Dudley",5000,3000,177]
[null,"Brian","Sheppard",4500,1430,478,"The Total Expenses of BrianSheppard is $6408",null,null,null,null,null,"Brian","Sheppard",4500,1430,478]

{"sheet":"Using CONCATENATE Function","index":5,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using CONCATENATE Function to Add Text in a Formula",null,null,null,null,null,null," ",null,null,"Practice Section"]
[]
[null,"First Name","Last Name","January","February","March ","Total Expenses ",null,null,null,null,"First Name","Last Name","January","February","March ","Total Expenses "]
[null,"Wade ","Harris",2500,78,6000,{"$f":"CONCATENATE(\"The Total Expenses of \",B5, C5,\" is $\",SUM(D5,E5,F5))","v":"The Total Expenses of Wade Harris is $8578"},null,null,null,null,"Wade ","Harris",2500,78,6000]
[null,"Dave","Walker",1400,1245,477,{"$f":"CONCATENATE(\"The Total Expenses of \",B6, C6,\" is $\",SUM(D6,E6,F6))","v":"The Total Expenses of DaveWalker is $3122"},null,null,null,null,"Dave","Walker",1400,1245,477]
[null,"Paul","Shelton",1450,17,455,"The Total Expenses of PaulShelton is $1922",null,null,null,null,"Paul","Shelton",1450,17,455]
[null,"Lucy","Wood",1700,1800,147,"The Total Expenses of LucyWood is $3647",null,null,null,null,"Lucy","Wood",1700,1800,147]
[null,"Sabrina","Roberts",1900,2200,255,"The Total Expenses of SabrinaRoberts is $4355",null,null,null,null,"Sabrina","Roberts",1900,2200,255]
[null,"Miles","Dudley",5000,3000,177,"The Total Expenses of MilesDudley is $8177",null,null,null,null,"Miles","Dudley",5000,3000,177]
[null,"Brian","Sheppard",4500,1430,478,"The Total Expenses of BrianSheppard is $6408",null,null,null,null,"Brian","Sheppard",4500,1430,478]

{"sheet":"TEXTJOIN Function","index":6,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Adding Text before a Formula by TEXTJOIN function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","January","February","March ","Total Expenses ",null,null,null,"First Name","Last Name","January","February","March ","Total Expenses "]
[null,"Wade ","Harris",2500,78,6000,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,\"The Total Expenses of \",B5,C5,\" is $\",SUM(D5,E5,F5))","v":"The Total Expenses of Wade Harris is $8578"},null,null,null,"Wade ","Harris",2500,78,6000]
[null,"Dave","Walker",1400,1245,477,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,\"The Total Expenses of \",B6,C6,\" is $\",SUM(D6,E6,F6))","v":"The Total Expenses of DaveWalker is $3122"},null,null,null,"Dave","Walker",1400,1245,477]
[null,"Paul","Shelton",1450,17,455,"The Total Expenses of PaulShelton is $1922",null,null,null,"Paul","Shelton",1450,17,455]
[null,"Lucy","Wood",1700,1800,147,"The Total Expenses of LucyWood is $3647",null,null,null,"Lucy","Wood",1700,1800,147]
[null,"Sabrina","Roberts",1900,2200,255,"The Total Expenses of SabrinaRoberts is $4355",null,null,null,"Sabrina","Roberts",1900,2200,255]
[null,"Miles","Dudley",5000,3000,177,"The Total Expenses of MilesDudley is $8177",null,null,null,"Miles","Dudley",5000,3000,177]
[null,"Brian","Sheppard",4500,1430,478,"The Total Expenses of BrianSheppard is $6408",null,null,null,"Brian","Sheppard",4500,1430,478]

{"sheet":"Using VBA Macros","index":7,"n_rows":16,"n_cols":22,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using VBA Macros to Add Text Before a Formula",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","January","February","March ","Total Expenses",null,null,null,null,"First Name","Last Name","January","February","March ","Total Expenses "]
[null,"Wade ","Harris",2500,78,6000,"The Total Expenses are $8578",null,null,null,null,"Wade ","Harris",2500,78,6000]
[null,"Dave","Walker",1400,1245,477,"The Total Expenses are $3122",null,null,null,null,"Dave","Walker",1400,1245,477]
[null,"Paul","Shelton",1450,17,455,"The Total Expenses are $1922",null,null,null,null,"Paul","Shelton",1450,17,455]
[null,"Lucy","Wood",1700,1800,147,"The Total Expenses are $3647",null,null,null,null,"Lucy","Wood",1700,1800,147]
[null,"Sabrina","Roberts",1900,2200,255,"The Total Expenses are $4355",null,null,null,null,"Sabrina","Roberts",1900,2200,255]
[null,"Miles","Dudley",5000,3000,177,"The Total Expenses are $8177",null,null,null,null,"Miles","Dudley",5000,3000,177]
[null,"Brian","Sheppard",4500,1430,478,"The Total Expenses are $6408",null,null,null,null,"Brian","Sheppard",4500,1430,478]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Using Flash Fill","index":8,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Adding Text Using Flash Fill",null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Wade ","Harris","Wade Harris",null,null,null,null,"Wade ","Harris"]
[null,"Dave","Walker","Dave Walker",null,null,null,null,"Dave","Walker"]
[null,"Paul","Shelton","Paul Shelton",null,null,null,null,"Paul","Shelton"]
[null,"Lucy","Wood","Lucy Wood",null,null,null,null,"Lucy","Wood"]
[null,"Sabrina","Roberts","Sabrina Roberts",null,null,null,null,"Sabrina","Roberts"]
[null,"Miles","Dudley","Miles Dudley",null,null,null,null,"Miles","Dudley"]
[null,"Brian","Sheppard","Brian Sheppard",null,null,null,null,"Brian","Sheppard"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"LEFT and MID Function","index":9,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Applying LEFT and MID Functions",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee","Job ID","New ID",null,null,null,null,null,"Employee","Job ID","New ID"]
[null,"John","12AB005",{"$f":"LEFT(C5,3)&\"M\"&MID(C5,4,5)","v":"12AMB005"},null,null,null,null,null,"John","12AB005"]
[null,"Peter","12AB006",{"$f":"LEFT(C6,3)&\"M\"&MID(C6,4,5)","v":"12AMB006"},null,null,null,null,null,"Peter","12AB006"]
[null,"Andrew","12AB007","12AMB007",null,null,null,null,null,"Andrew","12AB007"]
[null,"Robert","12AB008","12AMB008",null,null,null,null,null,"Robert","12AB008"]
[null,"Jack","12AB009","12AMB009",null,null,null,null,null,"Jack","12AB009"]
[null,"Anna","12AB010","12AMB010",null,null,null,null,null,"Anna","12AB010"]
[null,"Marry","12AB011","12AMB011",null,null,null,null,null,"Marry","12AB011"]
[null,"Smith","12AB012","12AMB012",null,null,null,null,null,"Smith","12AB012"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"REPLACE Function","index":10,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Employing REPLACE Function",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student","Student ID","New Student ID",null,null,null,null,"Student","Student ID","New Student ID"]
[null,"John",1510050,{"$f":"REPLACE(C5,1,0,\"S\")","v":"S1510050"},null,null,null,null,"John",1510050]
[null,"Peter",{"$f":"C5+1","v":1510051},{"$f":"REPLACE(C6,1,0,\"S\")","v":"S1510051"},null,null,null,null,"Peter",{"$f":"J5+1","v":1510051}]
[null,"Andrew",{"$f":"C6+1","v":1510052},{"$f":"REPLACE(C7,1,0,\"S\")","v":"S1510052"},null,null,null,null,"Andrew",{"$f":"J6+1","v":1510052}]
[null,"Robert",1510053,"S1510053",null,null,null,null,"Robert",1510053]
[null,"Jack",1510054,"S1510054",null,null,null,null,"Jack",1510054]
[null,"Anna",1510055,"S1510055",null,null,null,null,"Anna",1510055]
[null,"Marry",1510056,"S1510056",null,null,null,null,"Marry",1510056]
[null,"Smith",1510057,"S1510057",null,null,null,null,"Smith",1510057]