{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet2","Sheet1","Sheet3","Sheet4"],"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":"Sheet2","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Apply the MID Function with the FIND Function"]
[]
[null,"Order ID & Names","Formula","Result"]
[null,"1312045 Juliana Gomes","*=MID(B5,FIND(\" \",B5,1),20)",{"$f":"MID(B5,FIND(\" \",B5,1),20)","v":" Juliana Gomes"},null,{"$f":"RIGHT(B5,E5)","v":""}]
[null,"1312047 Patrick Gomes","*=MID(B6,FIND(\" \",B6,1),20)",{"$f":"MID(B6,FIND(\" \",B6,1),20)","v":" Patrick Gomes"}]
[null,"1312058 Roberk Derick","*=MID(B7,FIND(\" \",B7,1),20)"," Roberk Derick"]
[null,"1312054 Henry Wood","*=MID(B8,FIND(\" \",B8,1),20)"," Henry Wood"]
[null,"1312057 Eva Brown","*=MID(B9,FIND(\" \",B9,1),20)"," Eva Brown"]
[null,"1312067 Anne Parker","*=MID(B10,FIND(\" \",B10,1),20)"," Anne Parker"]
[null,"1312064 Stella Rose","*=MID(B11,FIND(\" \",B11,1),20)"," Stella Rose"]
[null,"1312061 Donald Rigan","*=MID(B12,FIND(\" \",B12,1),20)"," Donald Rigan"]

{"sheet":"Sheet1","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combine the RIGHT, the LEN, and the FIND Function"]
[]
[null,"Order ID & Names","Formula","Result"]
[null,"1312045 Juliana Gomes","*=RIGHT(B5,LEN(B5)-FIND(\" \",B5,1))",{"$f":"RIGHT(B5,LEN(B5)-FIND(\" \",B5,1))","v":"Juliana Gomes"},null,{"$f":"RIGHT(B5,E5)","v":""}]
[null,"1312047 Patrick Gomes","*=RIGHT(B6,LEN(B6)-FIND(\" \",B6,1))",{"$f":"RIGHT(B6,LEN(B6)-FIND(\" \",B6,1))","v":"Patrick Gomes"}]
[null,"1312058 Roberk Derick","*=RIGHT(B7,LEN(B7)-FIND(\" \",B7,1))","Roberk Derick"]
[null,"1312054 Henry Wood","*=RIGHT(B8,LEN(B8)-FIND(\" \",B8,1))","Henry Wood"]
[null,"1312057 Eva Brown","*=RIGHT(B9,LEN(B9)-FIND(\" \",B9,1))","Eva Brown"]
[null,"1312067 Anne Parker","*=RIGHT(B10,LEN(B10)-FIND(\" \",B10,1))","Anne Parker"]
[null,"1312064 Stella Rose","*=RIGHT(B11,LEN(B11)-FIND(\" \",B11,1))","Stella Rose"]
[null,"1312061 Donald Rigan","*=RIGHT(B12,LEN(B12)-FIND(\" \",B12,1))","Donald Rigan"]

{"sheet":"Sheet3","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Run a VBA Code to Extract Text"]
[]
[null,"Order ID & Names","Result"]
[null,"1312045 Juliana Gomes",null,null,{"$f":"RIGHT(B5,D5)","v":""}]
[null,"1312047 Patrick Gomes"]
[null,"1312058 Roberk Derick"]
[null,"1312054 Henry Wood"]
[null,"1312057 Eva Brown"]
[null,"1312067 Anne Parker"]
[null,"1312064 Stella Rose"]
[null,"1312061 Donald Rigan"]

{"sheet":"Sheet4","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Data Set to Extract Text After Space"]
[]
[null,"Order ID & Names","Names"]
[null,"1312045 Juliana Gomes",null,null,{"$f":"RIGHT(B5,D5)","v":""}]
[null,"1312047 Patrick Gomes"]
[null,"1312058 Roberk Derick"]
[null,"1312054 Henry Wood"]
[null,"1312057 Eva Brown"]
[null,"1312067 Anne Parker"]
[null,"1312064 Stella Rose"]
[null,"1312061 Donald Rigan"]