{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Ampersand","CONCATENATE Function","TEXTJOIN","Keyboard Shortcuts","VBA","Power Query Dataset","Name and Address"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Dataset","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Dataset for Carriage Return in Excel Formula Concatenate"]
[]
[null,"Last Name","First Name","Business Address","City","State","Zip Code"]
[null,"Smith","Martin","47 Aspen Avenue","Gibsonia","PA",15044]
[null,"Thoms","Adrienne","494 Columbia Avenue","Salem","MA",1970]
[null,"Magil","Lena","221 Dogwood Avenue","Corpus Christi","TX",78418]
[null,"Nelson ","Nick","30 Sheffield Court","Chandler","AX",85224]
[null,"Hope","Jay","846 Wild House Dr.","Goose Creak","SC",29445]

{"sheet":"Ampersand","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Ampersand to Insert Carriage Return"]
[]
[null,"Last Name","First Name","Business Address","City","State","Zip Code","Carriage Return in Formula Concatenate"]
[null,"Smith","Martin","47 Aspen Avenue","Gibsonia","PA",15044,{"$f":"B5&CHAR(32)&C5&CHAR(10)&D5&CHAR(44)&E5&CHAR(44)&F5&CHAR(44)&G5","v":"Smith Martin\n47 Aspen Avenue,Gibsonia,PA,15044"}]
[null,"Thoms","Adrienne","494 Columbia Avenue","Salem","MA",1970,{"$f":"B6&CHAR(32)&C6&CHAR(10)&D6&CHAR(44)&E6&CHAR(44)&F6&CHAR(44)&G6","v":"Thoms Adrienne\n494 Columbia Avenue,Salem,MA,1970"}]
[null,"Magil","Lena","221 Dogwood Avenue","Corpus Christi","TX",78418,"Magil Lena\n221 Dogwood Avenue,Corpus Christi,TX,78418"]
[null,"Nelson ","Nick","30 Sheffield Court","Chandler","AX",85224,"Nelson  Nick\n30 Sheffield Court,Chandler,AX,85224"]
[null,"Nelson ","Nick","31 Sheffield Court","Chandler","AX",85225,"Nelson  Nick\n31 Sheffield Court,Chandler,AX,85225"]

{"sheet":"CONCATENATE Function","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using CONCATENATE Function to Insert Carriage Return"]
[]
[null,"Last Name","First Name","Business Address","City","State","Zip Code","Carriage Return in Formula Concatenate"]
[null,"Smith","Martin","47 Aspen Avenue","Gibsonia","PA",15044,{"$f":"CONCATENATE(B5,CHAR(32), C5,CHAR(10),D5,CHAR(44),E5,CHAR(44),F5,CHAR(44),G5)","v":"Smith Martin\n47 Aspen Avenue,Gibsonia,PA,15044"}]
[null,"Thoms","Adrienne","494 Columbia Avenue","Salem","MA",1970,{"$f":"CONCATENATE(B6,CHAR(32), C6,CHAR(10),D6,CHAR(44),E6,CHAR(44),F6,CHAR(44),G6)","v":"Thoms Adrienne\n494 Columbia Avenue,Salem,MA,1970"}]
[null,"Magil","Lena","221 Dogwood Avenue","Corpus Christi","TX",78418,"Magil Lena\n221 Dogwood Avenue,Corpus Christi,TX,78418"]
[null,"Nelson ","Nick","30 Sheffield Court","Chandler","AX",85224,"Nelson  Nick\n30 Sheffield Court,Chandler,AX,85224"]
[null,"Nelson ","Nick","31 Sheffield Court","Chandler","AX",85225,"Nelson  Nick\n31 Sheffield Court,Chandler,AX,85225"]

{"sheet":"TEXTJOIN","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using TEXTJOIN to Insert Carriage Return"]
[]
[null,"Last Name","First Name","Business Address","City","State","Zip Code","Carriage Return in Formula Concatenate"]
[null,"Smith","Martin","47 Aspen Avenue","Gibsonia","PA",15044,{"$f":"_xlfn.TEXTJOIN(CHAR(10),FALSE,B5&CHAR(32)&C5,D5&CHAR(44)&E5&CHAR(44)&F5&CHAR(44)&G5)","v":"Smith Martin\n47 Aspen Avenue,Gibsonia,PA,15044"}]
[null,"Thoms","Adrienne","494 Columbia Avenue","Salem","MA",1970,{"$f":"_xlfn.TEXTJOIN(CHAR(10),FALSE,B6&CHAR(32)&C6,D6&CHAR(44)&E6&CHAR(44)&F6&CHAR(44)&G6)","v":"Thoms Adrienne\n494 Columbia Avenue,Salem,MA,1970"}]
[null,"Magil","Lena","221 Dogwood Avenue","Corpus Christi","TX",78418,"Magil Lena\n221 Dogwood Avenue,Corpus Christi,TX,78418"]
[null,"Nelson ","Nick","30 Sheffield Court","Chandler","AX",85224,"Nelson  Nick\n30 Sheffield Court,Chandler,AX,85224"]
[null,"Nelson ","Nick","31 Sheffield Court","Chandler","AX",85225,"Nelson  Nick\n31 Sheffield Court,Chandler,AX,85225"]

{"sheet":"Keyboard Shortcuts","index":4,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Keyboard Shrtcuts to Insert Carriage Return"]
[]
[null,"Last Name","First Name","Business Address","City","State","Zip Code","Carriage Return in Formula Concatenate"]
[null,"Smith","Martin","47 Aspen Avenue","Gibsonia","PA",15044,"Smith Martin\n47 Aspen Avenue,Gibsonia,PA,15044"]
[null,"Thoms","Adrienne","494 Columbia Avenue","Salem","MA",1970,"Smith Martin\n47 Aspen Avenue,Gibsonia,PA,15045"]
[null,"Magil","Lena","221 Dogwood Avenue","Corpus Christi","TX",78418,"Smith Martin\n47 Aspen Avenue,Gibsonia,PA,15046"]
[null,"Nelson ","Nick","30 Sheffield Court","Chandler","AX",85224,"Smith Martin\n47 Aspen Avenue,Gibsonia,PA,15047"]
[null,"Nelson ","Nick","31 Sheffield Court","Chandler","AX",85225,"Smith Martin\n47 Aspen Avenue,Gibsonia,PA,15048"]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Macro to Carriage Return Formula Concatenate"]
[]
[null,"Name","Business Address","Carriage Return in Formula Concatenate"]
[null,"Smith Martin","47 Aspen Avenue,Gibsonia,PA, 15044",{"$f":"CrgRtrn(B5,C5)","v":"Smith Martin\n47 Aspen Avenue,Gibsonia,PA, 15044"}]
[null,"Thoms Adrienne","494 Columbia Avenue,Salem,MA,1970",{"$f":"CrgRtrn(B6,C6)","v":"Thoms Adrienne\n494 Columbia Avenue,Salem,MA,1970"}]
[null,"Magil Lena","221 Dogwood Avenue,Corpus Christi,TX,78418",{"$f":"CrgRtrn(B7,C7)","v":"Magil Lena\n221 Dogwood Avenue,Corpus Christi,TX,78418"}]
[null,"Nelson Nick","30 Sheffield Court,Chandler,AX,85224",{"$f":"CrgRtrn(B8,C8)","v":"Nelson Nick\n30 Sheffield Court,Chandler,AX,85224"}]
[null,"Hope Jay","31 Sheffield Court,Chandler,AX,85225",{"$f":"CrgRtrn(B9,C9)","v":"Hope Jay\n31 Sheffield Court,Chandler,AX,85225"}]

{"sheet":"Power Query Dataset","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Power Query to Insert Cariage Return "]
[]
[null,"Name","Business Address"]
[null,"Smith Martin","47 Aspen Avenue,Gibsonia,PA, 15044"]
[null,"Thoms Adrienne","494 Columbia Avenue,Salem,MA,1970"]
[null,"Magil Lena","221 Dogwood Avenue,Corpus Christi,TX,78418"]
[null,"Nelson Nick","30 Sheffield Court,Chandler,AX,85224"]
[null,"Hope Jay","31 Sheffield Court,Chandler,AX,85225"]

{"sheet":"Name and Address","index":7,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Name","Business Address","Address Labels"]
["Smith Martin","47 Aspen Avenue,Gibsonia,PA, 15044","Smith Martin\n47 Aspen Avenue,Gibsonia,PA, 15044"]
["Thoms Adrienne","494 Columbia Avenue,Salem,MA,1970","Thoms Adrienne\n494 Columbia Avenue,Salem,MA,1970"]
["Magil Lena","221 Dogwood Avenue,Corpus Christi,TX,78418","Magil Lena\n221 Dogwood Avenue,Corpus Christi,TX,78418"]
["Nelson Nick","30 Sheffield Court,Chandler,AX,85224","Nelson Nick\n30 Sheffield Court,Chandler,AX,85224"]
["Hope Jay","31 Sheffield Court,Chandler,AX,85225","Hope Jay\n31 Sheffield Court,Chandler,AX,85225"]