{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset1","Practice Section","Changing Sentence Case","Table1","Power Query","Flash Fill","Microsoft_Word","Dataset2","Formula1-SentenceCase","Formula2-SentenceCase","VBA","VBA-CustomFunction"],"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":"Dataset1","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"In Sentence Case"]
[null,"Harry potter"]
[null,"Peter parker"]
[null,"Robert brose"]
[null,"Dan brown"]
[null,"Jack sparrow"]
[null,"Thomas alva edison"]
[null,"Nikola tesla"]
[null,"Albert einstein"]
[null,"Robert pattinson"]

{"sheet":"Practice Section","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Do It Yourself"]
[]
[null,"In Sentence Case","In Title Case","Without Format","In Sentence Case"]
[null,"Harry potter",null,"a picTUre is worth A ThouSand wORds."]
[null,"Peter parker",null,"BeTTer laTe than neveR."]
[null,"Robert brose",null,"samanthA tOOk thE bus."]
[null,"Dan brown",null,"beGGars can’T be chOOsers."]
[null,"Jack sparrow",null,"i did not sEe tHem at the Bus station."]
[null,"Thomas alva edison",null,"Sara has NO monEY at THE moment."]
[null,"Nikola tesla",null,"mary likes BaNANas."]
[null,"Albert einstein",null,"i love my new PETs."]
[null,"Robert pattinson",null,"HE liKes coFFee and tEa."]

{"sheet":"Changing Sentence Case","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Changing Sentence Case into Other Cases"]
[]
[null,"In Sentence Case","In Upper Case","In Title Case","In Lower Case"]
[null,"Harry potter",{"$f":"UPPER(B5)","v":"HARRY POTTER"},{"$f":"PROPER(B5)","v":"Harry Potter"},{"$f":"LOWER(B5)","v":"harry potter"}]
[null,"Peter parker",{"$f":"UPPER(B6)","v":"PETER PARKER"},{"$f":"PROPER(B6)","v":"Peter Parker"},{"$f":"LOWER(B6)","v":"peter parker"}]
[null,"Robert brose","ROBERT BROSE","Robert Brose","robert brose"]
[null,"Dan brown","DAN BROWN","Dan Brown","dan brown"]
[null,"Jack sparrow","JACK SPARROW","Jack Sparrow","jack sparrow"]
[null,"Thomas alva edison","THOMAS ALVA EDISON","Thomas Alva Edison","thomas alva edison"]
[null,"Nikola tesla","NIKOLA TESLA","Nikola Tesla","nikola tesla"]
[null,"Albert einstein","ALBERT EINSTEIN","Albert Einstein","albert einstein"]
[null,"Robert pattinson","ROBERT PATTINSON","Robert Pattinson","robert pattinson"]

{"sheet":"Table1","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["In Sentence Case","Capitalize Each Word","UPPERCASE","lowercase"]
["Harry potter","Harry Potter","HARRY POTTER","harry potter"]
["Peter parker","Peter Parker","PETER PARKER","peter parker"]
["Robert brose","Robert Brose","ROBERT BROSE","robert brose"]
["Dan brown","Dan Brown","DAN BROWN","dan brown"]
["Jack sparrow","Jack Sparrow","JACK SPARROW","jack sparrow"]
["Thomas alva edison","Thomas Alva Edison","THOMAS ALVA EDISON","thomas alva edison"]
["Nikola tesla","Nikola Tesla","NIKOLA TESLA","nikola tesla"]
["Albert einstein","Albert Einstein","ALBERT EINSTEIN","albert einstein"]
["Robert pattinson","Robert Pattinson","ROBERT PATTINSON","robert pattinson"]

{"sheet":"Power Query","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Changing Sentence Case Using Power Query"]
[]
[null,"In Sentence Case"]
[null,"Harry potter"]
[null,"Peter parker"]
[null,"Robert brose"]
[null,"Dan brown"]
[null,"Jack sparrow"]
[null,"Thomas alva edison"]
[null,"Nikola tesla"]
[null,"Albert einstein"]
[null,"Robert pattinson"]

{"sheet":"Flash Fill","index":5,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Flash Fill to Change Sentence Case"]
[]
[null,"In Sentence Case","In Upper Case","In Title Case","In Lower Case"]
[null,"Harry potter","HARRY POTTER","Harry Potter","harry potter"]
[null,"Peter parker","PETER PARKER","Peter Parker","peter parker"]
[null,"Robert brose","ROBERT BROSE","Robert Brose","robert brose"]
[null,"Dan brown","DAN BROWN","Dan Brown","dan brown"]
[null,"Jack sparrow","JACK SPARROW","Jack Sparrow","jack sparrow"]
[null,"Thomas alva edison","THOMAS ALVA EDISON","Thomas Alva Edison","thomas alva edison"]
[null,"Nikola tesla","NIKOLA TESLA","Nikola Tesla","nikola tesla"]
[null,"Albert einstein","ALBERT EINSTEIN","Albert Einstein","albert einstein"]
[null,"Robert pattinson","ROBERT PATTINSON","Robert Pattinson","robert pattinson"]

{"sheet":"Microsoft_Word","index":6,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Microsoft Word to Change Sentence Case"]
[]
[null,"In Sentence Case","In Upper Case","In Title Case","In Lower Case"]
[null,"Harry potter","HARRY POTTER","Harry Potter","harry potter"]
[null,"Peter parker","PETER PARKER","Peter Parker","peter parker"]
[null,"Robert brose","ROBERT BROSE","Robert Brose","robert brose"]
[null,"Dan brown","DAN BROWN","Dan Brown","dan brown"]
[null,"Jack sparrow","JACK SPARROW","Jack Sparrow","jack sparrow"]
[null,"Thomas alva edison","THOMAS ALVA EDISON","Thomas Alva Edison","thomas alva edison"]
[null,"Nikola tesla","NIKOLA TESLA","Nikola Tesla","nikola tesla"]
[null,"Albert einstein","ALBERT EINSTEIN","Albert Einstein","albert einstein"]
[null,"Robert pattinson","ROBERT PATTINSON","Robert Pattinson","robert pattinson"]

{"sheet":"Dataset2","index":7,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Incorrect Format Sentence List"]
[]
[null,"Sentences"]
[null,"a picTUre is worth A ThouSand wORds."]
[null,"BeTTer laTe than neveR."]
[null,"samanthA tOOk thE bus."]
[null,"beGGars can’T be chOOsers."]
[null,"i did not sEe tHem at the Bus station."]
[null,"Sara has NO monEY at THE moment."]
[null,"mary likes BaNANas."]
[null,"i love my new PETs."]
[null,"HE liKes coFFee and tEa."]
[null,"Our car broke down."]

{"sheet":"Formula1-SentenceCase","index":8,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using UPPER, LOWER, RIGHT, LEFT & LEN Functions"]
[]
[null,"Without Format","In Sentence Case"]
[null,"a picTUre is worth A ThouSand wORds.",{"$f":"UPPER(LEFT(B5,1))&LOWER(RIGHT(B5,LEN(B5)-1))","v":"A picture is worth a thousand words."}]
[null,"BeTTer laTe than neveR.",{"$f":"UPPER(LEFT(B6,1))&LOWER(RIGHT(B6,LEN(B6)-1))","v":"Better late than never."}]
[null,"samanthA tOOk thE bus.","Samantha took the bus."]
[null,"beGGars can’T be chOOsers.","Beggars can’t be choosers."]
[null,"i did not sEe tHem at the Bus station.","I did not see them at the bus station."]
[null,"Sara has NO monEY at THE moment.","Sara has no money at the moment."]
[null,"mary likes BaNANas.","Mary likes bananas."]
[null,"i love my new PETs.","I love my new pets."]
[null,"HE liKes coFFee and tEa.","He likes coffee and tea."]
[null,"Our car broke down.","Our car broke down."]

{"sheet":"Formula2-SentenceCase","index":9,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using UPPER, LOWER, MID & LEFT Functions"]
[]
[null,"Without Format","In Sentence Case"]
[null,"a picTUre is worth A ThouSand wORds.",{"$f":"UPPER(LEFT(B5,1))&MID(LOWER(B5),2,999)","v":"A picture is worth a thousand words."}]
[null,"BeTTer laTe than neveR.",{"$f":"UPPER(LEFT(B6,1))&MID(LOWER(B6),2,999)","v":"Better late than never."}]
[null,"samanthA tOOk thE bus.","Samantha took the bus."]
[null,"beGGars can’T be chOOsers.","Beggars can’t be choosers."]
[null,"i did not sEe tHem at the Bus station.","I did not see them at the bus station."]
[null,"Sara has NO monEY at THE moment.","Sara has no money at the moment."]
[null,"mary likes BaNANas.","Mary likes bananas."]
[null,"i love my new PETs.","I love my new pets."]
[null,"HE liKes coFFee and tEa.","He likes coffee and tea."]
[null,"Our car broke down.","Our car broke down."]

{"sheet":"VBA","index":10,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"VBA Code to a Selected Range of Cells"]
[]
[null,"Without Format"]
[null,"A picture is worth a thousand words."]
[null,"Better late than never."]
[null,"Samantha took the bus."]
[null,"Beggars can’t be choosers."]
[null,"I did not see them at the bus station."]
[null,"Sara has no money at the moment."]
[null,"Mary likes bananas."]
[null,"I love my new pets."]
[null,"He likes coffee and tea."]
[null,"Our car broke down."]

{"sheet":"VBA-CustomFunction","index":11,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"VBA Code to Create a Custom Function for Getting Sentence Case"]
[]
[null,"Without Format","In Sentence Case"]
[null,"a picTUre is worth A ThouSand wORds.",{"$f":"SentenceCase(B5)","v":"A picture is worth a thousand words."}]
[null,"BeTTer laTe than neveR.",{"$f":"SentenceCase(B6)","v":"Better late than never."}]
[null,"samanthA tOOk thE bus.",{"$f":"SentenceCase(B7)","v":"Samantha took the bus."}]
[null,"beGGars can’T be chOOsers.",{"$f":"SentenceCase(B8)","v":"Beggars can’t be choosers."}]
[null,"i did not sEe tHem at the Bus station.",{"$f":"SentenceCase(B9)","v":"I did not see them at the bus station."}]
[null,"Sara has NO monEY at THE moment.",{"$f":"SentenceCase(B10)","v":"Sara has no money at the moment."}]
[null,"mary likes BaNANas.",{"$f":"SentenceCase(B11)","v":"Mary likes bananas."}]
[null,"i love my new PETs.",{"$f":"SentenceCase(B12)","v":"I love my new pets."}]
[null,"HE liKes coFFee and tEa.",{"$f":"SentenceCase(B13)","v":"He likes coffee and tea."}]
[null,"Our car broke down.",{"$f":"SentenceCase(B14)","v":"Our car broke down."}]