{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cells.Value","Range.Value","Font Settings","Concatenate Function","with Line Breaks","Text and Numbers Format"],"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":"Cells.Value","index":0,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Cells.Value Property in VBA",null,null,null,"Practice Here"]
[]
[null,"First Name","Last Name","Full Name",null,"First Name","Last Name","Full Name"]
[null,"Maria","Garcia","Maria Garcia",{"$f":"B5 & CHAR(2)","v":"Maria\u0002"},"Maria","Garcia"]
[null,"Robert","Smith","Robert Smith",null,"Robert","Smith"]
[null,"Amy","Scott","Amy Scott",null,"Amy","Scott"]
[null,"Penny","Diaz","Penny Diaz",null,"Penny","Diaz"]
[null,"James","Smith","James Smith",null,"James","Smith"]
[null,"Sylvia ","Plath","Sylvia  Plath",null,"Sylvia ","Plath",null," "]
[null,"Malcom ","Archer","Malcom  Archer",null,"Malcom ","Archer",null,null," "]
[null,"David","Atherton","David Atherton",null,"David","Atherton",null,null,null," "]
[null,"Pete ","Atkin","Pete  Atkin",null,"Pete ","Atkin",null,null,null,null," "]
[null,"Herold ","Perkin ","Herold  Perkin ",null,"Herold ","Perkin ",null,null,null,null,null," "]
[null,"Michael","Foale","Michael Foale",null,"Michael","Foale",null,null,null,null,null,null," "]

{"sheet":"Range.Value","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Range.Value Property in VBA",null,null,null,"Practice Here"]
[]
[null,"First Name","Last Name","Full Name",null,"First Name","Last Name","Full Name"]
[null,"Maria","Garcia","Maria Garcia",{"$f":"B5 & CHAR(2)","v":"Maria\u0002"},"Maria","Garcia"]
[null,"Robert","Smith","Robert Smith",null,"Robert","Smith"]
[null,"Amy","Scott","Amy Scott",null,"Amy","Scott"]
[null,"Penny","Diaz","Penny Diaz",null,"Penny","Diaz"]
[null,"James","Smith","James Smith",null,"James","Smith"]
[null,"Sylvia ","Plath","Sylvia  Plath",null,"Sylvia ","Plath",null," "]
[null,"Malcom ","Archer","Malcom  Archer",null,"Malcom ","Archer",null,null," "]
[null,"David","Atherton","David Atherton",null,"David","Atherton",null,null,null," "]
[null,"Pete ","Atkin","Pete  Atkin",null,"Pete ","Atkin",null,null,null,null," "]
[null,"Herold ","Perkin ","Herold  Perkin ",null,"Herold ","Perkin ",null,null,null,null,null," "]
[null,"Michael","Foale","Michael Foale",null,"Michael","Foale",null,null,null,null,null,null," "]

{"sheet":"Font Settings","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Font Settings to Concatenate Different Fonts"]
[]
[null,"Concatenate Fonts"]

{"sheet":"Concatenate Function","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Concatenating Cells with Different Formats",null,null,null,"Practice Here"]
[]
[null,"Product","Price","Concatenation",null,"Product","Price","Concatenation"]
[null,"SSD",100,{"$f":"CONCATENATE(B5, \" Price: \", TEXT(C5,\"$#,##0.00_);($#,##0.00)\"))","v":"SSD Price: $100.00 "},null,"SSD",100]
[null,"HDD",40,{"$f":"CONCATENATE(B6, \" Price: \", TEXT(C6,\"$#,##0.00_);($#,##0.00)\"))","v":"HDD Price: $40.00 "},null,"HDD",40]
[null,"RAM",25,"RAM Price: $25.00 ",null,"RAM",25]
[null,"Keyboard",20,"Keyboard Price: $20.00 ",null,"Keyboard",20]
[null,"Pendrive",15,"Pendrive Price: $15.00 ",null,"Pendrive",15]
[null,"Webcam",150,"Webcam Price: $150.00 ",null,"Webcam",150]

{"sheet":"with Line Breaks","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Concatenating Text Strings with Line Breaks",null,null,null,null,"Practice Here"]
[]
[null,"Product","Model","Product ID","Concatenation",null,"Product","Model","Product ID","Concatenation"]
[null,"SSD","Samsung 970 EVO Plus","MZ-V7S1T0B/AM",{"$f":" CONCATENATE(B5, \" \", C5, CHAR(10),D5)","v":"SSD Samsung 970 EVO Plus\nMZ-V7S1T0B/AM"},null,"SSD","Samsung 970 EVO Plus","MZ-V7S1T0B/AM"]
[null,"HDD","Seagate BarraCuda 4TB ","ST4000DM004",{"$f":" CONCATENATE(B6, \" \", C6, CHAR(10),D6)","v":"HDD Seagate BarraCuda 4TB \nST4000DM004"},null,"HDD","Seagate BarraCuda 4TB ","ST4000DM004"]
[null,"RAM","Corsair Vengeance LPX 16GB","CMK16GX4M2B3","RAM Corsair Vengeance LPX 16GB\nCMK16GX4M2B3",null,"RAM","Corsair Vengeance LPX 16GB","CMK16GX4M2B3"]
[null,"Keyboard","Logitech G Pro","920-008290","Keyboard Logitech G Pro\n920-008290",null,"Keyboard","Logitech G Pro","920-008290"]
[null,"Pendrive","SanDisk Ultra Flair 64GB","SDCZ73-064G","Pendrive SanDisk Ultra Flair 64GB\nSDCZ73-064G",null,"Pendrive","SanDisk Ultra Flair 64GB","SDCZ73-064G"]
[null,"Webcam","Logitech C920 HD","960-000764","Webcam Logitech C920 HD\n960-000764",null,"Webcam","Logitech C920 HD","960-000764"]

{"sheet":"Text and Numbers Format","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Concatenating Text and Numbers Keeping Formatting",null,null,null,"Practice Here"]
[]
[null,"Product","Shipping Code","Concatenation",null,"Product","Shipping Code","Concatenation"]
[null,"SSD",11.23,{"$f":"B5 & \" \" & TEXT(C5, \"$#,#0.00\")","v":"SSD $11.23"},null,"SSD",11.23]
[null,"HDD",156.30000000000001,{"$f":"B6 & \" \" & TEXT(C6, \"$#,#0.00\")","v":"HDD $156.30"},null,"HDD",156.30000000000001]
[null,"RAM",240.5,"RAM $240.50",null,"RAM",240.5]
[null,"Keyboard",510.89,"Keyboard $510.89",null,"Keyboard",510.89]
[null,"Pendrive",312.12,"Pendrive $312.12",null,"Pendrive",312.12]
[null,"Webcam",105.2,"Webcam $105.20",null,"Webcam",105.2]