{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","with Formula","with VBA","Capitalize"],"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":"Overview","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Capitalize First Letter"]
[]
[null,"Input","Output",null,"Formula"]
[null,"london is the capital of uk",{"$f":"PROPER(B5)","v":"London Is The Capital Of Uk"},null,"=PROPER(B5)"]
[null,"canberra is the Capital of Australia",{"$f":"REPLACE(LOWER(B6),1,1,UPPER(LEFT(B6,1)))","v":"Canberra is the capital of australia"},null,"=REPLACE(LOWER(B6),1,1,UPPER(LEFT(B6,1)))"]
[null,"washington dc is the Capital of USA",{"$f":"REPLACE(B7,1,1,UPPER(LEFT(B7,1)))","v":"Washington dc is the Capital of USA"},null,"=REPLACE(B7,1,1,UPPER(LEFT(B7,1)))"]
[null,"wellington is the capital of new zealand",{"$f":"UPPER(LEFT(B8,1))&RIGHT(B8,LEN(B8)-1)","v":"Wellington is the capital of new zealand"},null,"=UPPER(LEFT(B8,1))&RIGHT(B8,LEN(B8)-1)"]
[null,"bern is the capital of switzerland",{"$f":"UPPER(LEFT(B9,1))&LOWER(RIGHT(B9,LEN(B9)-1))","v":"Bern is the capital of switzerland"},null,"=UPPER(LEFT(B9,1))&LOWER(RIGHT(B9,LEN(B9)-1))"]
[null,"port louis is the capital of mauritius",{"$f":"UPPER(LEFT(B10))&MID(B10,2,LEN(B10))","v":"Port louis is the capital of mauritius"},null,"=UPPER(LEFT(B10))&MID(B10,2,LEN(B10))"]

{"sheet":"with Formula","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Capitalize First Letter with Formula"]
[]
[null,"Input","Output"]
[null,"london is the capital of uk",{"$f":"PROPER(B5)","v":"London Is The Capital Of Uk"}]
[null,"canberra is the Capital of Australia",{"$f":"REPLACE(LOWER(B6),1,1,UPPER(LEFT(B6,1)))","v":"Canberra is the capital of australia"}]
[null,"washington dc is the Capital of USA",{"$f":"REPLACE(B7,1,1,UPPER(LEFT(B7,1)))","v":"Washington dc is the Capital of USA"}]
[null,"wellington is the capital of new zealand",{"$f":"UPPER(LEFT(B8,1))&RIGHT(B8,LEN(B8)-1)","v":"Wellington is the capital of new zealand"}]
[null,"bern is the capital of switzerland",{"$f":"UPPER(LEFT(B9,1))&LOWER(RIGHT(B9,LEN(B9)-1))","v":"Bern is the capital of switzerland"}]
[null,"port louis is the capital of mauritius",{"$f":"UPPER(LEFT(B10))&MID(B10,2,LEN(B10))","v":"Port louis is the capital of mauritius"}]

{"sheet":"with VBA","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Capitalize First Letter With Vba"]
[]
[null,"Input","Output"]
[null,"london iS tHe capital of UK","London iS tHe capital of UK"]
[null,"canberra is the Capital of Australia","Canberra is the capital of australia"]
[null,"washington dc is tHe cApital of USA","Washington Dc Is The Capital Of Usa"]

{"sheet":"Capitalize","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Capitalize First Letter Of Each Word"]
[]
[null,"Capitalize With Vba"]
[null,"London Is The Capital Of Uk"]
[null,"Canberra Is The Capital Of Australia"]
[null,"Washington Dc Is The Capital Of Usa"]
[null,"Wellington Is The Capital Of New Zealand"]
[null,"Bern Is The Capital Of Switzerland"]
[null,"Port Louis Is The Capital Of Mauritius"]