{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Add Text - Examples","Prepend text","Append text","Add text on both sides","Combine two cells","Combine multiple cells","Add special character","Add text to formula","Add text after nth char","Add text after specific char","Add space between text","VBA codes"],"not_rendered":{"charts":0,"images":4,"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":"Add Text - Examples","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,1,21,2],[3,1,3,2],[5,1,5,2],[8,2,8,3],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[]
[]
[]
[null,"Sample Workbook to Add Text in Excel"]
[]
[null,"The workbook shows how to add the same text or character to all cells in Excel: to the beginning, to the end, before/after a specific character, at a certain position, and to a formula."]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-08-17"]
[null,"Tutorial URL","How to add text to every cell in Excel"]
[]
[null,"Examples:"]
["• ","Add text to beginning"]
["• ","Add text to end"]
["• ","Insert text on both sides of a string"]
["• ","Combine text from two cells "]
["• ","Combine text from multiple cells "]
["• ","Add special character to cell "]
["• ","Add text to formula result"]
["• ","Insert text after nth character"]
["• ","Add text before/after a specific character"]
["• ","Insert space between text"]
["• ","Add same text to multiple cells using VBA "]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Prepend text","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Original data","Result","Result",null,"Text to add"]
["Cascade",{"$f":"$E$2&A2","v":"Project:Cascade"},{"$f":"$E$2&\" \"&A2","v":"Project: Cascade"},null,"Project:"]
["Hornets",{"$f":"$E$2&A3","v":"Project:Hornets"},{"$f":"$E$2&\" \"&A3","v":"Project: Hornets"}]
["Mercury","Project:Mercury","Project: Mercury"]
["Skill-Up","Project:Skill-Up","Project: Skill-Up"]
["Sputnik","Project:Sputnik","Project: Sputnik"]
["Whistler","Project:Whistler","Project: Whistler"]
["Yaeger","Project:Yaeger","Project: Yaeger"]

{"sheet":"Append text","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Original data","Result",null,"Text to add"]
["Cascade",{"$f":"A2&$D$2","v":"Cascade-US"},null,"-US"]
["Hornets",{"$f":"A3&$D$2","v":"Hornets-US"}]
["Mercury","Mercury-US"]
["Skill-Up","Skill-Up-US"]
["Sputnik","Sputnik-US"]
["Whistler","Whistler-US"]
["Yaeger","Yaeger-US"]

{"sheet":"Add text on both sides","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
["Original data","Result",null,"Text to add"]
["Cascade",{"$f":"CONCATENATE($E$2, A2, $E$3)","v":"Project:Cascade-US"},null,"To beginning","Project:"]
["Hornets",{"$f":"CONCATENATE($E$2, A3, $E$3)","v":"Project:Hornets-US"},null,"To end","-US"]
["Mercury","Project:Mercury-US"]
["Skill-Up","Project:Skill-Up-US"]
["Sputnik","Project:Sputnik-US"]
["Whistler","Project:Whistler-US"]
["Yaeger","Project:Yaeger-US"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Combine two cells","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Project","Department","Result"]
["Cascade","Analysis",{"$f":"CONCATENATE(A2, \", \", B2)","v":"Cascade, Analysis"}]
["Hornets","Design",{"$f":"CONCATENATE(A3, \", \", B3)","v":"Hornets, Design"}]
["Mercury","Planning","Mercury, Planning"]
["Skill-Up","QA","Skill-Up, QA"]
["Sputnik","Testing","Sputnik, Testing"]
["Whistler","Design","Whistler, Design"]
["Yaeger","Analysis","Yaeger, Analysis"]

{"sheet":"Combine multiple cells","index":5,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Project","Department","Status","Result"]
["Cascade","Analysis","In progress",{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, A2, B2, C2)","v":"Cascade, Analysis, In progress"}]
["Hornets","Design","Completed",{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, A3, B3, C3)","v":"Hornets, Design, Completed"}]
["Mercury","Planning","Cancelled","Mercury, Planning, Cancelled"]
["Skill-Up","QA","In progress","Skill-Up, QA, In progress"]
["Sputnik","Testing","Completed","Sputnik, Testing, Completed"]
["Whistler","Design","In progress","Whistler, Design, In progress"]
["Yaeger","Analysis","In progress","Yaeger, Analysis, In progress"]

{"sheet":"Add special character","index":6,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Cascade",{"$f":"A2&CHAR(153)","v":"Cascade™"}]
["Hornets",{"$f":"A3&CHAR(153)","v":"Hornets™"}]
["Mercury","Mercury™"]
["Skill-Up","Skill-Up™"]
["Sputnik","Sputnik™"]
["Whistler","Whistler™"]
["Yaeger","Yaeger™"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Add text to formula","index":7,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Add text to formula"]
["Before","After","On both sides"]
[{"$f":"\"Current time: \"&TEXT(NOW(), \"h:mm AM/PM\")","v":"Current time: 1:52 PM"},{"$f":"CONCATENATE(TEXT(NOW(), \"h:mm AM/PM\"), \" - current time\")","v":"1:52 PM - current time"},{"$f":"CONCATENATE(\"It's \", TEXT(NOW(), \"h:mm AM/PM\"), \" here in Gomel\")","v":"It's 1:52 PM here in Gomel"}]

{"sheet":"Add text after nth char","index":8,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["AA001",{"$f":"LEFT(A2,2) &\"-\"& RIGHT(A2,LEN(A2) -2)","v":"AA-001"}]
["AB0022",{"$f":"LEFT(A3,2)&\"-\"&RIGHT(A3,LEN(A3)-2)","v":"AB-0022"}]
["AC03","AC-03"]
["BB004","BB-004"]
["BA00005","BA-00005"]
["BC6","BC-6"]

{"sheet":"Add text after specific char","index":9,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Add text"]
["Original data","Before char","After char"]
["A-001",{"$f":"LEFT(A3, SEARCH(\"-\", A3) -1) &\"(US)\"& RIGHT(A3, LEN(A3) -SEARCH(\"-\", A3) +1)","v":"A(US)-001"},{"$f":"LEFT(A3, SEARCH(\"-\", A3)) &\"(US)\"& RIGHT(A3, LEN(A3) -SEARCH(\"-\", A3))","v":"A-(US)001"}]
["AB-0022",{"$f":"LEFT(A4, SEARCH(\"-\", A4) -1) &\"(US)\"& RIGHT(A4, LEN(A4) -SEARCH(\"-\", A4) +1)","v":"AB(US)-0022"},{"$f":"LEFT(A4, SEARCH(\"-\", A4)) &\"(US)\"& RIGHT(A4, LEN(A4) -SEARCH(\"-\", A4))","v":"AB-(US)0022"}]
["ACC-03","ACC(US)-03","ACC-(US)03"]
["B-004","B(US)-004","B-(US)004"]
["BA-0005","BA(US)-0005","BA-(US)0005"]
["BCDD-6","BCDD(US)-6","BCDD-(US)6"]

{"sheet":"Add space between text","index":10,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Project 1:Cascade",{"$f":"LEFT(A2,SEARCH(\":\", A2)) &\" \"& RIGHT(A2, LEN(A2)-SEARCH(\":\", A2))","v":"Project 1: Cascade"}]
["Project 11:Hornets",{"$f":"LEFT(A3,SEARCH(\":\",A3))&\" \"&RIGHT(A3,LEN(A3)-SEARCH(\":\",A3))","v":"Project 11: Hornets"}]
["Project 111:Mercury","Project 111: Mercury"]
["Project 2:Skill-Up","Project 2: Skill-Up"]
["Project 22:Sputnik","Project 22: Sputnik"]
["Project 222:Whistler","Project 222: Whistler"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"VBA codes","index":11,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["The workbook contains the following macros:"]
["PrependText  - adds text to the beginning of the original cells."]
["PrependText2 - prepends text and places the results in a column to the right of the selected range."]
["AppendText - adds text to the end of the original cells."]
["AppendText2 - appends text and places the results in a column to the right of the selected range."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["How to use the macros:"]
["1. Select the sample data in this worksheet (A14:A20) or some data in your own worksheet while keeping this workbook open."]
["3. Press Alt + F8, select one of the above macros, and click Run."]
[]
[]
["Sample data"]
["Cascade"]
["Hornets"]
["Mercury"]
["Skill-Up"]
["Sputnik"]
["Whistler"]
["Yaeger"]
[null,null,null," "]