{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Initial Dataset","Easiest Way","Alternative Way #1","Alternative Way #2","Alternative Way #3","Alternative Way #4","Sheet8"],"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":"Initial Dataset","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["List of Cities (With Unwanted Brackets)","List of Cities ( After Removing Brackets)"]
["New York,(USA)"]
["Oslo,(Sweden)"]
["Rome,(Italy)"]
["Prague,(Czechia)"]
["Austin,(USA)"]
["Lisbon,(Portugal)"]
["Chicago,(USA)"]
["San Diego,(USA)"]
["Portland,(USA)"]

{"sheet":"Easiest Way","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["List of Cities"]
["New York,USA"]
["Oslo,Sweden"]
["Rome,Italy"]
["Prague,Czechia"]
["Austin,USA"]
["Lisbon,Portugal"]
["Chicago,USA"]
["San Diego,USA"]
["Portland,USA"]

{"sheet":"Alternative Way #1","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["List of Cities (With Unwanted Brackets)","List of Cities ( After Removing Brackets)"]
["New York,(USA)",{"$f":"SUBSTITUTE(SUBSTITUTE(A2, \"(\", \"\"), \")\", \"\")","v":"New York,USA"}]
["Oslo,(Sweden)",{"$f":"SUBSTITUTE(SUBSTITUTE(A3, \"(\", \"\"), \")\", \"\")","v":"Oslo,Sweden"}]
["Rome,(Italy)","Rome,Italy"]
["Prague,(Czechia)","Prague,Czechia"]
["Austin,(USA)","Austin,USA"]
["Lisbon,(Portugal)","Lisbon,Portugal"]
["Chicago,(USA)","Chicago,USA"]
["San Diego,(USA)","San Diego,USA"]
["Portland,(USA)","Portland,USA"]

{"sheet":"Alternative Way #2","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["List of Cities (With Unwanted Brackets)","List of Cities ( After Removing Brackets)"]
["New York,(USA)",{"$f":"REPLACE(REPLACE(A2, FIND(\"(\", A2), 1, \"\"), FIND(\")\", REPLACE(A2, FIND(\"(\", A2), 1, \"\")), 1, \"\")","v":"New York,USA"}]
["Oslo,(Sweden)",{"$f":"REPLACE(REPLACE(A3, FIND(\"(\", A3), 1, \"\"), FIND(\")\", REPLACE(A3, FIND(\"(\", A3), 1, \"\")), 1, \"\")","v":"Oslo,Sweden"}]
["Rome,(Italy)","Rome,Italy"]
["Prague,(Czechia)","Prague,Czechia"]
["Austin,(USA)","Austin,USA"]
["Lisbon,(Portugal)","Lisbon,Portugal"]
["Chicago,(USA)","Chicago,USA"]
["San Diego,(USA)","San Diego,USA"]
["Portland,(USA)","Portland,USA"]

{"sheet":"Alternative Way #3","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["List of Cities (With Unwanted Brackets)","List of Cities ( After Removing Brackets)"]
["New York,(USA)",{"$f":"CLEAN(SUBSTITUTE(SUBSTITUTE(A2, \"(\", \"\"), \")\", \"\"))","v":"New York,USA"}]
["Oslo,(Sweden)",{"$f":"CLEAN(SUBSTITUTE(SUBSTITUTE(A3, \"(\", \"\"), \")\", \"\"))","v":"Oslo,Sweden"}]
["Rome,(Italy)","Rome,Italy"]
["Prague,(Czechia)","Prague,Czechia"]
["Austin,(USA)","Austin,USA"]
["Lisbon,(Portugal)","Lisbon,Portugal"]
["Chicago,(USA)","Chicago,USA"]
["San Diego,(USA)","San Diego,USA"]
["Portland,(USA)","Portland,USA"]

{"sheet":"Alternative Way #4","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["List of Cities (With Unwanted Brackets)","List of Cities (After Removing Brackets)"]
["New York,(USA)))))","New York,USA"]
["Oslo,(Sweden)","Oslo,Sweden"]
["Rome,({{{Italy)","Rome,Italy"]
["Prague,({Czechia)","Prague,Czechia"]
["Austin,(USA)","Austin,USA"]
["Lisbon,(Portugal)}","Lisbon,Portugal"]
["Chicago,(USA)","Chicago,USA"]
["San Diego,[(USA)","San Diego,USA"]
["Portland,(USA)]","Portland,USA"]

{"sheet":"Sheet8","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}