{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Flash Fill","CONCATENATE","CONCAT","Ampersand","Highlight","REPLACE","Substitute","Find and Replace","TEXTJOIN","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":"Dataset","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List of Proverbs"]
[]
[null,"Proverb"]
[null,"A cat has nine lives."]
[null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never."]

{"sheet":"Flash Fill","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using Flash Fill Feature",null,null,null,"Do It yourself"]
[]
[null,"Original Data","Result",null,null,"Original Data","Result"]
[null,"A cat has nine lives.","Proverb: A cat has nine lives.",null,null,"A cat has nine lives."]
[null,"It's better to be safe than sorry.","Proverb: It's better to be safe than sorry.",null,null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words.","Proverb: Actions speak louder than words.",null,null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats.","Proverb: A rising tide lifts all boats.",null,null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover.","Proverb: Don't judge a book by its cover.",null,null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness.","Proverb: Cleanliness is next to Godliness.",null,null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm.","Proverb: The early bird catches the worm.",null,null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way.","Proverb: Where there’s a will, there’s a way.",null,null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it.","Proverb: If it ain’t broke, don’t fix it.",null,null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never.","Proverb: Better late than never.",null,null,"Better late than never."]

{"sheet":"CONCATENATE","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Utilizing CONCATENATE Function",null,null,null,"Do It yourself"]
[]
[null,"Original Data","Result",null,null,"Original Data","Result"]
[null,"A cat has nine lives.",{"$f":"CONCATENATE(\"Proverb: \",B5)","v":"Proverb: A cat has nine lives."},null,null,"A cat has nine lives."]
[null,"It's better to be safe than sorry.",{"$f":"CONCATENATE(\"Proverb: \",B6)","v":"Proverb: It's better to be safe than sorry."},null,null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words.","Proverb: Actions speak louder than words.",null,null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats.","Proverb: A rising tide lifts all boats.",null,null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover.","Proverb: Don't judge a book by its cover.",null,null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness.","Proverb: Cleanliness is next to Godliness.",null,null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm.","Proverb: The early bird catches the worm.",null,null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way.","Proverb: Where there’s a will, there’s a way.",null,null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it.","Proverb: If it ain’t broke, don’t fix it.",null,null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never.","Proverb: Better late than never.",null,null,"Better late than never."]

{"sheet":"CONCAT","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using CONCAT Function",null,null,null,"Do It yourself"]
[]
[null,"Original Data","Result",null,null,"Original Data","Result"]
[null,"A cat has nine lives.",{"$f":"_xlfn.CONCAT(\"Proverb: \",B5)","v":"Proverb: A cat has nine lives."},null,null,"A cat has nine lives."]
[null,"It's better to be safe than sorry.",{"$f":"_xlfn.CONCAT(\"Proverb: \",B6)","v":"Proverb: It's better to be safe than sorry."},null,null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words.","Proverb: Actions speak louder than words.",null,null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats.","Proverb: A rising tide lifts all boats.",null,null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover.","Proverb: Don't judge a book by its cover.",null,null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness.","Proverb: Cleanliness is next to Godliness.",null,null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm.","Proverb: The early bird catches the worm.",null,null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way.","Proverb: Where there’s a will, there’s a way.",null,null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it.","Proverb: If it ain’t broke, don’t fix it.",null,null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never.",{"$f":"_xlfn.CONCAT(\"Proverb: \",B14)","v":"Proverb: Better late than never."},null,null,"Better late than never."]

{"sheet":"Ampersand","index":4,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Implementing Ampersand Operator",null,null,null,"Do It yourself"]
[]
[null,"Original Data","Result",null,null,"Original Data","Result"]
[null,"A cat has nine lives.",{"$f":"\"Proverb: \"&B5","v":"Proverb: A cat has nine lives."},null,null,"A cat has nine lives."]
[null,"It's better to be safe than sorry.",{"$f":"\"Proverb: \"&B6","v":"Proverb: It's better to be safe than sorry."},null,null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words.","Proverb: Actions speak louder than words.",null,null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats.","Proverb: A rising tide lifts all boats.",null,null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover.","Proverb: Don't judge a book by its cover.",null,null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness.","Proverb: Cleanliness is next to Godliness.",null,null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm.","Proverb: The early bird catches the worm.",null,null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way.","Proverb: Where there’s a will, there’s a way.",null,null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it.","Proverb: If it ain’t broke, don’t fix it.",null,null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never.","Proverb: Better late than never.",null,null,"Better late than never."]

{"sheet":"Highlight","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Highlighting Cells to Add Text",null,null,null,"Do It yourself"]
[]
[null,"Text",null,null,null,"Text"]
[null,"A cat has nine lives."]
[null,"A cat has nine lives."]
[null,"A cat has nine lives."]
[null,"A cat has nine lives."]
[null,"A cat has nine lives."]
[null,"A cat has nine lives."]
[null,"A cat has nine lives."]
[null,"A cat has nine lives."]
[null,"A cat has nine lives."]
[null,"A cat has nine lives."]

{"sheet":"REPLACE","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Applying REPLACE Function",null,null,null,"Do It yourself"]
[]
[null,"Original Data","Result",null,null,"Original Data","Result"]
[null,"A cat has nine lives.",{"$f":"REPLACE(B5,1,0,\"Proverb: \")","v":"Proverb: A cat has nine lives."},null,null,"A cat has nine lives."]
[null,"It's better to be safe than sorry.",{"$f":"REPLACE(B6,1,0,\"Proverb: \")","v":"Proverb: It's better to be safe than sorry."},null,null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words.","Proverb: Actions speak louder than words.",null,null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats.","Proverb: A rising tide lifts all boats.",null,null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover.","Proverb: Don't judge a book by its cover.",null,null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness.","Proverb: Cleanliness is next to Godliness.",null,null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm.","Proverb: The early bird catches the worm.",null,null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way.","Proverb: Where there’s a will, there’s a way.",null,null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it.","Proverb: If it ain’t broke, don’t fix it.",null,null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never.","Proverb: Better late than never.",null,null,"Better late than never."]

{"sheet":"Substitute","index":7,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using SUBSTITUTE Function",null,null,null,"Do It yourself"]
[]
[null,"Original Data","Result",null,null,"Original Data","Result"]
[null,"A cat has nine lives.",{"$f":"SUBSTITUTE(B5,\".\",\". TRUE\")","v":"A cat has nine lives. TRUE"},null,null,"A cat has nine lives."]
[null,"It's better to be safe than sorry.",{"$f":"SUBSTITUTE(B6,\".\",\". TRUE\")","v":"It's better to be safe than sorry. TRUE"},null,null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words.","Actions speak louder than words. TRUE",null,null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats.","A rising tide lifts all boats. TRUE",null,null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover.","Don't judge a book by its cover. TRUE",null,null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness.","Cleanliness is next to Godliness. TRUE",null,null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm.","The early bird catches the worm. TRUE",null,null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way.","Where there’s a will, there’s a way. TRUE",null,null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it.","If it ain’t broke, don’t fix it. TRUE",null,null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never.","Better late than never. TRUE",null,null,"Better late than never."]

{"sheet":"Find and Replace","index":8,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Utilizing Find and Replace feature",null,null,null,"Do It yourself"]
[]
[null,"Original Data","Result",null,null,"Original Data","Result"]
[null,"A cat has nine lives.","A cat has nine lives. TRUE",null,null,"A cat has nine lives."]
[null,"It's better to be safe than sorry.","It's better to be safe than sorry. TRUE",null,null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words.","Actions speak louder than words. TRUE",null,null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats.","A rising tide lifts all boats. TRUE",null,null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover.","Don't judge a book by its cover. TRUE",null,null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness.","Cleanliness is next to Godliness. TRUE",null,null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm.","The early bird catches the worm. TRUE",null,null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way.","Where there’s a will, there’s a way. TRUE",null,null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it.","If it ain’t broke, don’t fix it. TRUE",null,null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never.","Better late than never. TRUE",null,null,"Better late than never."]

{"sheet":"TEXTJOIN","index":9,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Employing TEXTJOIN Function",null,null,null,"Do It yourself"]
[]
[null,"Original Data","Result",null,null,"Original Data","Result"]
[null,"A cat has nine lives.",{"$f":"_xlfn.TEXTJOIN(\": \",TRUE,\"Proverb\",B5)","v":"Proverb: A cat has nine lives."},null,null,"A cat has nine lives."]
[null,"It's better to be safe than sorry.",{"$f":"_xlfn.TEXTJOIN(\": \",TRUE,\"Proverb\",B6)","v":"Proverb: It's better to be safe than sorry."},null,null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words.","Proverb: Actions speak louder than words.",null,null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats.","Proverb: A rising tide lifts all boats.",null,null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover.","Proverb: Don't judge a book by its cover.",null,null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness.","Proverb: Cleanliness is next to Godliness.",null,null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm.","Proverb: The early bird catches the worm.",null,null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way.","Proverb: Where there’s a will, there’s a way.",null,null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it.","Proverb: If it ain’t broke, don’t fix it.",null,null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never.","Proverb: Better late than never.",null,null,"Better late than never."]

{"sheet":"VBA","index":10,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Applying VBA Code",null,null,null,"Do It yourself"]
[]
[null,"Original Data","Result",null,null,"Original Data","Result"]
[null,"A cat has nine lives.","Proverb: A cat has nine lives.",null,null,"A cat has nine lives."]
[null,"It's better to be safe than sorry.","Proverb: It's better to be safe than sorry.",null,null,"It's better to be safe than sorry."]
[null,"Actions speak louder than words.","Proverb: Actions speak louder than words.",null,null,"Actions speak louder than words."]
[null,"A rising tide lifts all boats.","Proverb: A rising tide lifts all boats.",null,null,"A rising tide lifts all boats."]
[null,"Don't judge a book by its cover.","Proverb: Don't judge a book by its cover.",null,null,"Don't judge a book by its cover."]
[null,"Cleanliness is next to Godliness.","Proverb: Cleanliness is next to Godliness.",null,null,"Cleanliness is next to Godliness."]
[null,"The early bird catches the worm.","Proverb: The early bird catches the worm.",null,null,"The early bird catches the worm."]
[null,"Where there’s a will, there’s a way.","Proverb: Where there’s a will, there’s a way.",null,null,"Where there’s a will, there’s a way."]
[null,"If it ain’t broke, don’t fix it.","Proverb: If it ain’t broke, don’t fix it.",null,null,"If it ain’t broke, don’t fix it."]
[null,"Better late than never.","Proverb: Better late than never.",null,null,"Better late than never."]