{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Sheet 1","Sample","Flash Fill","REPLACE","Find and Replace","SUBSTITUTE","Double Dashes","Extra Spaces","Bulk","Find and Replace ","Table1","Power Query","VBA"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet 1","index":0,"n_rows":11,"n_cols":5,"rows_kept":11}
["Employee Name","Designation","Employee ID","Department","Phone Number"]
["Ethan","Software Engineer","SE-1023","IT","202-555-0147"]
["Olivia","Project Manager","PM-2275","Management","202-555-0182"]
["Mason","Data Analyst","DA-3301","Finance","202-555-0195"]
["Sophia","Software Engineer","SE-4532","IT","202-555-0136"]
["Liam","Project Manager","PM-1189","Management","202-555-0179"]
["Ava","Data Analyst","DA-2299","Finance","202-555-0163"]
["Noah","Software Engineer","SE-1450","IT","202-555-0125"]
["Emma","Project Manager","PM-3092","Management","202-555-0142"]
["Lucas","Data Analyst","DA-5211","Finance","202-555-0189"]
["Chloe","HR Executive","HR-6420","Human Resource","202-555-0113"]

{"sheet":"Sample","index":1,"n_rows":11,"n_cols":3,"rows_kept":11}
["Employee Name","Designation","Employee ID"]
["Ethan","Software Engineer","SE-1023"]
["Olivia","Project Manager","PM-2275"]
["Mason","Data Analyst","DA-3301"]
["Sophia","Software Engineer","SE-4532"]
["Liam","Project Manager","PM-1189"]
["Ava","Data Analyst","DA-2299"]
["Noah","Software Engineer","SE-1450"]
["Emma","Project Manager","PM-3092"]
["Lucas","Data Analyst","DA-5211"]
["Chloe","HR Executive","HR-6420"]

{"sheet":"Flash Fill","index":2,"n_rows":11,"n_cols":4,"rows_kept":11}
["Employee Name","Designation","Employee ID","Employee ID\n(Removing Dashes)"]
["Ethan","Software Engineer","SE-1023","SE1023"]
["Olivia","Project Manager","PM-2275","PM2275"]
["Mason","Data Analyst","DA-3301","DA3301"]
["Sophia","Software Engineer","SE-4532","SE4532"]
["Liam","Project Manager","PM-1189","PM1189"]
["Ava","Data Analyst","DA-2299","DA2299"]
["Noah","Software Engineer","SE-1450","SE1450"]
["Emma","Project Manager","PM-3092","PM3092"]
["Lucas","Data Analyst","DA-5211","DA5211"]
["Chloe","HR Executive","HR-6420","HR6420"]

{"sheet":"REPLACE","index":3,"n_rows":11,"n_cols":4,"rows_kept":11}
["Employee Name","Designation","Employee ID","Employee ID\n(Removing Dashes)"]
["Ethan","Software Engineer","SE-1023",{"$f":"REPLACE(C2,3,1,\"\")","v":"SE1023"}]
["Olivia","Project Manager","PM-2275",{"$f":"REPLACE(C3,3,1,\"\")","v":"PM2275"}]
["Mason","Data Analyst","DA-3301","DA3301"]
["Sophia","Software Engineer","SE-4532","SE4532"]
["Liam","Project Manager","PM-1189","PM1189"]
["Ava","Data Analyst","DA-2299","DA2299"]
["Noah","Software Engineer","SE-1450","SE1450"]
["Emma","Project Manager","PM-3092","PM3092"]
["Lucas","Data Analyst","DA-5211","DA5211"]
["Chloe","HR Executive","HR-6420","HR6420"]

{"sheet":"Find and Replace","index":4,"n_rows":11,"n_cols":3,"rows_kept":11}
["Employee Name","Designation","Phone Number"]
["Ethan","Software Engineer","202-555-0147"]
["Olivia","Project Manager","202-555-0182"]
["Mason","Data Analyst","202-555-0195"]
["Sophia","Software Engineer","202-555-0136"]
["Liam","Project Manager","202-555-0179"]
["Ava","Data Analyst","202-555-0163"]
["Noah","Software Engineer","202-555-0125"]
["Emma","Project Manager","202-555-0142"]
["Lucas","Data Analyst","202-555-0189"]
["Chloe","HR Executive","202-555-0113"]

{"sheet":"SUBSTITUTE","index":5,"n_rows":11,"n_cols":4,"rows_kept":11}
["Employee Name","Designation","Phone Number","Phone Number\n(Removing Dashes)"]
["Ethan","Software Engineer","202-555-0147",{"$f":"SUBSTITUTE(C2,\"-\",\"\")","v":"2025550147"}]
["Olivia","Project Manager","202-555-0182",{"$f":"SUBSTITUTE(C3,\"-\",\"\")","v":"2025550182"}]
["Mason","Data Analyst","202-555-0195","2025550195"]
["Sophia","Software Engineer","202-555-0136","2025550136"]
["Liam","Project Manager","202-555-0179","2025550179"]
["Ava","Data Analyst","202-555-0163","2025550163"]
["Noah","Software Engineer","202-555-0125","2025550125"]
["Emma","Project Manager","202-555-0142","2025550142"]
["Lucas","Data Analyst","202-555-0189","2025550189"]
["Chloe","HR Executive","202-555-0113","2025550113"]

{"sheet":"Double Dashes","index":6,"n_rows":11,"n_cols":5,"rows_kept":11}
["Employee Name","Designation","Department","Employee Code","Employee Code\n(Removing Dashes)"]
["Ethan","Software Engineer","IT","SE-IT-1023",{"$f":"SUBSTITUTE(SUBSTITUTE(D2,\"--\",\"\"),\"-\",\"\")","v":"SEIT1023"}]
["Olivia","Project Manager","Management","PM-MA-2275",{"$f":"SUBSTITUTE(SUBSTITUTE(D3,\"--\",\"\"),\"-\",\"\")","v":"PMMA2275"}]
["Mason","Data Analyst","Finance","DA--FI-3301","DAFI3301"]
["Sophia","Software Engineer","IT","SE-IT--4532","SEIT4532"]
["Liam","Project Manager","Management","PM-MA-1189-","PMMA1189"]
["Ava","Data Analyst","Finance","DA--FI--2299","DAFI2299"]
["Noah","Software Engineer","IT","SE--IT-1450","SEIT1450"]
["Emma","Project Manager","Management","PM-MA-3092","PMMA3092"]
["Lucas","Data Analyst","Finance","DA-FI--5211","DAFI5211"]
["Chloe","HR Executive","Human Resource","HR--6420","HR6420"]

{"sheet":"Extra Spaces","index":7,"n_rows":11,"n_cols":4,"rows_kept":11}
["Employee Name","Designation","Phone Number","Phone Number\n(Removing Dashes & Spaces)"]
["Ethan","Software Engineer","202 -555- 0147",{"$f":"SUBSTITUTE(SUBSTITUTE(TRIM(C2),\" \",\"\"),\"-\",\"\")","v":"2025550147"}]
["Olivia","Project Manager","202 -555  -0182",{"$f":"SUBSTITUTE(SUBSTITUTE(TRIM(C3),\" \",\"\"),\"-\",\"\")","v":"2025550182"}]
["Mason","Data Analyst","202-555  -0195","2025550195"]
["Sophia","Software Engineer","202-  555- 0136","2025550136"]
["Liam","Project Manager","202   -555-0179","2025550179"]
["Ava","Data Analyst","202 -555- 0163","2025550163"]
["Noah","Software Engineer","202-  555-0125","2025550125"]
["Emma","Project Manager","202-  555-0142","2025550142"]
["Lucas","Data Analyst","202-  555-0189","2025550189"]
["Chloe","HR Executive","202-555-  0113","2025550113"]

{"sheet":"Bulk","index":8,"n_rows":11,"n_cols":3,"rows_kept":11}
["Invoice No","Customer ID","Product Code"]
["INV-2025-0012","CUS-9988","PRD-AX23"]
["INV-2024-0098","CUS-8877","PRD-XY45"]
["INV-2023-0011","CUS-7766","PRD-ZZ12"]
["INV-2022-0055","CUS-6655","PRD-ML78"]
["INV-2021-0033","CUS-5544","PRD-OP90"]
["INV-2020-0099","CUS-4433","PRD-KL33"]
["INV-2019-0022","CUS-3322","PRD-QW11"]
["INV-2018-0088","CUS-2211","PRD-RT22"]
["INV-2017-0077","CUS-1100","PRD-TY44"]
["INV-2016-0066","CUS-0099","PRD-UV55"]

{"sheet":"Find and Replace ","index":9,"n_rows":11,"n_cols":3,"rows_kept":11}
["Invoice No","Customer ID","Product Code"]
["INV-2025-0012","CUS-9988","PRD-AX23"]
["INV-2024-0098","CUS-8877","PRD-XY45"]
["INV-2023-0011","CUS-7766","PRD-ZZ12"]
["INV-2022-0055","CUS-6655","PRD-ML78"]
["INV-2021-0033","CUS-5544","PRD-OP90"]
["INV-2020-0099","CUS-4433","PRD-KL33"]
["INV-2019-0022","CUS-3322","PRD-QW11"]
["INV-2018-0088","CUS-2211","PRD-RT22"]
["INV-2017-0077","CUS-1100","PRD-TY44"]
["INV-2016-0066","CUS-0099","PRD-UV55"]

{"sheet":"Table1","index":10,"n_rows":11,"n_cols":3,"rows_kept":11}
["Invoice No","Customer ID","Product Code"]
["INV20250012","CUS9988","PRDAX23"]
["INV20240098","CUS8877","PRDXY45"]
["INV20230011","CUS7766","PRDZZ12"]
["INV20220055","CUS6655","PRDML78"]
["INV20210033","CUS5544","PRDOP90"]
["INV20200099","CUS4433","PRDKL33"]
["INV20190022","CUS3322","PRDQW11"]
["INV20180088","CUS2211","PRDRT22"]
["INV20170077","CUS1100","PRDTY44"]
["INV20160066","CUS0099","PRDUV55"]

{"sheet":"Power Query","index":11,"n_rows":11,"n_cols":3,"rows_kept":11}
["Invoice No","Customer ID","Product Code"]
["INV-2025-0012","CUS-9988","PRD-AX23"]
["INV-2024-0098","CUS-8877","PRD-XY45"]
["INV-2023-0011","CUS-7766","PRD-ZZ12"]
["INV-2022-0055","CUS-6655","PRD-ML78"]
["INV-2021-0033","CUS-5544","PRD-OP90"]
["INV-2020-0099","CUS-4433","PRD-KL33"]
["INV-2019-0022","CUS-3322","PRD-QW11"]
["INV-2018-0088","CUS-2211","PRD-RT22"]
["INV-2017-0077","CUS-1100","PRD-TY44"]
["INV-2016-0066","CUS-0099","PRD-UV55"]

{"sheet":"VBA","index":12,"n_rows":11,"n_cols":3,"rows_kept":11}
["Invoice No","Customer ID","Product Code"]
["INV20250012","CUS9988","PRDAX23"]
["INV20240098","CUS8877","PRDXY45"]
["INV20230011","CUS7766","PRDZZ12"]
["INV20220055","CUS6655","PRDML78"]
["INV20210033","CUS5544","PRDOP90"]
["INV20200099","CUS4433","PRDKL33"]
["INV20190022","CUS3322","PRDQW11"]
["INV20180088","CUS2211","PRDRT22"]
["INV20170077","CUS1100","PRDTY44"]
["INV20160066","CUS0099","PRDUV55"]