{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Ampersand","CONCATENATE","Format Cells","Power Query","VBA","BOth","Leading Zero by Formatting","Leading Zero with TEXT function","Remove"],"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":"Ampersand","index":0,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Add Prefix and Suffix Using Ampersand Operator ",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Prefix","Name","Name with Prefix","Suffix","Name with Suffix",null,null,null,null,"Prefix","Name","Name with Prefix","Suffix","Name with Suffix"]
[null,"Dr.","Robert",{"$f":"B5&\" \"&C5","v":"Dr. Robert"},"PHD",{"$f":"D5&\",\"&E5","v":"Dr. Robert,PHD"},null,null,null,null,"Dr.","Robert",null,"PHD"]
[null,"Dr.","Sherron",{"$f":"B6&\" \"&C6","v":"Dr. Sherron"},"PHD",{"$f":"D6&\",\"&E6","v":"Dr. Sherron,PHD"},null,null,null,null,"Dr.","Sherron",null,"PHD"]
[null,"Dr.","Sheldon",{"$f":"B7&\" \"&C7","v":"Dr. Sheldon"},"PHD",{"$f":"D7&\",\"&E7","v":"Dr. Sheldon,PHD"},null,null,null,null,"Dr.","Sheldon",null,"PHD"]
[null,"Dr.","Leanard",{"$f":"B8&\" \"&C8","v":"Dr. Leanard"},"PHD",{"$f":"D8&\",\"&E8","v":"Dr. Leanard,PHD"},null,null,null,null,"Dr.","Leanard",null,"PHD"]
[null,"Dr.","Penny",{"$f":"B9&\" \"&C9","v":"Dr. Penny"},"PHD",{"$f":"D9&\",\"&E9","v":"Dr. Penny,PHD"},null,null,null,null,"Dr.","Penny",null,"PHD"]

{"sheet":"CONCATENATE","index":1,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Add Prefix and Suffix Using CONCATENATE Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Prefix","Name","Name with Prefix","Suffix","Name with Suffix",null,null,null,null,"Prefix","Name","Name with Prefix","Suffix","Name with Suffix"]
[null,"Dr.","Robert",{"$f":"CONCATENATE(B5,\" \",C5)","v":"Dr. Robert"},"PHD",{"$f":"CONCATENATE(D5,\",\",E5)","v":"Dr. Robert,PHD"},null,null,null,null,"Dr.","Robert",null,"PHD"]
[null,"Dr.","Sherron",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Dr. Sherron"},"PHD",{"$f":"CONCATENATE(D6,\",\",E6)","v":"Dr. Sherron,PHD"},null,null,null,null,"Dr.","Sherron",null,"PHD"]
[null,"Dr.","Sheldon",{"$f":"CONCATENATE(B7,\" \",C7)","v":"Dr. Sheldon"},"PHD",{"$f":"CONCATENATE(D7,\",\",E7)","v":"Dr. Sheldon,PHD"},null,null,null,null,"Dr.","Sheldon",null,"PHD"]
[null,"Dr.","Leanard",{"$f":"CONCATENATE(B8,\" \",C8)","v":"Dr. Leanard"},"PHD",{"$f":"CONCATENATE(D8,\",\",E8)","v":"Dr. Leanard,PHD"},null,null,null,null,"Dr.","Leanard",null,"PHD"]
[null,"Dr.","Penny",{"$f":"CONCATENATE(B9,\" \",C9)","v":"Dr. Penny"},"PHD",{"$f":"CONCATENATE(D9,\",\",E9)","v":"Dr. Penny,PHD"},null,null,null,null,"Dr.","Penny",null,"PHD"]

{"sheet":"Format Cells","index":2,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Add Prefix and Suffix Using Format Cells",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Name with Prefix","Name with Suffix",null,null,null,null,null,null,"Name","Name with Prefix","Name with Suffix"]
[null,"Robert","Robert","Robert",null,null,null,null,null,null,"Robert"]
[null,"Sherron","Sherron","Sherron",null,null,null,null,null,null,"Sherron"]
[null,"Sheldon","Sheldon","Sheldon",null,null,null,null,null,null,"Sheldon"]
[null,"Leanard","Leanard","Leanard",null,null,null,null,null,null,"Leanard"]
[null,"Penny","Penny","Penny",null,null,null,null,null,null,"Penny"]

{"sheet":"Power Query","index":3,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Add Prefix and Suffix Using Power Query",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Name",null,null,null,null,null,null,null,"Name","Name"]
[null,"Robert","Dr.Robert,PHD",null,null,null,null,null,null,null,"Robert"]
[null,"Sherron","Dr.Sherron,PHD",null,null,null,null,null,null,null,"Sherron"]
[null,"Sheldon","Dr.Sheldon,PHD",null,null,null,null,null,null,null,"Sheldon"]
[null,"Leanard","Dr.Leanard,PHD",null,null,null,null,null,null,null,"Leanard"]
[null,"Penny","Dr.Penny,PHD",null,null,null,null,null,null,null,"Penny"]

{"sheet":"VBA","index":4,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Add Prefix and Suffix Using VBA Macro",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Name with Prefix","Name with Suffix",null,null,null,null,null,null,"Name","Name with Prefix","Name with Suffix"]
[null,"Robert","Dr. Robert","Robert,PHD",null,null,null,null,null,null,"Robert"]
[null,"Sherron","Dr. Sherron","Sherron,PHD",null,null,null,null,null,null,"Sherron"]
[null,"Sheldon","Dr. Sheldon","Sheldon,PHD",null,null,null,null,null,null,"Sheldon"]
[null,"Leanard","Dr. Leanard","Leanard,PHD",null,null,null,null,null,null,"Leanard"]
[null,"Penny","Dr. Penny","Penny,PHD",null,null,null,null,null,null,"Penny"]

{"sheet":"BOth","index":5,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Add Both Prefix and Suffix Using CONCATENATE Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Prefix","Name","Suffix","Name with Pefix & Suffix",null,null,null,null,null,"Prefix","Name","Suffix","Name with Pefix & Suffix"]
[null,"Dr.","Robert","PHD",{"$f":"CONCATENATE(B5,\" \",C5,\",\",D5)","v":"Dr. Robert,PHD"},null,null,null,null,null,"Dr.","Robert","PHD"]
[null,"Dr.","Sherron","PHD",{"$f":"CONCATENATE(B6,\" \",C6,\",\",D6)","v":"Dr. Sherron,PHD"},null,null,null,null,null,"Dr.","Sherron","PHD"]
[null,"Dr.","Sheldon","PHD",{"$f":"CONCATENATE(B7,\" \",C7,\",\",D7)","v":"Dr. Sheldon,PHD"},null,null,null,null,null,"Dr.","Sheldon","PHD"]
[null,"Dr.","Leanard","PHD",{"$f":"CONCATENATE(B8,\" \",C8,\",\",D8)","v":"Dr. Leanard,PHD"},null,null,null,null,null,"Dr.","Leanard","PHD"]
[null,"Dr.","Penny","PHD",{"$f":"CONCATENATE(B9,\" \",C9,\",\",D9)","v":"Dr. Penny,PHD"},null,null,null,null,null,"Dr.","Penny","PHD"]

{"sheet":"Leading Zero by Formatting","index":6,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Add 0 as Prefix by Formatting As Text",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Phone Numbers","Phone Numbers With 0 As Prefix",null,null,null,null,null,null,null,"Phone Numbers","Phone Numbers With 0 As Prefix"]
[null,17123456789,"017123456789",null,null,null,null,null,null,null,17123456789]
[null,17214365987,"017214365987",null,null,null,null,null,null,null,17214365987]
[null,17521463987,"017521463987",null,null,null,null,null,null,null,17521463987]
[null,17825274196,"017825274196",null,null,null,null,null,null,null,17825274196]
[null,17987643215,"017987643215",null,null,null,null,null,null,null,17987643215]

{"sheet":"Leading Zero with TEXT function","index":7,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Add 0 as Prefix Using TEXT Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Phone Numbers","Phone Numbers With 0 As Prefix",null,null,null,null,null,null,null,"Phone Numbers","Phone Numbers With 0 As Prefix"]
[null,17123456789,{"$f":"TEXT(B5,\"000000000000\")","v":"017123456789"},null,null,null,null,null,null,null,17123456789]
[null,17214365987,{"$f":"TEXT(B6,\"000000000000\")","v":"017214365987"},null,null,null,null,null,null,null,17214365987]
[null,17521463987,{"$f":"TEXT(B7,\"000000000000\")","v":"017521463987"},null,null,null,null,null,null,null,17521463987]
[null,17825274196,{"$f":"TEXT(B8,\"000000000000\")","v":"017825274196"},null,null,null,null,null,null,null,17825274196]
[null,17987643215,{"$f":"TEXT(B9,\"000000000000\")","v":"017987643215"},null,null,null,null,null,null,null,17987643215]

{"sheet":"Remove","index":8,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Remove Prefix and Suffix",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Designation","Name without Prefix","Name without Suffix",null,null,null,null,null,null,"Designation","Name without Prefix","Name without Suffix"]
[null,"Dr. Robert,PHD",{"$f":"RIGHT(B5,LEN(B5)-4)","v":"Robert,PHD"},{"$f":"LEFT(C5,LEN(C5)-4)","v":"Robert"},null,null,null,null,null,null,"Dr. Robert,PHD"]
[null,"Dr. Sherron,PHD",{"$f":"RIGHT(B6,LEN(B6)-4)","v":"Sherron,PHD"},{"$f":"LEFT(C6,LEN(C6)-4)","v":"Sherron"},null,null,null,null,null,null,"Dr. Sherron,PHD"]
[null,"Dr. Sheldon,PHD",{"$f":"RIGHT(B7,LEN(B7)-4)","v":"Sheldon,PHD"},{"$f":"LEFT(C7,LEN(C7)-4)","v":"Sheldon"},null,null,null,null,null,null,"Dr. Sheldon,PHD"]
[null,"Dr. Leanard,PHD",{"$f":"RIGHT(B8,LEN(B8)-4)","v":"Leanard,PHD"},{"$f":"LEFT(C8,LEN(C8)-4)","v":"Leanard"},null,null,null,null,null,null,"Dr. Leanard,PHD"]
[null,"Dr. Penny,PHD",{"$f":"RIGHT(B9,LEN(B9)-4)","v":"Penny,PHD"},{"$f":"LEFT(C9,LEN(C9)-4)","v":"Penny"},null,null,null,null,null,null,"Dr. Penny,PHD"]