{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Problem","VBA Function","Comments","Result"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":2,"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":"Problem","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Extract Comments from Cells"]
[]
[null,"Date","Description","Total"]
[null,"2022-01-01","NY to Philadelphia",30]
[null,"2022-01-01","Philadelphia to NY",30]
[null,"2022-01-02","NY to Marryland",340]
[null,"2022-01-02","Hyatt Regency Baltimore Inner Harbor",230]
[null,"2022-01-02","Lunch & Dinner",55.42]
[null,"2022-01-02","Others in Marryland",100]
[null,"2022-01-03","Breakfast",39.22]
[null,"2022-01-06","Manhattan to Buffalo",50]
[null,"2022-01-07","Buffalo to Manhattan",50]
[null,null,"Total :",{"$f":"SUBTOTAL(109,Problem!$D$5:$D$13)","v":924.64}]

{"sheet":"VBA Function","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using User Defined Function"]
[]
[null,"Date","Description","Total","Extracted Comments"]
[null,"2022-01-01","NY to Philadelphia",30,{"$f":"[1]!Extract_Comments(C5)","v":"Asus:\nNY stands for New York"}]
[null,"2022-01-01","Philadelphia to NY",30,{"$f":"[1]!Extract_Comments(C6)","v":"Asus:\nNY stands for New York"}]
[null,"2022-01-02","NY to Marryland",340,{"$f":"[1]!Extract_Comments(C7)","v":"Asus:\nNY stands for New York"}]
[null,"2022-01-02","Hyatt Regency Baltimore Inner Harbor",230,{"$f":"[1]!Extract_Comments(C8)","v":"Asus: Hotel in Marryland"}]
[null,"2022-01-02","Lunch & Dinner",55.42,{"$f":"[1]!Extract_Comments(C9)","v":""}]
[null,"2022-01-02","Others in Marryland",100,{"$f":"[1]!Extract_Comments(C10)","v":""}]
[null,"2022-01-03","Breakfast",39.22,{"$f":"[1]!Extract_Comments(C11)","v":""}]
[null,"2022-01-06","Manhattan to Buffalo",50,{"$f":"[1]!Extract_Comments(C12)","v":""}]
[null,"2022-01-07","Buffalo to Manhattan",50,{"$f":"[1]!Extract_Comments(C13)","v":""}]
[null,null,"Total :",{"$f":"SUBTOTAL(109,Problem!$D$5:$D$13)","v":924.64},{"$f":"[1]!Extract_Comments(C14)","v":""}]

{"sheet":"Comments","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Extract Comments Add-in and VBA Macro"]
[]
[null,"Reference","Author","Comment"]
[null,"$C$5","Asus","NY stands for New York"]
[null,"$C$6","Asus","NY stands for New York"]
[null,"$C$7","Asus","NY stands for New York"]
[null,"$C$8","Asus","Hotel in Marryland"]

{"sheet":"Result","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Extracting Comments to a New Sheet"]
[]
[null,"Reference ","Author","Comment"]
[null,"Problem'!$C$5","Asus","Asus:\nNY stands for New York"]
[null,"Problem'!$C$6","Asus","Asus:\nNY stands for New York"]
[null,"Problem'!$C$7","Asus","Asus:\nNY stands for New York"]
[null,"Problem'!$C$8","Asus","Asus:\nHotel in Marryland"]