{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Text","Dataset","Reference","Concatenate","Texts","Named Range","Named Ranges","Paste","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Text","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference Text in Another Cell"]
[]
[null,"Cricket Playing Countries",null,"Reference Text"]
[null,"England",null,{"$f":"B7","v":"Australia"}]
[null,"New Zealand"]
[null,"Australia",null,"with INDIRECT"]
[null,"South Africa",null,{"$f":"INDIRECT(\"B7\")","v":"Australia"}]
[null,"Pakistan"]
[null,"Sri Lanka"]
[null,"West Indies"]
[null,"Bangladesh"]
[null,"Afganistan"]
[null,"India"]
[null,"Zimbabwe"]
[null,"Ireland"]
[null,"Netherlands"]

{"sheet":"Dataset","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Reference Text in Another Cell"]
[]
[null,"Cricket Playing Countries"]
[null,"England"]
[null,"New Zealand"]
[null,"Australia"]
[null,"South Africa"]
[null,"Pakistan"]
[null,"Sri Lanka"]
[null,"West Indies"]
[null,"Bangladesh"]
[null,"Afganistan"]
[null,"India"]
[null,"Zimbabwe"]
[null,"Ireland"]
[null,"Netherlands"]

{"sheet":"Reference","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference Text in Another Cell from Another Sheet"]
[]
[null,null,"Reference Text"]
[null,null,{"$f":"Dataset!B7","v":"Australia"}]
[]
[null,null,"with INDIRECT"]
[null,null,{"$f":"INDIRECT(\"Dataset!B7\")","v":"Australia"}]

{"sheet":"Concatenate","index":3,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference and Concatenate Texts in Another Cell"]
[]
[null,"Cricket Playing Countries",null,"Reference Text"]
[null,"England",null,{"$f":"B7&\" \"&B12&\" \"&B16","v":"Australia Bangladesh Ireland"}]
[null,"New Zealand"]
[null,"Australia",null,"with INDIRECT"]
[null,"South Africa",null,{"$f":"INDIRECT(\"B\"&7)","v":"Australia"}]
[null,"Pakistan"]
[null,"Sri Lanka"]
[null,"West Indies"]
[null,"Bangladesh"]
[null,"Afganistan"]
[null,"India"]
[null,"Zimbabwe"]
[null,"Ireland"]
[null,"Netherlands"]

{"sheet":"Texts","index":4,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Reference Range of Texts in Another Cell"]
[]
[null,"Cricket Playing Countries",null,"Reference Text",null,"with INDIRECT"]
[null,"England",null,{"$f":"B7:B13","v":"Australia"},null,{"$f":"INDIRECT(\"B7:B13\")","v":"Australia"}]
[null,"New Zealand",null,"South Africa",null,"South Africa"]
[null,"Australia",null,"Pakistan",null,"Pakistan"]
[null,"South Africa",null,"Sri Lanka",null,"Sri Lanka"]
[null,"Pakistan",null,"West Indies",null,"West Indies"]
[null,"Sri Lanka",null,"Bangladesh",null,"Bangladesh"]
[null,"West Indies",null,"Afganistan",null,"Afganistan"]
[null,"Bangladesh"]
[null,"Afganistan"]
[null,"India"]
[null,"Zimbabwe"]
[null,"Ireland"]
[null,"Netherlands"]

{"sheet":"Named Range","index":5,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference Text by Named Range in Another Cell"]
[]
[null,"Cricket Playing Countries",null,"Reference Text"]
[null,"England",null,{"$f":"Aussie","v":"Australia"}]
[null,"New Zealand"]
[null,"Australia",null,"with INDIRECT"]
[null,"South Africa",null,{"$f":"INDIRECT(\"Aussie\")","v":"Australia"}]
[null,"Pakistan"]
[null,"Sri Lanka"]
[null,"West Indies"]
[null,"Bangladesh"]
[null,"Afganistan"]
[null,"India"]
[null,"Zimbabwe"]
[null,"Ireland"]
[null,"Netherlands"]

{"sheet":"Named Ranges","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference Multiple Texts by Named Range in Another Cell"]
[]
[null,"Cricket Playing Countries",null,"Reference Text",null,"with INDIRECT"]
[null,"England",null,{"$f":"Countries","v":"Australia"},null,{"$f":"INDIRECT(\"Countries\")","v":"Australia"}]
[null,"New Zealand",null,"South Africa",null,"South Africa"]
[null,"Australia",null,"Pakistan",null,"Pakistan"]
[null,"South Africa",null,"Sri Lanka",null,"Sri Lanka"]
[null,"Pakistan",null,"West Indies",null,"West Indies"]
[null,"Sri Lanka",null,"Bangladesh",null,"Bangladesh"]
[null,"West Indies",null,"Afganistan",null,"Afganistan"]
[null,"Bangladesh"]
[null,"Afganistan"]
[null,"India"]
[null,"Zimbabwe"]
[null,"Ireland"]
[null,"Netherlands"]

{"sheet":"Paste","index":7,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference Text in Another Cell with Paste Special"]
[]
[null,"Cricket Playing Countries",null,"Reference Text"]
[null,"England",null,{"$f":"$B$7","v":"Australia"}]
[null,"New Zealand"]
[null,"Australia"]
[null,"South Africa"]
[null,"Pakistan"]
[null,"Sri Lanka"]
[null,"West Indies"]
[null,"Bangladesh"]
[null,"Afganistan"]
[null,"India"]
[null,"Zimbabwe"]
[null,"Ireland"]
[null,"Netherlands"]

{"sheet":"VBA","index":8,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Reference Text in Another Cell with VBA"]
[]
[null,"Cricket Playing Countries",null,"Reference Text"]
[null,"England",null,"Canada"]
[null,"New Zealand"]
[null,"Canada"]
[null,"South Africa"]
[null,"Pakistan"]
[null,"Sri Lanka"]
[null,"West Indies"]
[null,"Bangladesh"]
[null,"Afganistan"]
[null,"India"]
[null,"Zimbabwe"]
[null,"Ireland"]
[null,"Netherlands"]