{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["main","flashfill","textTocolumn","powerQuery","combinefunction","VBA(pre selection)","UDF","filterXML","VBA2","search","findlinebreak"],"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":"main","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Separate Text in Excel"]
[]
[null,"Student Info"]
[null,"Joey,ME"]
[null,"Chandler,CSE"]
[null,"Janice,EEE"]
[null,"Ross,ME"]
[null,"Julia,EEE"]
[null,"Emily,CSE"]

{"sheet":"flashfill","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,8,1,10],[1,1,1,3]]}
[]
[null,"Flash Fill",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Joey,ME","Joey","ME",null,null,null,null,"Joey,ME"]
[null,"Chandler,CSE","Chandler","CSE",null,null,null,null,"Chandler,CSE"]
[null,"Janice,EEE","Janice","EEE",null,null,null,null,"Janice,EEE"]
[null,"Ross,ME","Ross","ME",null,null,null,null,"Ross,ME"]
[null,"Julia,EEE","Julia","EEE",null,null,null,null,"Julia,EEE"]
[null,"Emily,CSE","Emily","CSE",null,null,null,null,"Emily,CSE"]

{"sheet":"textTocolumn","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"TEXT to Columns",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Joey,ME","Joey","ME",null,null,null,null,"Joey,ME"]
[null,"Chandler,CSE","Chandler","CSE",null,null,null,null,"Chandler,CSE"]
[null,"Janice,EEE","Janice","EEE",null,null,null,null,"Janice,EEE"]
[null,"Ross,ME","Ross","ME",null,null,null,null,"Ross,ME"]
[null,"Julia,EEE","Julia","EEE",null,null,null,null,"Julia,EEE"]
[null,"Emily,CSE","Emily","CSE",null,null,null,null,"Emily,CSE"]

{"sheet":"powerQuery","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Power Query",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Column1","Column1.1","Column1.2",null,null,null,null,"Joey,ME"]
[null,"Joey,ME","Joey","ME",null,null,null,null,"Chandler,CSE"]
[null,"Chandler,CSE","Chandler","CSE",null,null,null,null,"Janice,EEE"]
[null,"Janice,EEE","Janice","EEE",null,null,null,null,"Ross,ME"]
[null,"Ross,ME","Ross","ME",null,null,null,null,"Julia,EEE"]
[null,"Julia,EEE","Julia","EEE",null,null,null,null,"Emily,CSE"]
[null,"Emily,CSE","Emily","CSE"]

{"sheet":"combinefunction","index":4,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Combining SUBSTITUTE, REPT, LEN, TRIM & MID Functions",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Joey ME",{"$f":"TRIM(MID(SUBSTITUTE($B5,\" \",REPT(\" \",LEN($B5))),(COLUMNS($B4:B4)-1)*LEN($B5)+1,LEN($B5)))","v":"Joey"},{"$f":"TRIM(MID(SUBSTITUTE($B5,\" \",REPT(\" \",LEN($B5))),(COLUMNS($B4:C4)-1)*LEN($B5)+1,LEN($B5)))","v":"ME"},null,null,null,null,"Joey ME"]
[null,"Chandler CSE",{"$f":"TRIM(MID(SUBSTITUTE($B6,\" \",REPT(\" \",LEN($B6))),(COLUMNS($B5:B5)-1)*LEN($B6)+1,LEN($B6)))","v":"Chandler"},{"$f":"TRIM(MID(SUBSTITUTE($B6,\" \",REPT(\" \",LEN($B6))),(COLUMNS($B5:C5)-1)*LEN($B6)+1,LEN($B6)))","v":"CSE"},null,null,null,null,"Chandler CSE"]
[null,"Janice EEE",{"$f":"TRIM(MID(SUBSTITUTE($B7,\" \",REPT(\" \",LEN($B7))),(COLUMNS($B6:B6)-1)*LEN($B7)+1,LEN($B7)))","v":"Janice"},{"$f":"TRIM(MID(SUBSTITUTE($B7,\" \",REPT(\" \",LEN($B7))),(COLUMNS($B6:C6)-1)*LEN($B7)+1,LEN($B7)))","v":"EEE"},null,null,null,null,"Janice EEE"]
[null,"Ross ME",{"$f":"TRIM(MID(SUBSTITUTE($B8,\" \",REPT(\" \",LEN($B8))),(COLUMNS($B7:B7)-1)*LEN($B8)+1,LEN($B8)))","v":"Ross"},{"$f":"TRIM(MID(SUBSTITUTE($B8,\" \",REPT(\" \",LEN($B8))),(COLUMNS($B7:C7)-1)*LEN($B8)+1,LEN($B8)))","v":"ME"},null,null,null,null,"Ross ME"]
[null,"Julia EEE",{"$f":"TRIM(MID(SUBSTITUTE($B9,\" \",REPT(\" \",LEN($B9))),(COLUMNS($B8:B8)-1)*LEN($B9)+1,LEN($B9)))","v":"Julia"},{"$f":"TRIM(MID(SUBSTITUTE($B9,\" \",REPT(\" \",LEN($B9))),(COLUMNS($B8:C8)-1)*LEN($B9)+1,LEN($B9)))","v":"EEE"},null,null,null,null,"Julia EEE"]
[null,"Emily CSE",{"$f":"TRIM(MID(SUBSTITUTE($B10,\" \",REPT(\" \",LEN($B10))),(COLUMNS($B9:B9)-1)*LEN($B10)+1,LEN($B10)))","v":"Emily"},{"$f":"TRIM(MID(SUBSTITUTE($B10,\" \",REPT(\" \",LEN($B10))),(COLUMNS($B9:C9)-1)*LEN($B10)+1,LEN($B10)))","v":"CSE"},null,null,null,null,"Emily CSE"]

{"sheet":"VBA(pre selection)","index":5,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using VBA",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Joey ME","Joey","ME",null,null,null,null,"Joey,ME"]
[null,"Chandler CSE","Chandler","CSE",null,null,null,null,"Chandler,CSE"]
[null,"Janice EEE","Janice","EEE",null,null,null,null,"Janice,EEE"]
[null,"Ross ME","Ross","ME",null,null,null,null,"Ross,ME"]
[null,"Julia EEE","Julia","EEE",null,null,null,null,"Julia,EEE"]
[null,"Emily CSE","Emily","CSE",null,null,null,null,"Emily,CSE"]

{"sheet":"UDF","index":6,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"User Defined Function",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Joey;ME",{"$f":"SeparateTextDelimiter(B5,\";\",1)","v":"Joey"},{"$f":"SeparateTextDelimiter(B5,\";\",2)","v":"ME"},null,null,null,null,"Joey;ME"]
[null,"Chandler;CSE",{"$f":"SeparateTextDelimiter(B6,\";\",1)","v":"Chandler"},{"$f":"SeparateTextDelimiter(B6,\";\",2)","v":"CSE"},null,null,null,null,"Chandler;CSE"]
[null,"Janice;EEE",{"$f":"SeparateTextDelimiter(B7,\";\",1)","v":"Janice"},{"$f":"SeparateTextDelimiter(B7,\";\",2)","v":"EEE"},null,null,null,null,"Janice;EEE"]
[null,"Ross;ME",{"$f":"SeparateTextDelimiter(B8,\";\",1)","v":"Ross"},{"$f":"SeparateTextDelimiter(B8,\";\",2)","v":"ME"},null,null,null,null,"Ross;ME"]
[null,"Julia;EEE",{"$f":"SeparateTextDelimiter(B9,\";\",1)","v":"Julia"},{"$f":"SeparateTextDelimiter(B9,\";\",2)","v":"EEE"},null,null,null,null,"Julia;EEE"]
[null,"Emily;CSE",{"$f":"SeparateTextDelimiter(B10,\";\",1)","v":"Emily"},{"$f":"SeparateTextDelimiter(B10,\";\",2)","v":"CSE"},null,null,null,null,"Emily;CSE"]

{"sheet":"filterXML","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Utilizing FILTERXML",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Joey ME",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<x><y>\"&SUBSTITUTE(B5,\" \",\"</y><y>\")&\"</y></x>\",\"//y\"))","v":"Joey"},"ME"," ",null,null,null,"Joey ME"]
[null,"Chandler CSE",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<x><y>\"&SUBSTITUTE(B6,\" \",\"</y><y>\")&\"</y></x>\",\"//y\"))","v":"Chandler"},"CSE",null,null,null,null,"Chandler CSE"]
[null,"Janice EEE",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<x><y>\"&SUBSTITUTE(B7,\" \",\"</y><y>\")&\"</y></x>\",\"//y\"))","v":"Janice"},"EEE",null,null,null,null,"Janice EEE"]
[null,"Ross ME",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<x><y>\"&SUBSTITUTE(B8,\" \",\"</y><y>\")&\"</y></x>\",\"//y\"))","v":"Ross"},"ME",null,null,null,null,"Ross ME"]
[null,"Julia EEE",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<x><y>\"&SUBSTITUTE(B9,\" \",\"</y><y>\")&\"</y></x>\",\"//y\"))","v":"Julia"},"EEE",null,null,null,null,"Julia EEE"]
[null,"Emily CSE",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<x><y>\"&SUBSTITUTE(B10,\" \",\"</y><y>\")&\"</y></x>\",\"//y\"))","v":"Emily"},"CSE",null,null,null,null,"Emily CSE"]

{"sheet":"VBA2","index":8,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"For Next Loop in VBA Code",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Joey ME","Joey","ME"," ",null,null,null,"Joey ME"]
[null,"Chandler CSE","Chandler","CSE",null,null,null,null,"Chandler CSE"]
[null,"Janice EEE","Janice","EEE",null,null,null,null,"Janice EEE"]
[null,"Ross ME","Ross","ME",null,null,null,null,"Ross ME"]
[null,"Julia EEE","Julia","EEE",null,null,null,null,"Julia EEE"]
[null,"Emily CSE","Emily","CSE",null,null,null,null,"Emily CSE"]

{"sheet":"search","index":9,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Merging LEFT, SEARCH, RIGHT, LEN Functions",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Joey ME",{"$f":"LEFT(B5,SEARCH(\" \",B5)-1)","v":"Joey"},{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\" \",B5))","v":"ME"}," ",null,null,null,"Joey ME"]
[null,"Chandler CSE",{"$f":"LEFT(B6,SEARCH(\" \",B6)-1)","v":"Chandler"},{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\" \",B6))","v":"CSE"},null,null,null,null,"Chandler CSE"]
[null,"Janice EEE","Janice","EEE",null,null,null,null,"Janice EEE"]
[null,"Ross ME","Ross","ME",null,null,null,null,"Ross ME"]
[null,"Julia EEE","Julia","EEE",null,null,null,null,"Julia EEE"]
[null,"Emily CSE","Emily","CSE",null,null,null,null,"Emily CSE"]

{"sheet":"findlinebreak","index":10,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Separating TEXT with Line Break (Using LEFT,RIGHT,LEN,FIND & CHAR Functions)",null,null,null,null,null,null,"Practice"]
[]
[null,"Student Info","Name","Department",null,null,null,null,"Student Info","Name","Department"]
[null,"Joey\nME",{"$f":"LEFT(B5,FIND(CHAR(10),B5)-1)","v":"Joey"},{"$f":"RIGHT(B5,LEN(B5)-FIND(CHAR(10),B5))","v":"ME"}," ",null,null,null,"Joey\nME"]
[null,"Chandler\nCSE",{"$f":"LEFT(B6,FIND(CHAR(10),B6)-1)","v":"Chandler"},"CSE",null,null,null,null,"Chandler\nCSE"]
[null,"Janice\nEEE","Janice","EEE",null,null,null,null,"Janice\nEEE"]
[null,"Ross\nME","Ross","ME",null,null,null,null,"Ross\nME"]
[null,"Julia\nEEE","Julia","EEE",null,null,null,null,"Julia\nEEE"]
[null,"Emily\nCSE","Emily","CSE",null,null,null,null,"Emily\nCSE"]