{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Manual","PROPER","Power Query","Table1","VBA","MS WORD","UPPER","REPLACE"],"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":"Dataset","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dataset"]
[]
[null,"Normal Text"]
[null,"mario puzo"]
[null,"amerigo bonasera"]
[null,"johnny fontane "]
[null,"vito corleone "]
[null,"lucy mancini"]
[null,"luca brasi"]
[null,"carlo rizzi"]
[null,"paulie gatto"]
[null,"peter clemenza"]
[null,"tom hagen"]

{"sheet":"Manual","index":1,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Modifying Manually",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Normal Text","Proper Text",null,null,null,null,null,"Normal Text","Proper Text"]
[null,"mario puzo","Mario Puzo",null,null,null,null,null,"mario puzo"]
[null,"amerigo bonasera","Amerigo Bonasera",null,null,null,null,null,"amerigo bonasera"]
[null,"johnny fontane ","Johnny Fontane ",null,null,null,null,null,"johnny fontane "]
[null,"vito corleone ","Vito Corleone ",null,null,null,null,null,"vito corleone "]
[null,"lucy mancini","Lucy Mancini",null,null,null,null,null,"lucy mancini"]
[null,"luca brasi","Luca Brasi",null,null,null,null,null,"luca brasi"]
[null,"carlo rizzi","Carlo Rizzi",null,null,null,null,null,"carlo rizzi"]
[null,"paulie gatto","Paulie Gatto",null,null,null,null,null,"paulie gatto"]
[null,"peter clemenza","Peter Clemenza",null,null,null,null,null,"peter clemenza"]
[null,"tom hagen","Tom Hagen",null,null,null,null,null,"tom hagen"]

{"sheet":"PROPER","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using PROPER Function",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Normal Text","Proper Text",null,null,null,null,null,"Normal Text","Proper Text"]
[null,"mario puzo",{"$f":"PROPER(B5)","v":"Mario Puzo"},null,null,null,null,null,"mario puzo"]
[null,"amerigo bonasera",{"$f":"PROPER(B6)","v":"Amerigo Bonasera"},null,null,null,null,null,"amerigo bonasera"]
[null,"johnny fontane ","Johnny Fontane ",null,null,null,null,null,"johnny fontane "]
[null,"vito corleone ","Vito Corleone ",null,null,null,null,null,"vito corleone "]
[null,"lucy mancini","Lucy Mancini",null,null,null,null,null,"lucy mancini"]
[null,"luca brasi","Luca Brasi",null,null,null,null,null,"luca brasi"]
[null,"carlo rizzi","Carlo Rizzi",null,null,null,null,null,"carlo rizzi"]
[null,"paulie gatto","Paulie Gatto",null,null,null,null,null,"paulie gatto"]
[null,"peter clemenza","Peter Clemenza",null,null,null,null,null,"peter clemenza"]
[null,"tom hagen","Tom Hagen",null,null,null,null,null,"tom hagen"]

{"sheet":"Power Query","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Applying Power Query",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Normal Text",null,null,null,null,null,null,"Normal Text"]
[null,"mario puzo",null,null,null,null,null,null,"mario puzo"]
[null,"amerigo bonasera",null,null,null,null,null,null,"amerigo bonasera"]
[null,"johnny fontane ",null,null,null,null,null,null,"johnny fontane "]
[null,"vito corleone ",null,null,null,null,null,null,"vito corleone "]
[null,"lucy mancini",null,null,null,null,null,null,"lucy mancini"]
[null,"luca brasi",null,null,null,null,null,null,"luca brasi"]
[null,"carlo rizzi",null,null,null,null,null,null,"carlo rizzi"]
[null,"paulie gatto",null,null,null,null,null,null,"paulie gatto"]
[null,"peter clemenza",null,null,null,null,null,null,"peter clemenza"]
[null,"tom hagen",null,null,null,null,null,null,"tom hagen"]

{"sheet":"Table1","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Normal Text","Capitalize Each Word"]
["mario puzo","Mario Puzo"]
["amerigo bonasera","Amerigo Bonasera"]
["johnny fontane ","Johnny Fontane "]
["vito corleone ","Vito Corleone "]
["lucy mancini","Lucy Mancini"]
["luca brasi","Luca Brasi"]
["carlo rizzi","Carlo Rizzi"]
["paulie gatto","Paulie Gatto"]
["peter clemenza","Peter Clemenza"]
["tom hagen","Tom Hagen"]

{"sheet":"VBA","index":5,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Employing VBA",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Normal Text","Proper Text",null,null,null,null,null,"Normal Text","Proper Text"]
[null,"mario puzo","Mario Puzo",null,null,null,null,null,"mario puzo"]
[null,"amerigo bonasera","Amerigo Bonasera",null,null,null,null,null,"amerigo bonasera"]
[null,"johnny fontane ","Johnny Fontane ",null,null,null,null,null,"johnny fontane "]
[null,"vito corleone ","Vito Corleone ",null,null,null,null,null,"vito corleone "]
[null,"lucy mancini","Lucy Mancini",null,null,null,null,null,"lucy mancini"]
[null,"luca brasi","Luca Brasi",null,null,null,null,null,"luca brasi"]
[null,"carlo rizzi","Carlo Rizzi",null,null,null,null,null,"carlo rizzi"]
[null,"paulie gatto","Paulie Gatto",null,null,null,null,null,"paulie gatto"]
[null,"peter clemenza","Peter Clemenza",null,null,null,null,null,"peter clemenza"]
[null,"tom hagen","Tom Hagen",null,null,null,null,null,"tom hagen"]

{"sheet":"MS WORD","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using MS WORD",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Normal Text","Proper Text",null,null,null,null,null,"Normal Text","Proper Text"]
[null,"mario puzo","Mario Puzo",null,null,null,null,null,"mario puzo"]
[null,"amerigo bonasera","Amerigo Bonasera",null,null,null,null,null,"amerigo bonasera"]
[null,"johnny fontane ","Johnny Fontane ",null,null,null,null,null,"johnny fontane "]
[null,"vito corleone ","Vito Corleone ",null,null,null,null,null,"vito corleone "]
[null,"lucy mancini","Lucy Mancini",null,null,null,null,null,"lucy mancini"]
[null,"luca brasi","Luca Brasi",null,null,null,null,null,"luca brasi"]
[null,"carlo rizzi","Carlo Rizzi",null,null,null,null,null,"carlo rizzi"]
[null,"paulie gatto","Paulie Gatto",null,null,null,null,null,"paulie gatto"]
[null,"peter clemenza","Peter Clemenza",null,null,null,null,null,"peter clemenza"]
[null,"tom hagen","Tom Hagen",null,null,null,null,null,"tom hagen"]

{"sheet":"UPPER","index":7,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Applying UPPER Function",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Normal Text","Proper Text",null,null,null,null,null,"Normal Text","Proper Text"]
[null,"mario puzo",{"$f":"UPPER(B5)","v":"MARIO PUZO"},null,null,null,null,null,"mario puzo"]
[null,"amerigo bonasera",{"$f":"UPPER(B6)","v":"AMERIGO BONASERA"},null,null,null,null,null,"amerigo bonasera"]
[null,"johnny fontane ","JOHNNY FONTANE ",null,null,null,null,null,"johnny fontane "]
[null,"vito corleone ","VITO CORLEONE ",null,null,null,null,null,"vito corleone "]
[null,"lucy mancini","LUCY MANCINI",null,null,null,null,null,"lucy mancini"]
[null,"luca brasi","LUCA BRASI",null,null,null,null,null,"luca brasi"]
[null,"carlo rizzi","CARLO RIZZI",null,null,null,null,null,"carlo rizzi"]
[null,"paulie gatto","PAULIE GATTO",null,null,null,null,null,"paulie gatto"]
[null,"peter clemenza","PETER CLEMENZA",null,null,null,null,null,"peter clemenza"]
[null,"tom hagen","TOM HAGEN",null,null,null,null,null,"tom hagen"]

{"sheet":"REPLACE","index":8,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of REPLACE Function",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Normal Text","Proper Text",null,null,null,null,null,"Normal Text","Proper Text"]
[null,"mario puzo",{"$f":"REPLACE(LOWER(B5),1,1,UPPER(LEFT(B5,1)))","v":"Mario puzo"},null,null,null,null,null,"mario puzo"]
[null,"amerigo bonasera",{"$f":"REPLACE(LOWER(B6),1,1,UPPER(LEFT(B6,1)))","v":"Amerigo bonasera"},null,null,null,null,null,"amerigo bonasera"]
[null,"johnny fontane","Johnny fontane",null,null,null,null,null,"johnny fontane"]
[null,"vito corleone","Vito corleone",null,null,null,null,null,"vito corleone"]
[null,"lucy mancini","Lucy mancini",null,null,null,null,null,"lucy mancini"]
[null,"luca brasi","Luca brasi",null,null,null,null,null,"luca brasi"]
[null,"carlo rizzi","Carlo rizzi",null,null,null,null,null,"carlo rizzi"]
[null,"paulie gatto","Paulie gatto",null,null,null,null,null,"paulie gatto"]
[null,"peter clemenza","Peter clemenza",null,null,null,null,null,"peter clemenza"]
[null,"tom hagen","Tom hagen",null,null,null,null,null,"tom hagen"]