{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Data Set","Text to Column","Flash Fill","4 Functions","Decimal Numbers from Left","Decimal Numbers from Anywhere","VBA"],"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":"Data Set","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Sample Data"]
[]
[null,"Data"]
[null,"Jessica, 58.500"]
[null,"Henderson, 78.680"]
[null,"Aaron, 61.000"]
[null,"Mitchel, 67.050"]
[null,"John, 81.750"]

{"sheet":"Text to Column","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Apply Text to Columns"]
[]
[null,"Data","Decimal Number"]
[null,"Jessica",58.5]
[null,"Henderson",78.680000000000007]
[null,"Aaron",61]
[null,"Mitchel",67.05]
[null,"John",81.75]

{"sheet":"Flash Fill","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Use of Flash Fill"]
[]
[null,"Data","Decimal Number"]
[null,"Jessica, 58.500",58.5]
[null,"Henderson, 78.680",78.680000000000007]
[null,"Aaron, 61.000",61]
[null,"Mitchel, 67.050",67.05]
[null,"John, 81.750",81.75]

{"sheet":"4 Functions","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Combination of 4 Functions"]
[]
[null,"Data","Decimal Number"]
[null,"Jessica, 58.500",{"$f":"RIGHT(B4,LEN(B4)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B4&\"0123456789\"))+1)","v":"58.500"}]
[null,"Henderson, 78.680",{"$f":"RIGHT(B5,LEN(B5)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\"))+1)","v":"78.680"}]
[null,"Aaron, 61.000",{"$f":"RIGHT(B6,LEN(B6)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B6&\"0123456789\"))+1)","v":"61.000"}]
[null,"Mitchel, 67.050",{"$f":"RIGHT(B7,LEN(B7)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B7&\"0123456789\"))+1)","v":"67.050"}]
[null,"John, 81.750",{"$f":"RIGHT(B8,LEN(B8)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B8&\"0123456789\"))+1)","v":"81.750"}]

{"sheet":"Decimal Numbers from Left","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Separate Decimal Numbers from Left"]
[]
[null,"Data","Decimal Number"]
[null,"58.500, Jessica",{"$f":"LEFT(B4,SUM(LEN(B4)-LEN(SUBSTITUTE(B4,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\")))+1)","v":"58.500"}]
[null,"78.680, Henderson",{"$f":"LEFT(B5,SUM(LEN(B5)-LEN(SUBSTITUTE(B5,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\")))+1)","v":"78.680"}]
[null,"61.000, Aaron",{"$f":"LEFT(B6,SUM(LEN(B6)-LEN(SUBSTITUTE(B6,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\")))+1)","v":"61.000"}]
[null,"67.050, Mitchel",{"$f":"LEFT(B7,SUM(LEN(B7)-LEN(SUBSTITUTE(B7,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\")))+1)","v":"67.050"}]
[null,"81.750, John",{"$f":"LEFT(B8,SUM(LEN(B8)-LEN(SUBSTITUTE(B8,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\")))+1)","v":"81.750"}]

{"sheet":"Decimal Numbers from Anywhere","index":5,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Separate Decimal Numbers from Any Location"]
[]
[null,"Data","Decimal Number"]
[null,"IT, 58.500, Jessica",{"$f":"LOOKUP(9.9E+307,--LEFT(MID(B4,MIN(FIND({1,2,3,4,5,6,7,8,9,0}, $B4&\"1023456789\")),999),ROW(INDIRECT(\"1:999\"))))","v":58.5}]
[null,"Account, 78.680, Henderson",{"$f":"LOOKUP(9.9E+307,--LEFT(MID(B5,MIN(FIND({1,2,3,4,5,6,7,8,9,0}, $B5&\"1023456789\")),999),ROW(INDIRECT(\"1:999\"))))","v":78.680000000000007}]
[null,"Sales, 61.000, Aaron",{"$f":"LOOKUP(9.9E+307,--LEFT(MID(B6,MIN(FIND({1,2,3,4,5,6,7,8,9,0}, $B6&\"1023456789\")),999),ROW(INDIRECT(\"1:999\"))))","v":61}]
[null,"HRM, 67.050, Mitchel",{"$f":"LOOKUP(9.9E+307,--LEFT(MID(B7,MIN(FIND({1,2,3,4,5,6,7,8,9,0}, $B7&\"1023456789\")),999),ROW(INDIRECT(\"1:999\"))))","v":67.05}]
[null,"81.750, John",{"$f":"LOOKUP(9.9E+307,--LEFT(MID(B8,MIN(FIND({1,2,3,4,5,6,7,8,9,0}, $B8&\"1023456789\")),999),ROW(INDIRECT(\"1:999\"))))","v":81.75}]

{"sheet":"VBA","index":6,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Excel VBA to get Decimal Numbers"]
[]
[null,"Data","Decimal Number"]
[null,"Jessica, 58.500",{"$f":"DecimalNumber(B4,1)","v":"58500"}]
[null,"Henderson, 78.680",{"$f":"DecimalNumber(B5,1)","v":"78680"}]
[null,"Aaron, 61.000",{"$f":"DecimalNumber(B6,1)","v":"61000"}]
[null,"Mitchel, 67.050",{"$f":"DecimalNumber(B7,1)","v":"67050"}]
[null,"John, 81.750",{"$f":"DecimalNumber(B8,1)","v":"81750"}]