{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Dataset","Flash Fill","Keyboard Shortcut","2.1 RIGHT,LEN,SEARCH, LEFT","2.2 MID, SEARCH,LEFT","2.3 MID,FIND,LEN","2.4 MID, SEARCH, LEN","2.5 REPLACE, SEARCH, LEFT","2.6 CONCAT,RIGHT,LEN,FIND,LEFT","2.7CONCATE,TEXTAFTER,TEXTBEFORE","2.8 Middle Name","2.9 TEXTSPLIT","3.Text to Columns and CONCAT","4. Power Query","Sheet8","5. Power_Pivot","6.VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Switch First and Last Name with Comma"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith"]
[null,"Sarah Davis"]
[null,"James Anderson"]
[null,"David Martinez"]
[null,"Robert Wilson"]

{"sheet":"Flash Fill","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Switch First and Last Name with Comma (Using Flash Fill)"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith","Smith, Emily"]
[null,"Sarah Davis","Davis, Sarah"]
[null,"James Anderson","Anderson, James"]
[null,"David Martinez","Martinez, David"]
[null,"Robert Wilson","Wilson, Robert"]

{"sheet":"Keyboard Shortcut","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Keyboard Shortcut (Ctrl+E) to Flash Fill"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith","Smith, Emily"]
[null,"Sarah Davis","Davis, Sarah"]
[null,"James Anderson","Anderson, James"]
[null,"David Martinez","Martinez, David"]
[null,"Robert Wilson","Wilson, Robert"]

{"sheet":"2.1 RIGHT,LEN,SEARCH, LEFT","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Merging RIGHT, LEN, SEARCH, and LEFT Functions"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith",{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\" \",B5))&\", \"&LEFT(B5,SEARCH(\" \",B5)-1)","v":"Smith, Emily"},null,null,null,"Smith, Emily"]
[null,"Sarah Davis",{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\" \",B6))&\", \"&LEFT(B6,SEARCH(\" \",B6)-1)","v":"Davis, Sarah"}]
[null,"James Anderson","Anderson, James"]
[null,"David Martinez","Martinez, David"]
[null,"Robert Wilson","Wilson, Robert"]

{"sheet":"2.2 MID, SEARCH,LEFT","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null," Using MID, SEARCH, and LEFT Functions"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith",{"$f":"MID(B5,SEARCH(\" \",B5)+1,30)&\", \"&LEFT(B5,SEARCH(\" \",B5)-1)","v":"Smith, Emily"}]
[null,"Sarah Davis","Davis, Sarah"]
[null,"James Anderson","Anderson, James"]
[null,"David Martinez","Martinez, David"]
[null,"Robert Wilson","Wilson, Robert"]

{"sheet":"2.3 MID,FIND,LEN","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Joining MID, FIND, and LEN Functions"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith",{"$f":"MID(B5&\", \"&B5,FIND(\" \",B5)+1,LEN(B5)+1)","v":"Smith, Emily"}]
[null,"Sarah Davis","Davis, Sarah"]
[null,"James Anderson","Anderson, James"]
[null,"David Martinez","Martinez, David"]
[null,"Robert Wilson","Wilson, Robert"]

{"sheet":"2.4 MID, SEARCH, LEN","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combining MID, SEARCH, and LEN Functions"]
[]
[null,"First Name, Last Name","Last Name First Name"]
[null,"Emily, Smith",{"$f":"MID(B5&\" \"&B5,SEARCH(\", \",B5)+2,LEN(B5)-1)","v":"Smith Emily"}]
[null,"Sarah, Davis",{"$f":"MID(B6&\" \"&B6,SEARCH(\", \",B6)+2,LEN(B6)-1)","v":"Davis Sarah"}]
[null,"James, Anderson","Anderson James"]
[null,"David, Martinez","Martinez David"]
[null,"Robert, Wilson","Wilson Robert"]

{"sheet":"2.5 REPLACE, SEARCH, LEFT","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using REPLACE, SEARCH, and LEFT Functions"]
[]
[null,"First Name, Last Name","Last Name First Name"]
[null,"Emily, Smith",{"$f":"REPLACE(B5,1,SEARCH(\",\",B5)+1,\"\")&\" \"&LEFT(B5,SEARCH(\",\",B5)-1)","v":"Smith Emily"}]
[null,"Sarah, Davis","Davis Sarah"]
[null,"James, Anderson","Anderson James"]
[null,"David, Martinez","Martinez David"]
[null,"Robert, Wilson","Wilson Robert"]

{"sheet":"2.6 CONCAT,RIGHT,LEN,FIND,LEFT","index":8,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combining CONCAT, RIGHT, LEN, FIND, LEFT Functions"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith",{"$f":"_xlfn.CONCAT(RIGHT(B5,LEN(B5)-FIND(\" \",B5)),\", \",LEFT(B5,FIND(\" \",B5)-1))","v":"Smith, Emily"}]
[null,"Sarah Davis","Davis, Sarah"]
[null,"James Anderson","Anderson, James"]
[null,"David Martinez","Martinez, David"]
[null,"Robert Wilson","Wilson, Robert"]

{"sheet":"2.7CONCATE,TEXTAFTER,TEXTBEFORE","index":9,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combining CONCAT, TEXTAFTER, and TEXTBEFORE Functions"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith",{"$f":"_xlfn.CONCAT(_xlfn.TEXTAFTER(B5,\" \"), \", \",_xlfn.TEXTBEFORE(B5, \" \"))","v":"Smith, Emily"}]
[null,"Sarah Davis","Davis, Sarah"]
[null,"James Anderson","Anderson, James"]
[null,"David Martinez","Martinez, David"]
[null,"Robert Wilson","Wilson, Robert"]

{"sheet":"2.8 Middle Name","index":10,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Switch First and Last Name with Comma (If Middle Name Exists)"]
[]
[null,"First Name Middle Name Last Name","Last Name","First Name","Last Name, First Name"]
[null,"Emily M. Smith",{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\"#\",SUBSTITUTE(B5,\" \",\"#\",LEN(B5)-LEN(SUBSTITUTE(B5,\" \",\"\")))))","v":"Smith"},{"$f":"LEFT(B5,SEARCH(\" \",B5)-1)","v":"Emily"},{"$f":"_xlfn.CONCAT(C5,\", \",D5)","v":"Smith, Emily"}]
[null,"Sarah L. Davis","Davis","Sarah",{"$f":"_xlfn.CONCAT(C6,\", \",D6)","v":"Davis, Sarah"}]
[null,"James Peter Anderson","Anderson","James","Anderson, James"]
[null,"David Edward Martinez","Martinez","David","Martinez, David"]
[null,"Robert A. Wilson","Wilson","Robert","Wilson, Robert"]

{"sheet":"2.9 TEXTSPLIT","index":11,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combining TEXTSPLIT Function with Other Functions"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.SORTBY(TRANSPOSE(_xlfn.TEXTSPLIT(B5,\" \")),_xlfn.SEQUENCE(COUNTA(_xlfn.TEXTSPLIT(B5,\" \"))),-1))","v":"Smith, Emily"}]
[null,"Sarah Davis","Davis, Sarah"]
[null,"James Anderson","Anderson, James"]
[null,"David Martinez","Martinez, David"]
[null,"Robert Wilson","Wilson, Robert"]

{"sheet":"3.Text to Columns and CONCAT","index":12,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Switch First and Last Name with Comma (Using Text to Column Tool)"]
[]
[null,"First Name Last Name","First Name","Last Name","Last Name, First Name"]
[null,"Emily Smith","Emily","Smith",{"$f":"_xlfn.CONCAT(D5,\", \",C5)","v":"Smith, Emily"}]
[null,"Sarah Davis","Sarah","Davis",{"$f":"_xlfn.CONCAT(D6,\", \",C6)","v":"Davis, Sarah"}]
[null,"James Anderson","James","Anderson","Anderson, James"]
[null,"David Martinez","David","Martinez","Martinez, David"]
[null,"Robert Wilson","Robert","Wilson","Wilson, Robert"]

{"sheet":"4. Power Query","index":13,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Power Query"]
[]
[null,"First Name Last Name","Last Name, First Name"]
[null,"Emily Smith","Smith, Emily"]
[null,"Sarah Davis","Davis, Sarah"]
[null,"James Anderson","Anderson, James"]
[null,"David Martinez","Martinez, David"]
[null,"Robert Wilson"," Wilson, Rober"]

{"sheet":"Sheet8","index":14,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Row Labels"]
[null,"Anderson, James"]
[null,"Davis, Sarah"]
[null,"Gomes, Emily"]
[null,"Martinez, David"]
[null,"Wilson, Robert"]
[null,"Grand Total"]

{"sheet":"5. Power_Pivot","index":15,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Power Pivot"]
[]
[null,"First Name Last Name"]
[null,"Emily Gomes"]
[null,"Sarah Davis"]
[null,"James Anderson"]
[null,"David Martinez"]
[null,"Robert Wilson"]

{"sheet":"6.VBA","index":16,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Switch First and Last Name with Comma (Using VBA)"]
[]
[null,"Smith, Emily"]
[null,"Davis, Sarah"]
[null,"Anderson, James"]
[null,"Martinez, David"]
[null,"Wilson, Robert"]