{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Home Page","Dataset","Overview","Text to Column","Flash Fill","First and Last name","First and las name (FIND)","First, Middle & Last Name","TEXTSPLIT Function (Horizontal)","TEXTSPLIT Function( Vertical)","Seperating numbers","Merged cells","Blank cells","Power Query","VBA"],"not_rendered":{"charts":0,"images":1,"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":"Home Page","index":0,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Split in Excel"]
[]
[null,"Learn to Split in Excel"]
[]
[null,"Prepared By","Afrina Nafisa"]
[null,"Reviewed By","Bhubon Costa"]
[null,"Last Update","28/11/2023"]
[null,"Article Link","Split in Excel"]
[]
[null,"Examples"]
[]
[null,"1. Text to Column",null,null,"7. TEXTSPLIT Function (Vertical)"]
[null,"2. Flash Fill",null,null,"8. Separating Numbers"]
[null,"3. First and Last Name",null,null,"9. Merged Cells"]
[null,"4. First and Last Name (FIND)",null,null,"10. Blank Cells"]
[null,"6. First, Middle and Last Name",null,null,"11. Power Query"]
[null,"5. TEXTSPLIT Function (Horizontal)",null,null,"12. VBA Macro"]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Dataset","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel"]
[]
[null,"Dataset"]
[]
[null,"Designation","Employee Name"]
[null,"Chief Executive","Robert Henry"]
[null,"Executive","Elizabeth Grace"]
[null,"Web Developer","Oliver Adam"]
[null,"Project Manager","Michael Thomas"]
[null,"Team Leader","Benjamin Evelyn"]
[null,"CEO","Joshua Christopher"]
[null,"COO","William Joseph"]
[null,"Senior Executive","Emma Samuel"]
[]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"Overview","index":2,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[12,3,12,4],[13,3,13,4],[17,1,17,4],[18,1,18,4],[21,2,23,2]]}
[null,"Split in Excel"]
[]
[null,"Overview"]
[]
[null,"Splitting First Name and Last Name"]
[]
[null,"Employee Name","Formula ","First Name","Last Name"]
[null,"Robert Henry",{"$f":"_xlfn.FORMULATEXT(D8)","v":"=LEFT(B8,SEARCH(\" \",B8)-1)"},{"$f":"LEFT(B8,SEARCH(\" \",B8)-1)","v":"Robert"}]
[null,"Robert Henry",{"$f":"_xlfn.FORMULATEXT(E9)","v":"=RIGHT(B8,LEN(B8)-SEARCH(\" \",B8))"},null,{"$f":"RIGHT(B8,LEN(B8)-SEARCH(\" \",B8))","v":"Henry"}]
[]
[null,"Separating Numbers from Text in Excel"]
[]
[null,"Employee Bio","Formula ","Joining Year"]
[null,"Robert Henry, Joined in 2022, First Job",{"$f":"_xlfn.FORMULATEXT(D14)","v":"=TEXTJOIN(\"\",TRUE,IFERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1,\"\"))"},{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1,\"\"))","v":"2022"}]
[]
[null,"Splitting Cells Vertically Across Rows"]
[]
[null,"Products"]
[null,"Mango, Banana, Guava"]
[]
[null,"Outlet Location","Formula ","Product","Price (USD $)"]
[null,"Los Angeles",{"$f":"_xlfn.FORMULATEXT(D22)","v":"=TEXTSPLIT(B19,,\",\")"},{"$f":"_xlfn.TEXTSPLIT(B19,,\",\")","v":"Mango"},23.5]
[null,"Houston",null," Banana",45.25]
[null,"\tChicago",null," Guava",34.56]
[]
[]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"Text to Column","index":3,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel",null,null,null,null,null,"Split in Excel"]
[]
[null,"Using Text to Column Option",null,null,null,null,null,"Try Yourself!!"]
[]
[null,"Designation","Employee Name","First Name","Last Name",null,null,"Designation","Employee Name","First Name","Last Name"]
[null,"Chief Executive","Robert Henry","Robert","Henry",null,null,"Chief Executive","Robert Henry"]
[null,"Executive","Elizabeth Grace","Elizabeth","Grace",null,null,"Executive","Elizabeth Grace"]
[null,"Web Developer","Oliver Adam","Oliver","Adam",null,null,"Web Developer","Oliver Adam"]
[null,"Project Manager","Michael Thomas","Michael","Thomas",null,null,"Project Manager","Michael Thomas"]
[null,"Team Leader","Benjamin Evelyn","Benjamin","Evelyn",null,null,"Team Leader","Benjamin Evelyn"]
[null,"CEO","Joshua Christopher","Joshua","Christopher",null,null,"CEO","Joshua Christopher"]
[null,"COO","William Joseph","William","Joseph",null,null,"COO","William Joseph"]
[null,"Senior Executive","Emma Samuel","Emma","Samuel",null,null,"Senior Executive","Emma Samuel"]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"Flash Fill","index":4,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel",null,null,null,null,null,null,"Split in Excel"]
[]
[null,"Applying Flash Fill Option",null,null,null,null,null,null,"Try Yourself!!"]
[]
[null,"Designation","Employee Name","First Name","Last Name",null,null,null,"Designation","Employee Name","First Name","Last Name"]
[null,"Chief Executive","Robert Henry","Robert","Henry",null,null,null,"Chief Executive","Robert Henry"]
[null,"Executive","Elizabeth Grace","Elizabeth","Grace",null,null,null,"Executive","Elizabeth Grace"]
[null,"Web Developer","Oliver Adam","Oliver","Adam",null,null,null,"Web Developer","Oliver Adam"]
[null,"Project Manager","Michael Thomas","Michael","Thomas",null,null,null,"Project Manager","Michael Thomas"]
[null,"Team Leader","Benjamin Evelyn","Benjamin","Evelyn",null,null,null,"Team Leader","Benjamin Evelyn"]
[null,"CEO","Joshua Christopher","Joshua","Christopher",null,null,null,"CEO","Joshua Christopher"]
[null,"COO","William Joseph","William","Joseph",null,null,null,"COO","William Joseph"]
[null,"Senior Executive","Emma Samuel","Emma","Samuel",null,null,null,"Senior Executive","Emma Samuel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"First and Last name","index":5,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel",null,null,null,null,null,null,"Split in Excel"]
[]
[null,"Splitting First Name and Last Name",null,null,null,null,null,null,"Try Yourself!!"]
[]
[null,"Designation","Employee Name","First Name","Last Name",null,null,null,"Designation","Employee Name","First Name","Last Name"]
[null,"Chief Executive","Robert Henry",{"$f":"LEFT(C6,SEARCH(\" \",C6)-1)","v":"Robert"},{"$f":"RIGHT(C6,LEN(C6)-SEARCH(\" \",C6))","v":"Henry"},null,null,null,"Chief Executive","Robert Henry"]
[null,"Executive","Elizabeth Grace",{"$f":"LEFT(C7,SEARCH(\" \",C7)-1)","v":"Elizabeth"},{"$f":"RIGHT(C7,LEN(C7)-SEARCH(\" \",C7))","v":"Grace"},null,null,null,"Executive","Elizabeth Grace"]
[null,"Web Developer","Oliver Adam","Oliver","Adam",null,null,null,"Web Developer","Oliver Adam"]
[null,"Project Manager","Michael Thomas","Michael","Thomas",null,null,null,"Project Manager","Michael Thomas"]
[null,"Team Leader","Benjamin Evelyn","Benjamin","Evelyn",null,null,null,"Team Leader","Benjamin Evelyn"]
[null,"CEO","Joshua Christopher","Joshua","Christopher",null,null,null,"CEO","Joshua Christopher"]
[null,"COO","William Joseph","William","Joseph",null,null,null,"COO","William Joseph"]
[null,"Senior Executive","Emma Samuel","Emma","Samuel",null,null,null,"Senior Executive","Emma Samuel"]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"First and las name (FIND)","index":6,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel",null,null,null,null,null,null,"Split in Excel"]
[]
[null,"Splitting First Name and Last Name (Alternative Way)",null,null,null,null,null,null,"Try Yourself!!"]
[]
[null,"Designation","Employee Name","First Name","Last Name",null,null,null,"Designation","Employee Name","First Name","Last Name"]
[null,"Chief Executive","Robert Henry",{"$f":"LEFT(C6,FIND(\" \",C6)-1)","v":"Robert"},{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6))","v":"Henry"},null,null,null,"Chief Executive","Robert Henry"]
[null,"Executive","Elizabeth Grace",{"$f":"LEFT(C7,FIND(\" \",C7)-1)","v":"Elizabeth"},{"$f":"RIGHT(C7,LEN(C7)-FIND(\" \",C7))","v":"Grace"},null,null,null,"Executive","Elizabeth Grace"]
[null,"Web Developer","Oliver Adam","Oliver","Adam",null,null,null,"Web Developer","Oliver Adam"]
[null,"Project Manager","Michael Thomas","Michael","Thomas",null,null,null,"Project Manager","Michael Thomas"]
[null,"Team Leader","Benjamin Evelyn","Benjamin","Evelyn",null,null,null,"Team Leader","Benjamin Evelyn"]
[null,"CEO","Joshua Christopher","Joshua","Christopher",null,null,null,"CEO","Joshua Christopher"]
[null,"COO","William Joseph","William","Joseph",null,null,null,"COO","William Joseph"]
[null,"Senior Executive","Emma Samuel","Emma","Samuel",null,null,null,"Senior Executive","Emma Samuel"]
[]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"First, Middle & Last Name","index":7,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel",null,null,null,null,null,null,"Split in Excel"]
[]
[null,"Splitting First Name, Middle Name, and Last Name",null,null,null,null,null,null,"Try Yourself!!"]
[]
[null,"Designation","Employee Name","First Name","Middle Name","Last Name",null,null,"Designation","Employee Name","Middle Name","First Name","Last Name"]
[null,"Chief Executive","Robert Adam Henry",{"$f":"LEFT(C6,FIND(\" \",C6)-1)","v":"Robert"},{"$f":"IFERROR(MID(C6,SEARCH(\" \",C6)+1,SEARCH(\" \",C6,SEARCH(\" \",C6)+1)-SEARCH(\" \",C6)),\"\")","v":"Adam "},{"$f":"IF(LEN(C6)-LEN(SUBSTITUTE(C6,\" \",\"\"))=1,RIGHT(C6,LEN(C6)-SEARCH(\" \",C6)),RIGHT(C6,LEN(C6)-SEARCH(\" \",C6,SEARCH(\" \",C6)+1)))","v":"Henry"},null,null,"Chief Executive","Robert Henry"]
[null,"Executive","Elizabeth Andrew Grace",{"$f":"LEFT(C7,FIND(\" \",C7)-1)","v":"Elizabeth"},{"$f":"IFERROR(MID(C7,SEARCH(\" \",C7)+1,SEARCH(\" \",C7,SEARCH(\" \",C7)+1)-SEARCH(\" \",C7)),\"\")","v":"Andrew "},{"$f":"IF(LEN(C7)-LEN(SUBSTITUTE(C7,\" \",\"\"))=1,RIGHT(C7,LEN(C7)-SEARCH(\" \",C7)),RIGHT(C7,LEN(C7)-SEARCH(\" \",C7,SEARCH(\" \",C7)+1)))","v":"Grace"},null,null,"Executive","Elizabeth Grace"]
[null,"Web Developer","Oliver Evelyn Adam","Oliver","Evelyn ","Adam",null,null,"Web Developer","Oliver Adam"]
[null,"Project Manager","Michael Henry Thomas","Michael","Henry ","Thomas",null,null,"Project Manager","Michael Thomas"]
[null,"Team Leader","Benjamin Josh Evelyn","Benjamin","Josh ","Evelyn",null,null,"Team Leader","Benjamin Evelyn"]
[null,"CEO","Joshua Mark Christopher","Joshua","Mark ","Christopher",null,null,"CEO","Joshua Christopher"]
[null,"COO","William Aiden Joseph","William","Aiden ","Joseph",null,null,"COO","William Joseph"]
[null,"Senior Executive","Emma Park Samuel","Emma","Park ","Samuel",null,null,"Senior Executive","Emma Samuel"]
[]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"TEXTSPLIT Function (Horizontal)","index":8,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel",null,null,null,null,null,null,"Split in Excel"]
[]
[null,"Splitting Cells Horizontally Across Columns",null,null,null,null,null,null,"Try Yourself!!"]
[]
[null,"Designation","Employee Name","First Name","Last Name",null,null,null,"Designation","Employee Name","First Name","Last Name"]
[null,"Chief Executive","Robert Henry",{"$f":"_xlfn.TEXTSPLIT(C6,\" \")","v":"Robert"},"Henry",null,null,null,"Chief Executive","Robert Henry"]
[null,"Executive","Elizabeth Grace",{"$f":"_xlfn.TEXTSPLIT(C7,\" \")","v":"Elizabeth"},"Grace",null,null,null,"Executive","Elizabeth Grace"]
[null,"Web Developer","Oliver Adam",{"$f":"_xlfn.TEXTSPLIT(C8,\" \")","v":"Oliver"},"Adam",null,null,null,"Web Developer","Oliver Adam"]
[null,"Project Manager","Michael Thomas",{"$f":"_xlfn.TEXTSPLIT(C9,\" \")","v":"Michael"},"Thomas",null,null,null,"Project Manager","Michael Thomas"]
[null,"Team Leader","Benjamin Evelyn",{"$f":"_xlfn.TEXTSPLIT(C10,\" \")","v":"Benjamin"},"Evelyn",null,null,null,"Team Leader","Benjamin Evelyn"]
[null,"CEO","Joshua Christopher",{"$f":"_xlfn.TEXTSPLIT(C11,\" \")","v":"Joshua"},"Christopher",null,null,null,"CEO","Joshua Christopher"]
[null,"COO","William Joseph",{"$f":"_xlfn.TEXTSPLIT(C12,\" \")","v":"William"},"Joseph",null,null,null,"COO","William Joseph"]
[null,"Senior Executive","Emma Samuel",{"$f":"_xlfn.TEXTSPLIT(C13,\" \")","v":"Emma"},"Samuel",null,null,null,"Senior Executive","Emma Samuel"]
[]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"TEXTSPLIT Function( Vertical)","index":9,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,2,4,4],[4,9,4,11]]}
[null,"Split in Excel",null,null,null,null,null,null,"Split in Excel"]
[]
[null,"Splitting Cells Vertically Across Rows",null,null,null,null,null,null,"Try Yourself!!"]
[]
[null,"Store Name","Products",null,null,null,null,null,"Store Name","Products"]
[null,"Big Bazar","Mango, Banana, Guava, Coconut, Apple, Lemon, Berry, Cherry",null,null,null,null,null,"Big Bazar","Mango, Banana, Guava, Coconut, Apple, Lemon, Berry, Cherry"]
[]
[null,"Weekly Holiday","Outlet Location","Product","Price (USD $)",null,null,null,"Weekly Holiday","Outlet Location","Product","Price (USD $)"]
[null,"Monday","Los Angeles",{"$f":"_xlfn.TEXTSPLIT(C6,,\",\")","v":"Mango"},23.5,null,null,null,"Monday","Los Angeles",null,23.5]
[null,"Friday","Houston"," Banana",45.25,null,null,null,"Friday","Houston",null,45.25]
[null,"Monday","\tChicago"," Guava",34.56,null,null,null,"Monday","\tChicago",null,34.56]
[null,"Friday","New York"," Coconut",23.65,null,null,null,"Friday","New York",null,23.65]
[null,"Monday","Phoenix"," Apple",34.85,null,null,null,"Monday","Phoenix",null,34.85]
[null,"Tuesday","Dallas"," Lemon",44.65,null,null,null,"Tuesday","Dallas",null,44.65]
[null,"Monday","\tSan Jose"," Berry",34.75,null,null,null,"Monday","\tSan Jose",null,34.75]
[null,"Tuesday","Columbus"," Cherry",40,null,null,null,"Tuesday","Columbus",null,40]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"Seperating numbers","index":10,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel",null,null,null,null,"Split in Excel"]
[]
[null,"Separating Numbers from Text in Excel",null,null,null,null,"Try Yourself!!"]
[]
[null,"Designation","Employee Bio","Joining Year",null,null,"Designation","Employee Bio","Joining Year"]
[null,"Executive","Robert Henry, Joined in 2022, First Job",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(C6,ROW(INDIRECT(\"1:\"&LEN(C6))),1)*1,\"\"))","v":"2022"},null,null,"Executive","Robert Henry, Joined in 2022, First Job"]
[null,"Chief Executive","Elizabeth Grace, Joined in 2021, Experienced",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(C7,ROW(INDIRECT(\"1:\"&LEN(C7))),1)*1,\"\"))","v":"2021"},null,null,"Chief Executive","Elizabeth Grace, Joined in 2021, Experienced"]
[null,"Web Developer","Oliver Adam, Joined in 2023, First Job",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(C8,ROW(INDIRECT(\"1:\"&LEN(C8))),1)*1,\"\"))","v":"2023"},null,null,"Web Developer","Oliver Adam, Joined in 2023, First Job"]
[null,"Project Manager","Michael Thomas, Joined in 2022, Experienced",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(C9,ROW(INDIRECT(\"1:\"&LEN(C9))),1)*1,\"\"))","v":"2022"},null,null,"Project Manager","Michael Thomas, Joined in 2022, Experienced"]
[null,"Team Leader","Benjamin Evelyn, Joined in 2022, Experienced",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(C10,ROW(INDIRECT(\"1:\"&LEN(C10))),1)*1,\"\"))","v":"2022"},null,null,"Team Leader","Benjamin Evelyn, Joined in 2022, Experienced"]
[null,"CEO","Joshua Christopher, Joined in 2012, Experienced",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(C11,ROW(INDIRECT(\"1:\"&LEN(C11))),1)*1,\"\"))","v":"2012"},null,null,"CEO","Joshua Christopher, Joined in 2012, Experienced"]
[null,"COO","William Joseph, Joined in 2013, Experienced",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(C12,ROW(INDIRECT(\"1:\"&LEN(C12))),1)*1,\"\"))","v":"2013"},null,null,"COO","William Joseph, Joined in 2013, Experienced"]
[null,"Senior Executive","Emma Samuel, Joined in 2022, Experienced",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(C13,ROW(INDIRECT(\"1:\"&LEN(C13))),1)*1,\"\"))","v":"2022"},null,null,"Senior Executive","Emma Samuel, Joined in 2022, Experienced"]
[]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"Merged cells","index":11,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[10,2,10,3],[11,2,11,3],[12,2,12,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[9,10,9,11],[10,10,10,11],[11,10,11,11],[12,10,12,11],[4,10,4,11],[5,10,5,11],[6,10,6,11],[7,10,7,11],[8,10,8,11]]}
[null,"Split in Excel",null,null,null,null,null,null,null,"Split in Excel"]
[]
[null,"Splitting Merged Cells into Multiple Cells",null,null,null,null,null,null,null,"Try Yourself!!"]
[]
[null,"Designation","Employee Bio",null,"Name","Joining Year",null,null,null,"Designation","Employee Bio",null,"Name","Joining Year"]
[null,"Executive","Robert Henry, Joined in 2022",null,{"$f":"_xlfn.TEXTSPLIT(C6,\",\")","v":"Robert Henry"}," Joined in 2022",null,null,null,"Executive","Robert Henry, Joined in 2022"]
[null,"Chief Executive","Elizabeth Grace, Joined in 2021",null,{"$f":"_xlfn.TEXTSPLIT(C7,\",\")","v":"Elizabeth Grace"}," Joined in 2021",null,null,null,"Chief Executive","Elizabeth Grace, Joined in 2021"]
[null,"Web Developer","Oliver Adam, Joined in 2023",null,{"$f":"_xlfn.TEXTSPLIT(C8,\",\")","v":"Oliver Adam"}," Joined in 2023",null,null,null,"Web Developer","Oliver Adam, Joined in 2023"]
[null,"Project Manager","Michael Thomas, Joined in 2022",null,{"$f":"_xlfn.TEXTSPLIT(C9,\",\")","v":"Michael Thomas"}," Joined in 2022",null,null,null,"Project Manager","Michael Thomas, Joined in 2022"]
[null,"Team Leader","Benjamin Evelyn, Joined in 2022",null,{"$f":"_xlfn.TEXTSPLIT(C10,\",\")","v":"Benjamin Evelyn"}," Joined in 2022",null,null,null,"Team Leader","Benjamin Evelyn, Joined in 2022"]
[null,"CEO","Joshua Christopher, Joined in 2012",null,{"$f":"_xlfn.TEXTSPLIT(C11,\",\")","v":"Joshua Christopher"}," Joined in 2012",null,null,null,"CEO","Joshua Christopher, Joined in 2012"]
[null,"COO","William Joseph, Joined in 2013",null,{"$f":"_xlfn.TEXTSPLIT(C12,\",\")","v":"William Joseph"}," Joined in 2013",null,null,null,"COO","William Joseph, Joined in 2013"]
[null,"Senior Executive","Emma Samuel, Joined in 2022",null,{"$f":"_xlfn.TEXTSPLIT(C13,\",\")","v":"Emma Samuel"}," Joined in 2022",null,null,null,"Senior Executive","Emma Samuel, Joined in 2022"]
[]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"Blank cells","index":12,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel",null,null,null,null,"Split in Excel"]
[]
[null,"Splitting Cells Ignoring Blank Cells",null,null,null,null,"Try Yourself!!"]
[]
[null,"Employee Bio","Output","Output","Output",null,"Designation","Employee Bio","Name","Joining Year","Experience"]
[null,", Joined in 2022, First Job",{"$f":"_xlfn.TEXTSPLIT(B6,\",\",,TRUE)","v":" Joined in 2022"}," First Job",null,null,"Executive",", Joined in 2022, First Job"]
[null,"Elizabeth Grace,,Experienced",{"$f":"_xlfn.TEXTSPLIT(B7,\",\",,TRUE)","v":"Elizabeth Grace"},"Experienced",null,null,"Chief Executive","Elizabeth Grace, , Experienced"]
[null,"Robert Joe, Joined in 2023, First Job",{"$f":"_xlfn.TEXTSPLIT(B8,\",\",,TRUE)","v":"Robert Joe"}," Joined in 2023"," First Job",null,"Web Developer",", Joined in 2023, First Job"]
[null,"Michael Thomas,Joined in 2021, Experienced",{"$f":"_xlfn.TEXTSPLIT(B9,\",\",,TRUE)","v":"Michael Thomas"},"Joined in 2021"," Experienced",null,"Project Manager","Michael Thomas, , Experienced"]
[null,"Benjamin Evelyn, Joined in 2022,",{"$f":"_xlfn.TEXTSPLIT(B10,\",\",,TRUE)","v":"Benjamin Evelyn"}," Joined in 2022",null,null,"Team Leader","Benjamin Evelyn, Joined in 2022,"]
[null,"Joshua Christopher,, Experienced",{"$f":"_xlfn.TEXTSPLIT(B11,\",\",,TRUE)","v":"Joshua Christopher"}," Experienced",null,null,"CEO","Joshua Christopher, , Experienced"]
[null,"William Josh, Joined in 2013,Experienced",{"$f":"_xlfn.TEXTSPLIT(B12,\",\",,TRUE)","v":"William Josh"}," Joined in 2013","Experienced",null,"COO","William Joseph, Joined in 2013,"]
[null,", Joined in 2022, Experienced",{"$f":"_xlfn.TEXTSPLIT(B13,\",\",,TRUE)","v":" Joined in 2022"}," Experienced",null,null,"Senior Executive",", Joined in 2022, Experienced"]
[]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"Power Query","index":13,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Column1","Column2.1","Column2.2",null,null,null,null,null,"Split in Excel"]
[null,"Split in Excel"]
[null,null,null,null,null,null,null,null,null,"Try Yourself!!"]
[null,"Splitting Columns Using Power Query"]
[null,null,null,null,null,null,null,null,null,"Designation","Employee Name","First Name","Last Name"]
[null,"Designation","Employee","Name",null,null,null,null,null,"Chief Executive","Robert Henry"]
[null,"Chief Executive","Robert","Henry",null,null,null,null,null,"Executive","Elizabeth Grace"]
[null,"Executive","Elizabeth","Grace",null,null,null,null,null,"Web Developer","Oliver Adam"]
[null,"Web Developer","Oliver","Adam",null,null,null,null,null,"Project Manager","Michael Thomas"]
[null,"Project Manager","Michael","Thomas",null,null,null,null,null,"Team Leader","Benjamin Evelyn"]
[null,"Team Leader","Benjamin","Evelyn",null,null,null,null,null,"CEO","Joshua Christopher"]
[null,"CEO","Joshua","Christopher",null,null,null,null,null,"COO","William Joseph"]
[null,"COO","William","Joseph",null,null,null,null,null,"Senior Executive","Emma Samuel"]
[null,"Senior Executive","Emma","Samuel"]
[]
[]
[]
[null,"→ Back to Home Page"]

{"sheet":"VBA","index":14,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Split in Excel",null,null,null,null,null,null,null,"Split in Excel"]
[]
[null,"Applying VBA Macro to Split Cells",null,null,null,null,null,null,null,"Try Yourself!!"]
[]
[null,"Designation","Employee Name","First Name","Last Name",null,null,null,null,"Designation","Employee Name","First Name","Last Name"]
[null,"Chief Executive","Robert Henry","Robert","Henry",null,null,null,null,"Chief Executive","Robert Henry"]
[null,"Executive","Elizabeth Grace","Elizabeth","Grace",null,null,null,null,"Executive","Elizabeth Grace"]
[null,"Web Developer","Oliver Adam","Oliver","Adam",null,null,null,null,"Web Developer","Oliver Adam"]
[null,"Project Manager","Michael Thomas","Michael","Thomas",null,null,null,null,"Project Manager","Michael Thomas"]
[null,"Team Leader","Benjamin Evelyn","Benjamin","Evelyn",null,null,null,null,"Team Leader","Benjamin Evelyn"]
[null,"CEO","Joshua Christopher","Joshua","Christopher",null,null,null,null,"CEO","Joshua Christopher"]
[null,"COO","William Joseph","William","Joseph",null,null,null,null,"COO","William Joseph"]
[null,"Senior Executive","Emma Samuel","Emma","Samuel",null,null,null,null,"Senior Executive","Emma Samuel"]
[]
[]
[]
[]
[]
[null,"→ Back to Home Page"]