{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Home Page","1.1 Finding Text String","1.2 Finding Formula","2.1 Replace Values","2.2 Replacing Values to Balnk","2.3 Replacing Fill Color","2.4 Replacing Cell Ref","2.5 Replacing Format","2.6 Replace Line Break","3.1 Finding Exact Match","3.2 Finding Comment","3.3 Finding in Multiple Sheets","3.3 Finding in Multiple She (2)","3.3 Finding in Multiple She (3)","4.1 Wildcards (Asterisk)","4.2 Wildcards (Question Mark)","5.1 Finding Asterisk","5.1.1 Replacing Tab to Space","5.2 Removing Parentheses","REPLACE Function","SUBSTITUTE Function","FIND Function","Multiple Words","Replacing Comment VBA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":4,"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":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Find and Replace in Excel"]
[]
[null,"Learn to Find and Replace Data in Excel with this free workbook. Read the article we provided and practice these in practice section."]
[]
[null,"Prepared By:","Musiha Mahfuza Mukta"]
[null,"Reviewed By:","Mursalin Ibne Salehin"]
[null,"Last Update:","2023-11-16"]
[null,"Article Link:"]
[]
[null,"Main Content"]
[null,"How to Find Data in Excel"]
[null,"1. Finding Text String"]
[null,"2. Finding Formula"]
[null,"How to Replace Data in Excel"]
[null,"1. Replace one value with another"]
[null,"2. Replacing Values to Balnk"]
[null,"3. Replacing Fill Color"]
[null,"4. Replacing Cell References of Formula"]
[null,"5. Find and Replace Data with Specific Format"]
[null,"6. Find and Replace Line Breaks"]
[null,"How to Work with Advanced Find and Replace"]
[null,"1. Finding Exact Match"]
[null,"2. Finding Comment"]
[null,"3. Finding in Multiple Sheets"]
[null,"How to Find and Replace Data Using Wildcards"]
[null,"Wildcards (Asterisk)"]
[null,"Wildcards (Question Mark)"]
[null,"How to Find and Replace Special Characters"]
[null,"1. Finding & Replacing Asterisk"]
[null,"1.1 Replacing Tab to Space"]
[null,"2. Removing Parentheses"]
[null,"How to Find and Replace with Formulas"]
[null,"1.1 Using REPLACE function to replace data"]
[null,"1.2 Using SUBSTITUTE function to replace data"]
[null,"2. Using FIND function to find data"]
[null,"3. Finding Multiple Words with XLOOKUP function"]
[]
[null,"Replacing Comment with VBA Code"]
[]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"1.1 Finding Text String","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Finding Text String in Excel Sheet"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.2 Finding Formula","index":2,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[17,1,17,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Finding a Cell with Specific Formula",null,null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[null,null,null,"Total Cost",{"$f":"SUM(E6:E15)","v":26600},null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(P6:P15)","v":26600}]
[]
[null,">> We will find the Cell that contains the SUM formula."]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2.1 Replace Values","index":3,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Replacing One Value with Another",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"Planning"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"Planning"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"Planning"]
[]
[null,">> We will replace the status \"Planning\" to \"In Progress\"."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2.2 Replacing Values to Balnk","index":4,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Replacing Value to Blank Cell",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",null,"Planning",null,null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will replace the cost \"1500\" to Blank."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2.3 Replacing Fill Color","index":5,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,2]]}
[null,"Find and Replace in Excel"]
[]
[null,"Replacing Fill Color",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will replace the cell color ---->",null,null,"to"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2.4 Replacing Cell Ref","index":6,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[19,1,19,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Replacing Cell Reference of Formula",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[null,"AB3023011","Return Policy","2023-10-10",1100,"In Progress",null,null,null,null,null,null,"AB3023011","Return Policy","2023-10-10",1100,"In Progress"]
[null,"AB3023012","Quality Control","2023-11-12",1980,"Planning",null,null,null,null,null,null,"AB3023012","Quality Control","2023-11-12",1980,"Planning"]
[null,null,null,"Total Cost",{"$f":"SUM(E6:E17)","v":29680},null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(P6:P15)","v":26600}]
[]
[null,">> We will replace the range of SUM function."]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2.5 Replacing Format","index":7,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Finding and Replacing Data with Specific Format",null,null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will change the cost Format (Dollar to Euro)."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2.6 Replace Line Break","index":8,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Finding and Replacing Line Breaks in Excel",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001","Market \nResearch","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002","Web Design \nand Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003","Training and \nDevelopment","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004","Product Development\n and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005","Quality Assurance\n and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007","Sales Pipeline\n Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,null,"AB3023008","Social Media\n Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009","Supply Chain\n Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010","Risk Management\n and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will remove Line break."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"3.1 Finding Exact Match","index":9,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using Advanced Setting of Find and Replace Tool to Find Exact Match",null,null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will find the project named \"Sales Pipeline Analysis\"."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"3.2 Finding Comment","index":10,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using Advanced Setting of Find and Replace Tool to Find Comment",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will find the project name that contains \"Good\" as comment."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"3.3 Finding in Multiple Sheets","index":11,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,2],[16,1,16,2]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using Advanced Setting of Find and Replace Tool",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name",null,null,null,null,null,null,null,null,"Project ID","Project Name"]
[null,"AB3023001","Market Research",null,null,null,null,null,null,null,null,"AB3023001","Market Research"]
[null,"AB3023002","Web Design and Optimization",null,null,null,null,null,null,null,null,"AB3023002","Web Design and Optimization"]
[null,"AB3023003","Training and Development",null,null,null,null,null,null,null,null,"AB3023003","Training and Development"]
[null,"AB3023004","Product Development and Launch",null,null,null,null,null,null,null,null,"AB3023004","Product Development and Launch"]
[null,"AB3023005","Quality Assurance and Testing",null,null,null,null,null,null,null,null,"AB3023005","Quality Assurance and Testing"]
[null,"AB3023006","Financial Trends",null,null,null,null,null,null,null,null,"AB3023006","Financial Trends"]
[null,"AB3023007","Sales Pipeline Analysis",null,null,null,null,null,null,null,null,"AB3023007","Sales Pipeline Analysis"]
[null,"AB3023008","Social Media Enhancement",null,null,null,null,null,null,null,null,"AB3023008","Social Media Enhancement"]
[null,"AB3023009","Supply Chain Optimization",null,null,null,null,null,null,null,null,"AB3023009","Supply Chain Optimization"]
[null,"AB3023010","Risk Management and Compliance",null,null,null,null,null,null,null,null,"AB3023010","Risk Management and Compliance"]
[]
[null,">> We will find the project details having ID \"AB3023005\"."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"3.3 Finding in Multiple She (2)","index":12,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,3],[16,1,16,3]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using Advanced Setting of Find and Replace Tool"]
[]
[null,"Project ID","Start Date","Cost"]
[null,"AB3023001","2023-05-05",2500]
[null,"AB3023002","2023-05-05",2200]
[null,"AB3023003","2023-05-05",3000]
[null,"AB3023004","2023-05-29",3300]
[null,"AB3023005","2023-06-08",2500]
[null,"AB3023006","2023-06-10",4000]
[null,"AB3023007","2023-06-11",3000]
[null,"AB3023008","2023-07-15",1500]
[null,"AB3023009","2023-07-20",2200]
[null,"AB3023010","2023-07-21",2400]
[]
[null,">> We will find the project details having ID \"AB3023005\"."]

{"sheet":"3.3 Finding in Multiple She (3)","index":13,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,2],[16,1,16,2]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using Advanced Setting of Find and Replace Tool"]
[]
[null,"Project ID","Status"]
[null,"AB3023001","In Progress"]
[null,"AB3023002","Completed"]
[null,"AB3023003","Planning"]
[null,"AB3023004","In Progress"]
[null,"AB3023005","In Progress"]
[null,"AB3023006","Completed"]
[null,"AB3023007","In Progress"]
[null,"AB3023008","Planning"]
[null,"AB3023009","In Progress"]
[null,"AB3023010","In Progress"]
[]
[null,">> We will find the project details having ID \"AB3023005\"."]

{"sheet":"4.1 Wildcards (Asterisk)","index":14,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using Asterisk (*) to Find and Replace String of Characters",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will find the project names that contain the initial character 'S'."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"4.2 Wildcards (Question Mark)","index":15,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using Question Mark to Find Single Character",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AC3023001","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,"AC3023001","Training and Development","2023-05-05",3000,"Planning"]
[null,"AC3023002","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,"AC3023002","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AC3023003","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,"AC3023003","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AD3023001","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,"AD3023001","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AD3023002","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,"AD3023002","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AD3023003","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,"AD3023003","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will find the project ID having 'A' at the beginning and '3023001' as number code."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"5.1 Finding Asterisk","index":16,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Finding and Replacing Cells Having Asterisk (*)",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress*",null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress*"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress*",null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress*"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress*",null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress*"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will find the status that contains asterisk (*) mark."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"5.1.1 Replacing Tab to Space","index":17,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Finding and Replacing Tab to Single Space",null,null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002","Web Design     and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006","Financial     Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007","Sales Pipeline      Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009","Supply Chain     Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will replace Tab to single Space."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"5.2 Removing Parentheses","index":18,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,1,16,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Removing Cell Values Within Parentheses",null,null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001 (MR)","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,null,"AB3023001 (MR)","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002 (WDO)","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,null,"AB3023002 (WDO)","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003 (TD)","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,null,"AB3023003 (TD)","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004 (PDL)","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,null,"AB3023004 (PDL)","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005 (QAT)","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,null,"AB3023005 (QAT)","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006 (FT)","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,null,"AB3023006 (FT)","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007 (SPA)","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,null,"AB3023007 (SPA)","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008 (SME)","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,null,"AB3023008 (SME)","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009 (SCO)","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,null,"AB3023009 (SCO)","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010 (RMC)","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,null,"AB3023010 (RMC)","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[null,">> We will remove all the values within Parentheses."]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"REPLACE Function","index":19,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,3],[2,1,2,3]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using REPLACE Function to Replace Particular Characters",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Original Value","Replaced Value",null,null,null,null,null,null,null,null,null,"Original Value","Replaced Value"]
[null,"AB3023001",{"$f":"REPLACE(B6,3,2,\"C4\")","v":"ABC423001"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=REPLACE(B6,3,2,\"C4\")"},null,null,null,null,null,null,null,null,"AB3023001"]
[null,"AB3023002",{"$f":"REPLACE(B7,3,2,\"C4\")","v":"ABC423002"},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=REPLACE(B7,3,2,\"C4\")"},null,null,null,null,null,null,null,null,"AB3023002"]
[null,"AB3023003","ABC423003","=REPLACE(B8,3,2,\"C4\")",null,null,null,null,null,null,null,null,"AB3023003"]
[null,"AB3023004","ABC423004","=REPLACE(B9,3,2,\"C4\")",null,null,null,null,null,null,null,null,"AB3023004"]
[null,"AB3023005","ABC423005","=REPLACE(B10,3,2,\"C4\")",null,null,null,null,null,null,null,null,"AB3023005"]
[null,"AB3023006","ABC423006","=REPLACE(B11,3,2,\"C4\")",null,null,null,null,null,null,null,null,"AB3023006"]
[null,"AB3023007","ABC423007","=REPLACE(B12,3,2,\"C4\")",null,null,null,null,null,null,null,null,"AB3023007"]
[null,"AB3023008","ABC423008","=REPLACE(B13,3,2,\"C4\")",null,null,null,null,null,null,null,null,"AB3023008"]
[null,"AB3023009","ABC423009","=REPLACE(B14,3,2,\"C4\")",null,null,null,null,null,null,null,null,"AB3023009"]
[null,"AB3023010",{"$f":"REPLACE(B15,3,2,\"C4\")","v":"ABC423010"},"=REPLACE(B15,3,2,\"C4\")",null,null,null,null,null,null,null,null,"AB3023010"]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"SUBSTITUTE Function","index":20,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using SUBSTITUTE Function to Replace Particular Word",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Original Value","Replaced Value",null,null,null,null,null,null,null,null,null,"Original Value","Replaced Value"]
[null,"Lenova Notebook 2017",{"$f":"SUBSTITUTE(B6,\"Notebook\",\"Laptop\",1)","v":"Lenova Laptop 2017"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=SUBSTITUTE(B6,\"Notebook\",\"Laptop\",1)"},null,null,null,null,null,null,null,null,"Lenova Notebook 2017"]
[null,"HP Notebook 2018","HP Laptop 2018","=SUBSTITUTE(B7,\"Notebook\",\"Laptop\",1)",null,null,null,null,null,null,null,null,"HP Notebook 2018"]
[null,"Asus Notebook 2018","Asus Laptop 2018","=SUBSTITUTE(B8,\"Notebook\",\"Laptop\",1)",null,null,null,null,null,null,null,null,"Asus Notebook 2018"]
[null,"Acer Notebook 2018","Acer Laptop 2018","=SUBSTITUTE(B9,\"Notebook\",\"Laptop\",1)",null,null,null,null,null,null,null,null,"Acer Notebook 2018"]
[null,"Dell Notebook 2019","Dell Laptop 2019","=SUBSTITUTE(B10,\"Notebook\",\"Laptop\",1)",null,null,null,null,null,null,null,null,"Dell Notebook 2019"]
[null,"Lenova Notebook 2018","Lenova Laptop 2018","=SUBSTITUTE(B11,\"Notebook\",\"Laptop\",1)",null,null,null,null,null,null,null,null,"Lenova Notebook 2018"]
[null,"Asus Notebook 2019","Asus Laptop 2019","=SUBSTITUTE(B12,\"Notebook\",\"Laptop\",1)",null,null,null,null,null,null,null,null,"Asus Notebook 2019"]
[null,"Acer Notebook 2019","Acer Laptop 2019","=SUBSTITUTE(B13,\"Notebook\",\"Laptop\",1)",null,null,null,null,null,null,null,null,"Acer Notebook 2019"]
[null,"HP Notebook 2019","HP Laptop 2019","=SUBSTITUTE(B14,\"Notebook\",\"Laptop\",1)",null,null,null,null,null,null,null,null,"HP Notebook 2019"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"FIND Function","index":21,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using FIND Function to Find the Position of Specific Characters",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Status","Character Position",null,null,null,null,null,null,null,null,"Project ID","Status","Character Position"]
[null,"AB3023001","In Progress",{"$f":"FIND(\"P\",C6)","v":4},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=FIND(\"P\",C6)"},null,null,null,null,null,null,null,"AB3023001","In Progress"]
[null,"AB3023002","Completed",{"$f":"FIND(\"Completed\",C7)","v":1},{"$f":"_xlfn.FORMULATEXT(D7)","v":"=FIND(\"Completed\",C7)"},null,null,null,null,null,null,null,"AB3023002","Completed"]
[null,"AB3023003","Planning",{"$f":"FIND(\"Completed\",C8)","v":{"$error":"#VALUE!"}},"=FIND(\"Completed\",C8)",null,null,null,null,null,null,null,"AB3023003","Planning"]
[null,"AB3023004","In Progress",{"$error":"#VALUE!"},"=FIND(\"Completed\",C9)",null,null,null,null,null,null,null,"AB3023004","In Progress"]
[null,"AB3023005","In Progress",{"$error":"#VALUE!"},"=FIND(\"Completed\",C10)",null,null,null,null,null,null,null,"AB3023005","In Progress"]
[null,"AB3023006","Completed",1,"=FIND(\"Completed\",C11)",null,null,null,null,null,null,null,"AB3023006","Completed"]
[null,"AB3023007","In Progress",{"$error":"#VALUE!"},"=FIND(\"Completed\",C12)",null,null,null,null,null,null,null,"AB3023007","In Progress"]
[null,"AB3023008","Planning",{"$error":"#VALUE!"},"=FIND(\"Completed\",C13)",null,null,null,null,null,null,null,"AB3023008","Planning"]
[null,"AB3023009","In Progress",{"$error":"#VALUE!"},"=FIND(\"Completed\",C14)",null,null,null,null,null,null,null,"AB3023009","In Progress"]
[null,"AB3023010","In Progress",{"$error":"#VALUE!"},"=FIND(\"Completed\",C15)",null,null,null,null,null,null,null,"AB3023010","In Progress"]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Multiple Words","index":22,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,6],[2,1,2,6],[2,12,2,16]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using XLOOKUP Function to Replace Multiple Words",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"ID List","Project Name",null,"Random IDs","Replaced Value",null,null,null,null,null,null,"Random IDs","Replaced Value",null,"ID List","Project Name"]
[null,"AB3023001","Market Research",null,"AB3023010",{"$f":"_xlfn.XLOOKUP(E6, $B$6:$B$15, $C$6:$C$15, $E$6)","v":"Risk Management"},{"$f":"_xlfn.FORMULATEXT(F6)","v":"=XLOOKUP(E6, $B$6:$B$15, $C$6:$C$15, $E$6)"},null,null,null,null,null,"AB3023010",null,null,"AB3023001","Market Research"]
[null,"AB3023002","Web Design",null,"AB3023002",{"$f":"_xlfn.XLOOKUP(E7, $B$6:$B$15, $C$6:$C$15, $E$6)","v":"Web Design"},{"$f":"_xlfn.FORMULATEXT(F7)","v":"=XLOOKUP(E7, $B$6:$B$15, $C$6:$C$15, $E$6)"},null,null,null,null,null,"AB3023002",null,null,"AB3023002","Web Design"]
[null,"AB3023003","Training and Development",null,"AB3023006","Financial Trends","=XLOOKUP(E8, $B$6:$B$15, $C$6:$C$15, $E$6)",null,null,null,null,null,"AB3023006",null,null,"AB3023003","Training and Development"]
[null,"AB3023004","Product Development",null,"AB3023004","Product Development","=XLOOKUP(E9, $B$6:$B$15, $C$6:$C$15, $E$6)",null,null,null,null,null,"AB3023004",null,null,"AB3023004","Product Development"]
[null,"AB3023005","Quality Testing",null,"AB3023007","Sales Pipeline Analysis","=XLOOKUP(E10, $B$6:$B$15, $C$6:$C$15, $E$6)",null,null,null,null,null,"AB3023007",null,null,"AB3023005","Quality Testing"]
[null,"AB3023006","Financial Trends",null,"AB3023002","Web Design","=XLOOKUP(E11, $B$6:$B$15, $C$6:$C$15, $E$6)",null,null,null,null,null,"AB3023002",null,null,"AB3023006","Financial Trends"]
[null,"AB3023007","Sales Pipeline Analysis",null,"AB3023005","Quality Testing","=XLOOKUP(E12, $B$6:$B$15, $C$6:$C$15, $E$6)",null,null,null,null,null,"AB3023005",null,null,"AB3023007","Sales Pipeline Analysis"]
[null,"AB3023008","Social Media Enhancement",null,"AB3023004","Product Development","=XLOOKUP(E13, $B$6:$B$15, $C$6:$C$15, $E$6)",null,null,null,null,null,"AB3023004",null,null,"AB3023008","Social Media Enhancement"]
[null,"AB3023009","Supply Chain Optimization",null,"AB3023001","Market Research","=XLOOKUP(E14, $B$6:$B$15, $C$6:$C$15, $E$6)",null,null,null,null,null,"AB3023001",null,null,"AB3023009","Supply Chain Optimization"]
[null,"AB3023010","Risk Management",null,"AB3023004","Product Development","=XLOOKUP(E15, $B$6:$B$15, $C$6:$C$15, $E$6)",null,null,null,null,null,"AB3023004",null,null,"AB3023010","Risk Management"]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Replacing Comment VBA","index":23,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Find and Replace in Excel"]
[]
[null,"Using VBA to Replace Comment",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Project ID","Project Name","Start Date","Cost","Status",null,null,null,null,null,"Project ID","Project Name","Start Date","Cost","Status"]
[null,"AB3023001","Market Research","2023-05-05",2500,"In Progress",null,null,null,null,null,"AB3023001","Market Research","2023-05-05",2500,"In Progress"]
[null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed",null,null,null,null,null,"AB3023002","Web Design and Optimization","2023-05-05",2200,"Completed"]
[null,"AB3023003","Training and Development","2023-05-05",3000,"Planning",null,null,null,null,null,"AB3023003","Training and Development","2023-05-05",3000,"Planning"]
[null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress",null,null,null,null,null,"AB3023004","Product Development and Launch","2023-05-29",3300,"In Progress"]
[null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress",null,null,null,null,null,"AB3023005","Quality Assurance and Testing","2023-06-08",2500,"In Progress"]
[null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed",null,null,null,null,null,"AB3023006","Financial Trends","2023-06-10",4000,"Completed"]
[null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress",null,null,null,null,null,"AB3023007","Sales Pipeline Analysis","2023-06-11",3000,"In Progress"]
[null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning",null,null,null,null,null,"AB3023008","Social Media Enhancement","2023-07-15",1500,"Planning"]
[null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress",null,null,null,null,null,"AB3023009","Supply Chain Optimization","2023-07-20",2200,"In Progress"]
[null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress",null,null,null,null,null,"AB3023010","Risk Management and Compliance","2023-07-21",2400,"In Progress"]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]