{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["M1","M2","Con_Prefix","Con_Suffix","&_Prefix","&_Suffix"],"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":"M1","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Number Format"]
[]
[null,"Number","Number with Prefix"]
[null,521,521]
[null,972,972]
[null,133,133]
[null,854,854]
[null,921,921]

{"sheet":"M2","index":1,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Name","Name with Prefix"]
[null,"Stephen","Dr. Stephen"]
[null,"Lenon","Dr. Lenon"]
[null,"Gilmour","Dr. Gilmour"]
[null,"David","Dr. David"]
[null,"Adeline","Dr. Adeline"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"Con_Prefix","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying CONCATENATE Function"]
[]
[null,"Name","Name with Prefix"]
[null,"Stephen",{"$f":"CONCATENATE(\"Dr. \",B5)","v":"Dr. Stephen"}]
[null,"Lenon",{"$f":"CONCATENATE(\"Dr. \",B6)","v":"Dr. Lenon"}]
[null,"Gilmour","Dr. Gilmour"]
[null,"David","Dr. David"]
[null,"Adeline","Dr. Adeline"]

{"sheet":"Con_Suffix","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying CONCATENATE Function"]
[]
[null,"Name","Name with Suffix"]
[null,"Samsung",{"$f":"CONCATENATE(B5,\" Mobile\")","v":"Samsung Mobile"}]
[null,"Apple",{"$f":"CONCATENATE(B6,\" Mobile\")","v":"Apple Mobile"}]
[null,"Nokia",{"$f":"CONCATENATE(B7,\" Mobile\")","v":"Nokia Mobile"}]
[null,"Blackberry","Blackberry Mobile"]
[null,"One Plus","One Plus Mobile"]

{"sheet":"&_Prefix","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Utilizing \"&\" Operator"]
[]
[null,"Name","Name with Prefix"]
[null,"Stephen",{"$f":"\"Dr. \"&B5","v":"Dr. Stephen"}]
[null,"Lenon",{"$f":"\"Dr. \"&B6","v":"Dr. Lenon"}]
[null,"Gilmour","Dr. Gilmour"]
[null,"David","Dr. David"]
[null,"Adeline","Dr. Adeline"]

{"sheet":"&_Suffix","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Utilizing \"&\" Operator"]
[]
[null,"Name","Name with Suffix"]
[null,"Samsung",{"$f":"B5&\" Mobile\"","v":"Samsung Mobile"}]
[null,"Apple",{"$f":"B6&\" Mobile\"","v":"Apple Mobile"}]
[null,"Nokia",{"$f":"B7&\" Mobile\"","v":"Nokia Mobile"}]
[null,"Blackberry","Blackberry Mobile"]
[null,"One Plus","One Plus Mobile"]