{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Dataset","Using LEFT","Using LEFT with VALUE","Using LEFT with SEARCH","Using LEFT with FIND","Using MID","Using MID with VALUE","Using VBA","Using Flash Fill","Using Text to Columns","Using Text to Columns (2)","Table3","Power Query","Practice Sheet"],"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":"Dataset","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Sample Dataset"]
[]
[null,"Order ID","Brand","Price"]
[null,"123_Vostro","Dell",4567]
[null,"321_Pavillion","HP",3452]
[null,"320_iphone_13 Pro","Apple",7899]
[null,"467_ipad Pro","Apple",4588]
[null,"102_Games_6","Electronic Arts",6589]
[null,"421_MacBook Pro","Apple",4999]
[null,"875_IdeaPad Slim 5","Lenovo",3489]
[null,"762_Galaxy Z Fold","Samsung",567]
[null,"890_Mi Watch","Xiaomi",243]

{"sheet":"Using LEFT","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Using LEFT to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number"]
[null,"123_Vostro","Dell",4567,{"$f":"LEFT(B4,3)","v":"123"}]
[null,"321_Pavillion","HP",3452,{"$f":"LEFT(B5,3)","v":"321"}]
[null,"320_iphone_13 Pro","Apple",7899,"320"]
[null,"467_ipad Pro","Apple",4588,"467"]
[null,"102_Games_6","Electronic Arts",6589,"102"]
[null,"421_MacBook Pro","Apple",4999,"421"]
[null,"875_IdeaPad Slim 5","Lenovo",3489,"875"]
[null,"762_Galaxy Z Fold","Samsung",567,"762"]
[null,"890_Mi Watch","Xiaomi",243,"890"]

{"sheet":"Using LEFT with VALUE","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Using LEFT with VALUE to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number"]
[null,"123_Vostro","Dell",4567,{"$f":"VALUE(LEFT(B4,3))","v":123}]
[null,"321_Pavillion","HP",3452,{"$f":"VALUE(LEFT(B5,3))","v":321}]
[null,"320_iphone_13 Pro","Apple",7899,320]
[null,"467_ipad Pro","Apple",4588,467]
[null,"102_Games_6","Electronic Arts",6589,102]
[null,"421_MacBook Pro","Apple",4999,421]
[null,"875_IdeaPad Slim 5","Lenovo",3489,875]
[null,"762_Galaxy Z Fold","Samsung",567,762]
[null,"890_Mi Watch","Xiaomi",243,890]

{"sheet":"Using LEFT with SEARCH","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Using LEFT with SEARCH to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number"]
[null,"123_Vostro","Dell",4567,{"$f":"LEFT(B4,SEARCH(\"_\",B4)-1)","v":"123"}]
[null,"321_Pavillion","HP",3452,{"$f":"LEFT(B5,SEARCH(\"_\",B5)-1)","v":"321"}]
[null,"320_iphone_13 Pro","Apple",7899,"320"]
[null,"467_ipad Pro","Apple",4588,"467"]
[null,"102_Games_6","Electronic Arts",6589,"102"]
[null,"421_MacBook Pro","Apple",4999,"421"]
[null,"875_IdeaPad Slim 5","Lenovo",3489,"875"]
[null,"762_Galaxy Z Fold","Samsung",567,"762"]
[null,"890_Mi Watch","Xiaomi",243,"890"]

{"sheet":"Using LEFT with FIND","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Using LEFT with FIND to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number"]
[null,"123_Vostro","Dell",4567,{"$f":"LEFT(B4,FIND(\"_\",B4)-1)","v":"123"}]
[null,"321_Pavillion","HP",3452,{"$f":"LEFT(B5,FIND(\"_\",B5)-1)","v":"321"}]
[null,"320_iphone_13 Pro","Apple",7899,"320"]
[null,"467_ipad Pro","Apple",4588,"467"]
[null,"102_Games_6","Electronic Arts",6589,"102"]
[null,"421_MacBook Pro","Apple",4999,"421"]
[null,"875_IdeaPad Slim 5","Lenovo",3489,"875"]
[null,"762_Galaxy Z Fold","Samsung",567,"762"]
[null,"890_Mi Watch","Xiaomi",243,"890"]

{"sheet":"Using MID","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Using MID to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number"]
[null,"123_Vostro","Dell",4567,{"$f":"MID(B4,1,3)","v":"123"}]
[null,"321_Pavillion","HP",3452,{"$f":"MID(B5,1,3)","v":"321"}]
[null,"320_iphone_13 Pro","Apple",7899,"320"]
[null,"467_ipad Pro","Apple",4588,"467"]
[null,"102_Games_6","Electronic Arts",6589,"102"]
[null,"421_MacBook Pro","Apple",4999,"421"]
[null,"875_IdeaPad Slim 5","Lenovo",3489,"875"]
[null,"762_Galaxy Z Fold","Samsung",567,"762"]
[null,"890_Mi Watch","Xiaomi",243,"890"]

{"sheet":"Using MID with VALUE","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Using MID with VALUE to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number"]
[null,"123_Vostro","Dell",4567,{"$f":"VALUE(MID(B4,1,3))","v":123}]
[null,"321_Pavillion","HP",3452,{"$f":"VALUE(MID(B5,1,3))","v":321}]
[null,"320_iphone_13 Pro","Apple",7899,320]
[null,"467_ipad Pro","Apple",4588,467]
[null,"102_Games_6","Electronic Arts",6589,102]
[null,"421_MacBook Pro","Apple",4999,421]
[null,"875_IdeaPad Slim 5","Lenovo",3489,875]
[null,"762_Galaxy Z Fold","Samsung",567,762]
[null,"890_Mi Watch","Xiaomi",243,890]

{"sheet":"Using VBA","index":7,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number"]
[null,"123_Vostro","Dell",4567,123]
[null,"321_Pavillion","HP",3452,321]
[null,"320_iphone_13 Pro","Apple",7899,320]
[null,"467_ipad Pro","Apple",4588,467]
[null,"102_Games_6","Electronic Arts",6589,102]
[null,"421_MacBook Pro","Apple",4999,421]
[null,"875_IdeaPad Slim 5","Lenovo",3489,875]
[null,"762_Galaxy Z Fold","Samsung",567,762]
[null,"890_Mi Watch","Xiaomi",243,890]

{"sheet":"Using Flash Fill","index":8,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Using Flash Fill to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number"]
[null,"123_Vostro","Dell",4567,123]
[null,"321_Pavillion","HP",3452,321]
[null,"320_iphone-13 Pro","Apple",7899,320]
[null,"467_ipad Pro","Apple",4588,467]
[null,"102_Games-6","Electronic Arts",6589,102]
[null,"421_MacBook Pro","Apple",4999,421]
[null,"875_IdeaPad Slim 5","Lenovo",3489,875]
[null,"762_Galaxy Z Fold","Samsung",567,762]
[null,"890_Mi Watch","Xiaomi",243,890]

{"sheet":"Using Text to Columns","index":9,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Using Text to Columns to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number","Product Name"]
[null,"123_Vostro","Dell",4567,123,"_Vostro"]
[null,"321_Pavillion","HP",3452,321,"_Pavillion"]
[null,"320_iphone-13 Pro","Apple",7899,320,"_iphone-13 Pro"]
[null,"467_ipad Pro","Apple",4588,467,"_ipad Pro"]
[null,"102_Games-6","Electronic Arts",6589,102,"_Games-6"]
[null,"421_MacBook Pro","Apple",4999,421,"_MacBook Pro"]
[null,"875_IdeaPad Slim 5","Lenovo",3489,875,"_IdeaPad Slim 5"]
[null,"762_Galaxy Z Fold","Samsung",567,762,"_Galaxy Z Fold"]
[null,"890_Mi Watch","Xiaomi",243,890,"_Mi Watch"]

{"sheet":"Using Text to Columns (2)","index":10,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Using Text to Columns to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price","Order Number","Product Name"]
[null,"123_Vostro","Dell",4567,123,"Vostro"]
[null,"321_Pavillion","HP",3452,321,"Pavillion"]
[null,"320_iphone-13 Pro","Apple",7899,320,"iphone-13 Pro"]
[null,"467_ipad Pro","Apple",4588,467,"ipad Pro"]
[null,"102_Games-6","Electronic Arts",6589,102,"Games-6"]
[null,"421_MacBook Pro","Apple",4999,421,"MacBook Pro"]
[null,"875_IdeaPad Slim 5","Lenovo",3489,875,"IdeaPad Slim 5"]
[null,"762_Galaxy Z Fold","Samsung",567,762,"Galaxy Z Fold"]
[null,"890_Mi Watch","Xiaomi",243,890,"Mi Watch"]

{"sheet":"Table3","index":11,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Order ID","Brand","Price","Order Number"]
["123_Vostro","Dell",4567,"123"]
["321_Pavillion","HP",3452,"321"]
["320_iphone_13 Pro","Apple",7899,"320"]
["467_ipad Pro","Apple",4588,"467"]
["102_Games_6","Electronic Arts",6589,"102"]
["421_MacBook Pro","Apple",4999,"421"]
["875_IdeaPad Slim 5","Lenovo",3489,"875"]
["762_Galaxy Z Fold","Samsung",567,"762"]
["890_Mi Watch","Xiaomi",243,"890"]

{"sheet":"Power Query","index":12,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Using Power Query to Get First 3 Characters from a Cell"]
[]
[null,"Order ID","Brand","Price"]
[null,"123_Vostro","Dell",4567]
[null,"321_Pavillion","HP",3452]
[null,"320_iphone_13 Pro","Apple",7899]
[null,"467_ipad Pro","Apple",4588]
[null,"102_Games_6","Electronic Arts",6589]
[null,"421_MacBook Pro","Apple",4999]
[null,"875_IdeaPad Slim 5","Lenovo",3489]
[null,"762_Galaxy Z Fold","Samsung",567]
[null,"890_Mi Watch","Xiaomi",243]

{"sheet":"Practice Sheet","index":13,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Do  It Youself"]
[]
[null,"Order ID","Brand","Price","Order Number"]
[null,"123_Vostro","Dell",4567]
[null,"321_Pavillion","HP",3452]
[null,"320_iphone_13 Pro","Apple",7899]
[null,"467_ipad Pro","Apple",4588]
[null,"102_Games_6","Electronic Arts",6589]
[null,"421_MacBook Pro","Apple",4999]
[null,"875_IdeaPad Slim 5","Lenovo",3489]
[null,"762_Galaxy Z Fold","Samsung",567]
[null,"890_Mi Watch","Xiaomi",243]