{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Using PROPER function","UPPER,LEFT & RIGHT functions","Use of Combined Function","UPPER,LEFT,MID & LEN","Using VBA code","Using Excel AutoCorrect"],"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":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Capitalize First Letter of Sentence"]
[]
[null,"Sentence"]
[null,"how to capitalize first letter"]
[null,"life is a daring adventure"]
[null,"love the life you live"]
[null,"live the life you love"]
[null,"make each day your masterpiece"]

{"sheet":"Using PROPER function","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using PROPER Function",null,null,null,null,"Do It Yourself"]
[]
[null,"Sentence","Capitalized Each Word",null,null,null,"Sentence","Capitalized Each Word"]
[null,"how to capitalize first letter",{"$f":"PROPER(B5)","v":"How To Capitalize First Letter"},null,null,null,"how to capitalize first letter"]
[null,"life is a daring adventure",{"$f":"PROPER(B6)","v":"Life Is A Daring Adventure"},null,null,null,"life is a daring adventure"]
[null,"love the life you live","Love The Life You Live",null,null,null,"love the life you live"]
[null,"live the life you love","Live The Life You Love",null,null,null,"live the life you love"]
[null,"make each day your masterpiece","Make Each Day Your Masterpiece",null,null,null,"make each day your masterpiece"]

{"sheet":"UPPER,LEFT & RIGHT functions","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using UPPER, LEFT & RIGHT Functions",null,null,null,null,"Do It Yourself"]
[]
[null,"Sentence","Capitalized 1st Letter of Sentence",null,null,null,"Sentence","Result"]
[null,"how to capitalize first letter",{"$f":"UPPER(LEFT(B5,1))&RIGHT(B5,LEN(B5)-1)","v":"How to capitalize first letter"},null,null,null,"how to capitalize first letter"]
[null,"life is a daring adventure",{"$f":"UPPER(LEFT(B6,1))&RIGHT(B6,LEN(B6)-1)","v":"Life is a daring adventure"},null,null,null,"life is a daring adventure"]
[null,"love the Life you live","Love the Life you live",null,null,null,"love the life you live"]
[null,"live the life you love","Live the life you love",null,null,null,"live the life you love"]
[null,"make each day your masterpiece","Make each day your masterpiece",null,null,null,"make each day your masterpiece"]

{"sheet":"Use of Combined Function","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Combined Functions",null,null,null,null,"Do It Yourself"]
[]
[null,"Sentence","Capitalized 1st Letter & Lower Rest",null,null,null,"Sentence","Result"]
[null,"how to capitalize first letter",{"$f":"REPLACE(LOWER(B5),1,1,UPPER(LEFT(B5,1)))","v":"How to capitalize first letter"},null,null,null,"how to capitalize first letter"]
[null,"life is a daring adventure",{"$f":"REPLACE(LOWER(B6),1,1,UPPER(LEFT(B6,1)))","v":"Life is a daring adventure"},null,null,null,"life is a daring adventure"]
[null,"love the Life you live","Love the life you live",null,null,null,"love the life you live"]
[null,"live the life you love","Live the life you love",null,null,null,"live the life you love"]
[null,"make each day your masterpiece","Make each day your masterpiece",null,null,null,"make each day your masterpiece"]

{"sheet":"UPPER,LEFT,MID & LEN","index":4,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using UPPER, LEFT, MID & LEN functions",null,null,null,null,"Do It Yourself"]
[]
[null,"Sentence","Capitalized Only 1st Letter",null,null,null,"Sentence","Result"]
[null,"how to capitalize first letter",{"$f":"UPPER(LEFT(B5))&MID(B5,2,LEN(B5))","v":"How to capitalize first letter"},null,null,null,"how to capitalize first letter"]
[null,"life is a daring adventure",{"$f":"UPPER(LEFT(B6))&MID(B6,2,LEN(B6))","v":"Life is a daring adventure"},null,null,null,"life is a daring adventure"]
[null,"love the Life you live","Love the Life you live",null,null,null,"love the life you live"]
[null,"live the life you love","Live the life you love",null,null,null,"live the life you love"]
[null,"make each day your masterpiece","Make each day your masterpiece",null,null,null,"make each day your masterpiece"]

{"sheet":"Using VBA code","index":5,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[]
[null,"Using VBA Code",null,null,null,"Do It Yourself"]
[]
[null,"Capitalized Only 1st Letter ",null,null,null,"Sentence","Result"]
[null,"How to capitalize first letter",null,null,null,"how to capitalize first letter"]
[null,"Life is a daring adventure",null,null,null,"life is a daring adventure"]
[null,"Love the Life you live",null,null,null,"love the life you live"]
[null,"Live the life you love",null,null,null,"live the life you love"]
[null,"Make each day your masterpiece",null,null,null,"make each day your masterpiece"]

{"sheet":"Using Excel AutoCorrect","index":6,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using Excel AutoCorrect",null,null,null,null,"Do It Yourself"]
[]
[null,"Sentence","Capitalized Listed Word",null,null,null,"Sentence","Result"]
[null,"how to capitalize first letter","How to capitalize first letter",null,null,null,"how to capitalize first letter"]
[null,"life is a daring adventure","Life is a daring adventure",null,null,null,"life is a daring adventure"]
[null,"love the life you live","Love the Life you Live",null,null,null,"love the life you live"]
[null,"live the life you love","Live the Life you Love",null,null,null,"live the life you love"]
[null,"make each day your masterpiece","Make each day your masterpiece",null,null,null,"make each day your masterpiece"]