{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ISBLANK","TEXTJOIN","TEXTJOIN (dash)","Len-TRIM","Len-TRIM (2)","If-ampersand","VBA"],"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":"ISBLANK","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using CONCATENATE, IF, and ISBLANK Functions"]
[]
[null,"Text",null,"Output",{"$f":"CONCATENATE(IF(ISBLANK(B5),\"\",B5),IF(ISBLANK(B6),\"\",B6),IF(ISBLANK(B7),\"\",B7),IF(ISBLANK(B8),\"\",B8),IF(ISBLANK(B9),\"\",B9))","v":"MicrosoftExcel365"}]
[null,"Microsoft"]
[]
[null,"Excel"]
[]
[null,365]

{"sheet":"TEXTJOIN","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using TEXTJOIN Function"]
[]
[null,"Text",null,"Output",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B5:B9)","v":"Microsoft,Excel,365"}]
[null,"Microsoft"]
[]
[null,"Excel"]
[]
[null,365]

{"sheet":"TEXTJOIN (dash)","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using TEXTJOIN Function"]
[]
[null,"Text",null,"Output",{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,B5:B9)","v":"Microsoft-Excel-365"}]
[null,"Microsoft"]
[]
[null,"Excel"]
[]
[null,365]

{"sheet":"Len-TRIM","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Ampersand"]
[]
[null,"Text",null,"Output",{"$f":"B5&B6&B7&B8&B9","v":"Microsoft Excel365"}]
[null,"Microsoft"]
[null," "]
[null,"Excel"]
[]
[null,365]

{"sheet":"Len-TRIM (2)","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using LEN, TRIM and IF Functions"]
[]
[null,"Text",null,"Output",{"$f":"IF(LEN(TRIM(B5))=0,\"\",B5) & IF(LEN(TRIM(B6))=0,\"\",B6) & IF(LEN(TRIM(B7))=0,\"\",B7)& IF(LEN(TRIM(B8))=0,\"\",B8)& IF(LEN(TRIM(B9))=0,\"\",B9)","v":"MicrosoftExcel365"}]
[null,"Microsoft"]
[null,"   "]
[null,"Excel"]
[]
[null,365]

{"sheet":"If-ampersand","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using IF and Ampersand"]
[]
[null,"Text",null,"Output",{"$f":"B5&IF(B6<>\"\",\"-\"&B6,\"\")&IF(B7<>\"\",\"-\"&B7,\"\")&IF(B8<>\"\",\"-\"&B8,\"\")&IF(B9<>\"\",\"-\"&B9,\"\")","v":"Microsoft-Excel-365"}]
[null,"Microsoft"]
[]
[null,"Excel"]
[]
[null,365]

{"sheet":"VBA","index":6,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Codes"]
[]
[null,"Text",null,"Output",{"$f":"combine_cells(B5:B9)","v":"Microsoft-Excel-365"}]
[null,"Microsoft"]
[]
[null,"Excel"]
[]
[null,365]