{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Extract Word - Examples","Extract first word","Extract last word","Extract second word","Extract Nth word","Custom delimiter","Get word containing character","Get word containing text","Extract text after word","Split string in rows","Split string in columns","Extract word from range"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":2,"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":"Extract Word - Examples","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,5],[5,1,5,2]]}
[]
[]
[]
[null,"How to Extract Words in Excel"]
[]
[null,"The workbook shows how to quickly extract first, last or Nth word from a string using a custom function."]
[null,"Author","Ablebits.com"]
[null,"Last update","2023-09-11"]
[null,"Tutorial URL","How to extract word from Excel cell"]
[]
[null,"Examples:"]
["• ","Extract first word"]
["• ","Get last word"]
["• ","Extract second word from start or end of string"]
["• ","Return Nth word"]
["• ","Extract words with custom delimiter"]
["• ","Get word that contains particular character"]
["• ","Extract word containing specific text"]
["• ","Extract text after word"]
["• ","Split text into words in separate rows"]
["• ","Split text into words in separate columns"]
["• ","Get word from a range of cells"]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Extract first word","index":1,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Extracting first word in Excel"]
["String","First word - native formula","First word - UDF"]
["Alice Johnson, 30 years, teacher",{"$f":"MID(A3, 1, SEARCH(\" \", A3) -1)","v":"Alice"},{"$f":"ExtractWord(A3)","v":"Alice"}]
["Michael Brown, 42 years, engineer",{"$f":"MID(A4, 1, SEARCH(\" \", A4) -1)","v":"Michael"},{"$f":"ExtractWord(A4)","v":"Michael"}]
["Emily Davis, 28 years, artist","Emily",{"$f":"ExtractWord(A5)","v":"Emily"}]
["Daniel Wilson, 35 years, doctor","Daniel",{"$f":"ExtractWord(A6)","v":"Daniel"}]
["Olivia Lee, 24 years, architect","Olivia",{"$f":"ExtractWord(A7)","v":"Olivia"}]
["William Anderson, 29 years, chef","William",{"$f":"ExtractWord(A8)","v":"William"}]
["Sophia Miller, 27 years, scientist","Sophia",{"$f":"ExtractWord(A9)","v":"Sophia"}]
["Joseph Martinez, 38 years, musician","Joseph",{"$f":"ExtractWord(A10)","v":"Joseph"}]
["Ava Taylor, 31 years, accountant","Ava",{"$f":"ExtractWord(A11)","v":"Ava"}]
["James Jackson, 40 years, writer","James",{"$f":"ExtractWord(A12)","v":"James"}]
["Mia White, 26 years, lawyer","Mia",{"$f":"ExtractWord(A13)","v":"Mia"}]
["Benjamin Harris, 33 years, pilot","Benjamin",{"$f":"ExtractWord(A14)","v":"Benjamin"}]
["Charlotte Moore, 36 years, nurse","Charlotte",{"$f":"ExtractWord(A15)","v":"Charlotte"}]
["Ethan Thompson, 32 years, pharmacist","Ethan",{"$f":"ExtractWord(A16)","v":"Ethan"}]
["Grace Turner, 23 years, firefighter","Grace",{"$f":"ExtractWord(A17)","v":"Grace"}]
["Samuel Lewis, 45 years, police officer","Samuel",{"$f":"ExtractWord(A18)","v":"Samuel"}]
["Chloe Allen, 34 years, software developer","Chloe",{"$f":"ExtractWord(A19)","v":"Chloe"}]
["Henry King, 37 years, electrician","Henry",{"$f":"ExtractWord(A20)","v":"Henry"}]
["Elizabeth Young, 29 years, psychologist","Elizabeth",{"$f":"ExtractWord(A21)","v":"Elizabeth"}]
["Noah Scott, 41 years, farmer","Noah",{"$f":"ExtractWord(A22)","v":"Noah"}]
["Lily Walker, 25 years, graphic designer","Lily",{"$f":"ExtractWord(A23)","v":"Lily"}]
["Andrew Hall, 39 years, construction worker","Andrew",{"$f":"ExtractWord(A24)","v":"Andrew"}]
["Abigail Bennett, 28 years, journalist","Abigail",{"$f":"ExtractWord(A25)","v":"Abigail"}]
["David Adams, 44 years, real estate agent","David",{"$f":"ExtractWord(A26)","v":"David"}]
["Harper Hall, 30 years, marketing manager","Harper",{"$f":"ExtractWord(A27)","v":"Harper"}]

{"sheet":"Extract last word","index":2,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Extracting last word in Excel"]
["String","Last word - native formula","Last word - UDF"]
["Alice Johnson, 30 years, teacher",{"$f":"TRIM(RIGHT(SUBSTITUTE(A3,\" \", REPT(\" \", LEN(A3))), LEN(A3)))","v":"teacher"},{"$f":"ExtractWord(A3, -1)","v":"teacher"}]
["Michael Brown, 42 years, engineer",{"$f":"TRIM(RIGHT(SUBSTITUTE(A4,\" \",REPT(\" \",LEN(A4))),LEN(A4)))","v":"engineer"},{"$f":"ExtractWord(A4, -1)","v":"engineer"}]
["Emily Davis, 28 years, artist","artist",{"$f":"ExtractWord(A5, -1)","v":"artist"}]
["Daniel Wilson, 35 years, doctor","doctor",{"$f":"ExtractWord(A6, -1)","v":"doctor"}]
["Olivia Lee, 24 years, architect","architect",{"$f":"ExtractWord(A7, -1)","v":"architect"}]
["William Anderson, 29 years, chef","chef",{"$f":"ExtractWord(A8, -1)","v":"chef"}]
["Sophia Miller, 27 years, scientist","scientist",{"$f":"ExtractWord(A9, -1)","v":"scientist"}]
["Joseph Martinez, 38 years, musician","musician",{"$f":"ExtractWord(A10, -1)","v":"musician"}]
["Ava Taylor, 31 years, accountant","accountant",{"$f":"ExtractWord(A11, -1)","v":"accountant"}]
["James Jackson, 40 years, writer","writer",{"$f":"ExtractWord(A12, -1)","v":"writer"}]
["Mia White, 26 years, lawyer","lawyer",{"$f":"ExtractWord(A13, -1)","v":"lawyer"}]
["Benjamin Harris, 33 years, pilot","pilot",{"$f":"ExtractWord(A14, -1)","v":"pilot"}]
["Charlotte Moore, 36 years, nurse","nurse",{"$f":"ExtractWord(A15, -1)","v":"nurse"}]
["Ethan Thompson, 32 years, pharmacist","pharmacist",{"$f":"ExtractWord(A16, -1)","v":"pharmacist"}]
["Grace Turner, 23 years, firefighter","firefighter",{"$f":"ExtractWord(A17, -1)","v":"firefighter"}]
["Samuel Lewis, 45 years, police officer","officer",{"$f":"ExtractWord(A18, -1)","v":"officer"}]
["Chloe Allen, 34 years, software developer","developer",{"$f":"ExtractWord(A19, -1)","v":"developer"}]
["Henry King, 37 years, electrician","electrician",{"$f":"ExtractWord(A20, -1)","v":"electrician"}]
["Elizabeth Young, 29 years, psychologist","psychologist",{"$f":"ExtractWord(A21, -1)","v":"psychologist"}]
["Noah Scott, 41 years, farmer","farmer",{"$f":"ExtractWord(A22, -1)","v":"farmer"}]
["Lily Walker, 25 years, graphic designer","designer",{"$f":"ExtractWord(A23, -1)","v":"designer"}]
["Andrew Hall, 39 years, construction worker","worker",{"$f":"ExtractWord(A24, -1)","v":"worker"}]
["Abigail Bennett, 28 years, journalist","journalist",{"$f":"ExtractWord(A25, -1)","v":"journalist"}]
["David Adams, 44 years, real estate agent","agent",{"$f":"ExtractWord(A26, -1)","v":"agent"}]
["Harper Hall, 30 years, marketing manager","manager",{"$f":"ExtractWord(A27, -1)","v":"manager"}]

{"sheet":"Extract second word","index":3,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Extracting 2nd word from string"]
["String","2nd word from start","2nd word from end"]
["art. CH-1-1000-2000 / aluminum panel / 1000x2000x10 size",{"$f":"ExtractWord(A3, 2)","v":"CH-1-1000-2000"},{"$f":"ExtractWord(A3, -2)","v":"1000x2000x10"}]
["art. CH-2-1200-2200 / steel sheet / 1200x2200x12 size",{"$f":"ExtractWord(A4, 2)","v":"CH-2-1200-2200"},{"$f":"ExtractWord(A4, -2)","v":"1200x2200x12"}]
["art. CH-3-1400-2400 / copper plate / 1400x2400x14 size",{"$f":"ExtractWord(A5, 2)","v":"CH-3-1400-2400"},{"$f":"ExtractWord(A5, -2)","v":"1400x2400x14"}]
["art. CH-4-1600-2600 / brass sheet / 1600x2600x16 size",{"$f":"ExtractWord(A6, 2)","v":"CH-4-1600-2600"},{"$f":"ExtractWord(A6, -2)","v":"1600x2600x16"}]
["art. CH-5-1800-2800 / titanium panel / 1800x2800x18 size",{"$f":"ExtractWord(A7, 2)","v":"CH-5-1800-2800"},{"$f":"ExtractWord(A7, -2)","v":"1800x2800x18"}]
["art. CH-6-2000-3000 / zinc sheet / 2000x3000x20 size",{"$f":"ExtractWord(A8, 2)","v":"CH-6-2000-3000"},{"$f":"ExtractWord(A8, -2)","v":"2000x3000x20"}]
["art. CH-7-2200-3200 / stainless steel plate / 2200x3200x22 size",{"$f":"ExtractWord(A9, 2)","v":"CH-7-2200-3200"},{"$f":"ExtractWord(A9, -2)","v":"2200x3200x22"}]
["art. CH-8-2400-3400 / bronze sheet / 2400x3400x24 size",{"$f":"ExtractWord(A10, 2)","v":"CH-8-2400-3400"},{"$f":"ExtractWord(A10, -2)","v":"2400x3400x24"}]
["art. CH-9-2600-3600 / nickel panel / 2600x3600x26 size",{"$f":"ExtractWord(A11, 2)","v":"CH-9-2600-3600"},{"$f":"ExtractWord(A11, -2)","v":"2600x3600x26"}]
["art. CH-10-2800-3800 / aluminum alloy sheet / 2800x3800x28 size",{"$f":"ExtractWord(A12, 2)","v":"CH-10-2800-3800"},{"$f":"ExtractWord(A12, -2)","v":"2800x3800x28"}]
["art. CH-11-3000-4000 / copper alloy plate / 3000x4000x30 size",{"$f":"ExtractWord(A13, 2)","v":"CH-11-3000-4000"},{"$f":"ExtractWord(A13, -2)","v":"3000x4000x30"}]
["art. CH-12-3200-4200 / steel panel / 3200x4200x32 size",{"$f":"ExtractWord(A14, 2)","v":"CH-12-3200-4200"},{"$f":"ExtractWord(A14, -2)","v":"3200x4200x32"}]
["art. CH-13-3400-4400 / brass alloy sheet / 3400x4400x34 size",{"$f":"ExtractWord(A15, 2)","v":"CH-13-3400-4400"},{"$f":"ExtractWord(A15, -2)","v":"3400x4400x34"}]
["art. CH-14-3600-4600 / titanium alloy plate / 3600x4600x36 size",{"$f":"ExtractWord(A16, 2)","v":"CH-14-3600-4600"},{"$f":"ExtractWord(A16, -2)","v":"3600x4600x36"}]
["art. CH-15-3800-4800 / zinc alloy sheet / 3800x4800x38 size",{"$f":"ExtractWord(A17, 2)","v":"CH-15-3800-4800"},{"$f":"ExtractWord(A17, -2)","v":"3800x4800x38"}]
["art. CH-16-4000-5000 / stainless steel plate / 4000x5000x40 size",{"$f":"ExtractWord(A18, 2)","v":"CH-16-4000-5000"},{"$f":"ExtractWord(A18, -2)","v":"4000x5000x40"}]
["art. CH-17-4200-5200 / nickel alloy panel / 4200x5200x42 size",{"$f":"ExtractWord(A19, 2)","v":"CH-17-4200-5200"},{"$f":"ExtractWord(A19, -2)","v":"4200x5200x42"}]
["art. CH-18-4400-5400 / composite sheet / 4400x5400x44 size",{"$f":"ExtractWord(A20, 2)","v":"CH-18-4400-5400"},{"$f":"ExtractWord(A20, -2)","v":"4400x5400x44"}]
["art. CH-19-4600-5600 / bronze alloy sheet / 4600x5600x46 size",{"$f":"ExtractWord(A21, 2)","v":"CH-19-4600-5600"},{"$f":"ExtractWord(A21, -2)","v":"4600x5600x46"}]
["art. CH-20-4800-5800 / metal panel / 4800x5800x48 size",{"$f":"ExtractWord(A22, 2)","v":"CH-20-4800-5800"},{"$f":"ExtractWord(A22, -2)","v":"4800x5800x48"}]

{"sheet":"Extract Nth word","index":4,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Extracting Nth word in Excel"]
["String","Word_num","Native formula","ExtractWord"]
["4 apples 3 bananas 2 oranges and 1 cook",2,{"$f":"TRIM(MID(SUBSTITUTE(TRIM($A$3),\" \",REPT(\" \",LEN($A$3))), (B3-1)*LEN($A$3)+1, LEN($A$3)))","v":"apples"},{"$f":"ExtractWord($A$3, B3)","v":"apples"}]
[null,4,{"$f":"TRIM(MID(SUBSTITUTE(TRIM($A$3),\" \",REPT(\" \",LEN($A$3))), (B4-1)*LEN($A$3)+1, LEN($A$3)))","v":"bananas"},{"$f":"ExtractWord($A$3, B4)","v":"bananas"}]
[null,6,"oranges",{"$f":"ExtractWord($A$3, B5)","v":"oranges"}]
[null,9,"cook",{"$f":"ExtractWord($A$3, B6)","v":"cook"}]

{"sheet":"Custom delimiter","index":5,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Extracting word separated by specific delimiter"]
["String","2nd word with delimiter"]
["art. CH-1-1000-2000 / panel / 1000x2000x10 size",{"$f":"ExtractWord(A3, 2, \" / \")","v":"panel"}]
["art. CH-2-1200-2200 / steel sheet / 1200x2200x12 size",{"$f":"ExtractWord(A4, 2, \" / \")","v":"steel sheet"}]
["art. CH-3-1400-2400 / plate / 1400x2400x14 size",{"$f":"ExtractWord(A5, 2, \" / \")","v":"plate"}]
["art. CH-4-1600-2600 / brass sheet / 1600x2600x16 size",{"$f":"ExtractWord(A6, 2, \" / \")","v":"brass sheet"}]
["art. CH-5-1800-2800 / titanium panel / 1800x2800x18 size",{"$f":"ExtractWord(A7, 2, \" / \")","v":"titanium panel"}]
["art. CH-6-2000-3000 / zinc sheet / 2000x3000x20 size",{"$f":"ExtractWord(A8, 2, \" / \")","v":"zinc sheet"}]
["art. CH-7-2200-3200 / stainless steel plate / 2200x3200x22 size",{"$f":"ExtractWord(A9, 2, \" / \")","v":"stainless steel plate"}]
["art. CH-8-2400-3400 / bronze sheet / 2400x3400x24 size",{"$f":"ExtractWord(A10, 2, \" / \")","v":"bronze sheet"}]
["art. CH-9-2600-3600 / nickel panel / 2600x3600x26 size",{"$f":"ExtractWord(A11, 2, \" / \")","v":"nickel panel"}]
["art. CH-10-2800-3800 / aluminum alloy sheet / 2800x3800x28 size",{"$f":"ExtractWord(A12, 2, \" / \")","v":"aluminum alloy sheet"}]
["art. CH-11-3000-4000 / copper alloy plate / 3000x4000x30 size",{"$f":"ExtractWord(A13, 2, \" / \")","v":"copper alloy plate"}]
["art. CH-12-3200-4200 / steel panel / 3200x4200x32 size",{"$f":"ExtractWord(A14, 2, \" / \")","v":"steel panel"}]
["art. CH-13-3400-4400 / brass alloy sheet / 3400x4400x34 size",{"$f":"ExtractWord(A15, 2, \" / \")","v":"brass alloy sheet"}]
["art. CH-14-3600-4600 / titanium alloy plate / 3600x4600x36 size",{"$f":"ExtractWord(A16, 2, \" / \")","v":"titanium alloy plate"}]
["art. CH-15-3800-4800 / zinc alloy sheet / 3800x4800x38 size",{"$f":"ExtractWord(A17, 2, \" / \")","v":"zinc alloy sheet"}]
["art. CH-16-4000-5000 / stainless steel alloy plate / 4000x5000x40 size",{"$f":"ExtractWord(A18, 2, \" / \")","v":"stainless steel alloy plate"}]
["art. CH-17-4200-5200 / nickel alloy panel / 4200x5200x42 size",{"$f":"ExtractWord(A19, 2, \" / \")","v":"nickel alloy panel"}]
["art. CH-18-4400-5400 / composite sheet / 4400x5400x44 size",{"$f":"ExtractWord(A20, 2, \" / \")","v":"composite sheet"}]
["art. CH-19-4600-5600 / bronze alloy sheet / 4600x5600x46 size",{"$f":"ExtractWord(A21, 2, \" / \")","v":"bronze alloy sheet"}]
["art. CH-20-4800-5800 / metal panel / 4800x5800x48 size",{"$f":"ExtractWord(A22, 2, \" / \")","v":"metal panel"}]

{"sheet":"Get word containing character","index":6,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Extracting word containing specific character"]
["String","Char"]
["Subtotal Without Taxes: $2000.00 \nDiscount 10%: -$200.00 \nTax 5%: $90.00 \nAmount Due: $1890.00","$"]
[]
["Word number","Result"]
[1,{"$f":"ExtractWord($A$3, A6, , $B$3)","v":"$2000.00"}]
[2,{"$f":"ExtractWord($A$3, A7, , $B$3)","v":"-$200.00"}]
[3,{"$f":"ExtractWord($A$3, A8, , $B$3)","v":"$90.00"}]
[4,{"$f":"ExtractWord($A$3, A9, , $B$3)","v":"$1890.00"}]

{"sheet":"Get word containing text","index":7,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Extracting word containing specific text"]
["String","Word containing \"gmail\""]
["Reach out to support@gmail.com if you have any questions.",{"$f":"ExtractWord(A3, , , \"gmail\")","v":"support@gmail.com"}]
["You can contact our team at contact@company123.com for assistance.",{"$f":"ExtractWord(A4, , , \"gmail\")","v":""}]
["If any issues arise, contact us at help@customerservice.net",{"$f":"ExtractWord(A5, , , \"gmail\")","v":""}]
["For inquiries, reach us at info@yourbusiness.org. We're here to help.",{"$f":"ExtractWord(A6, , , \"gmail\")","v":""}]
["company@gmail.com is dedicated to providing exceptional service.",{"$f":"ExtractWord(A7, , , \"gmail\")","v":"company@gmail.com"}]
["Our customer support team is available at support@bestservice.com",{"$f":"ExtractWord(A8, , , \"gmail\")","v":""}]
["Feel free to drop us a line at help@topcompany.biz for any concerns.",{"$f":"ExtractWord(A9, , , \"gmail\")","v":""}]
["If you have any issues, don't hesitate to email me at engineer@gmail.com",{"$f":"ExtractWord(A10, , , \"gmail\")","v":"engineer@gmail.com"}]
["Contact our team via email at info@globalcorp.net for more information.",{"$f":"ExtractWord(A11, , , \"gmail\")","v":""}]
["For urgent matters, please contact us at help@quickassistance.org",{"$f":"ExtractWord(A12, , , \"gmail\")","v":""}]
["You can reach out to us at support@gmail.com for any inquiries.",{"$f":"ExtractWord(A13, , , \"gmail\")","v":"support@gmail.com"}]
["If you need assistance, send an email to info@newstartup.co",{"$f":"ExtractWord(A14, , , \"gmail\")","v":""}]
["Don't hesitate to contact us at help@company.biz with your questions.",{"$f":"ExtractWord(A15, , , \"gmail\")","v":""}]
["Reach out to our team at contact@expertservice.org for expert advice.",{"$f":"ExtractWord(A16, , , \"gmail\")","v":""}]
["For any concerns, please email us at sales@gmail.com",{"$f":"ExtractWord(A17, , , \"gmail\")","v":"sales@gmail.com"}]
["info@company123.com is your gateway to valuable information.",{"$f":"ExtractWord(A18, , , \"gmail\")","v":""}]
["Reach out to us at info@reliablecompany.com or info@gmail.com",{"$f":"ExtractWord(A19, , , \"gmail\")","v":"info@gmail.com"}]
["Our support team is available at best_support@gmail.com to assist you.",{"$f":"ExtractWord(A20, , , \"gmail\")","v":"best_support@gmail.com"}]
["For general inquiries, please email us at info@internationalco.com",{"$f":"ExtractWord(A21, , , \"gmail\")","v":""}]
["If you require assistance, contact us at help@topnotchsupport.biz",{"$f":"ExtractWord(A22, , , \"gmail\")","v":""}]

{"sheet":"Extract text after word","index":8,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Extracting text after word"]
["String","Text after \"Error code\""]
["Error code 400 (Bad Request)",{"$f":"ExtractWord(A3, 2, \"Error code\")","v":" 400 (Bad Request)"}]
["Enter the security code to proceed.",{"$f":"ExtractWord(A4, 2, \"Error code\")","v":""}]
["Enter the access code to unlock the content.",{"$f":"ExtractWord(A5, 2, \"Error code\")","v":""}]
["We apologize for the error.",{"$f":"ExtractWord(A6, 2, \"Error code\")","v":""}]
["Fixed: Error code 403 (Forbidden)",{"$f":"ExtractWord(A7, 2, \"Error code\")","v":" 403 (Forbidden)"}]
["Error code 504 (Gateway Timeout)",{"$f":"ExtractWord(A8, 2, \"Error code\")","v":" 504 (Gateway Timeout)"}]
["Addressed: Error code 401 (Unauthorized)",{"$f":"ExtractWord(A9, 2, \"Error code\")","v":" 401 (Unauthorized)"}]
["Please provide the activation code.",{"$f":"ExtractWord(A10, 2, \"Error code\")","v":""}]
["Resolved: Error code 500 (Internal Server Error)",{"$f":"ExtractWord(A11, 2, \"Error code\")","v":" 500 (Internal Server Error)"}]
["Use this discount code at checkout.",{"$f":"ExtractWord(A12, 2, \"Error code\")","v":""}]
["Error code 429 (Too Many Requests)",{"$f":"ExtractWord(A13, 2, \"Error code\")","v":" 429 (Too Many Requests)"}]
["Updated: Error code 404 (Not Found)",{"$f":"ExtractWord(A14, 2, \"Error code\")","v":" 404 (Not Found)"}]
["The error message is displayed.",{"$f":"ExtractWord(A15, 2, \"Error code\")","v":""}]
["Error code 503 (Service Unavailable)",{"$f":"ExtractWord(A16, 2, \"Error code\")","v":" 503 (Service Unavailable)"}]
["You'll receive a verification code.",{"$f":"ExtractWord(A17, 2, \"Error code\")","v":""}]
["Please fix the error in your input.",{"$f":"ExtractWord(A18, 2, \"Error code\")","v":""}]
["The system encountered an error.",{"$f":"ExtractWord(A19, 2, \"Error code\")","v":""}]
["An unexpected error occurred.",{"$f":"ExtractWord(A20, 2, \"Error code\")","v":""}]
["Error code 301 (Moved Permanently)",{"$f":"ExtractWord(A21, 2, \"Error code\")","v":" 301 (Moved Permanently)"}]
["Mitigated: Error code 502 (Bad Gateway)",{"$f":"ExtractWord(A22, 2, \"Error code\")","v":" 502 (Bad Gateway)"}]

{"sheet":"Split string in rows","index":9,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Splitting string into rows"]
["String",null,"Results"]
["art. CH-1-1000-2000 / aluminum panel / 1000x2000x10 size",null,{"$f":"ExtractWord($A$3, ROW(A1), \" / \")","v":"art. CH-1-1000-2000"}]
[null,null,{"$f":"ExtractWord($A$3, ROW(A2), \" / \")","v":"aluminum panel"}]
[null,null,{"$f":"ExtractWord($A$3, ROW(A3), \" / \")","v":"1000x2000x10 size"}]

{"sheet":"Split string in columns","index":10,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,0,6,2],[0,0,0,2],[1,0,1,2]]}
["Splitting string into columns"]
["String"]
["art. CH-1-1000-2000 / aluminum panel / 1000x2000x10 size"]
[]
[]
[]
["Results"]
[{"$f":"ExtractWord($A$3, COLUMN(A1), \" / \")","v":"art. CH-1-1000-2000"},{"$f":"ExtractWord($A$3, COLUMN(B1), \" / \")","v":"aluminum panel"},{"$f":"ExtractWord($A$3, COLUMN(C1), \" / \")","v":"1000x2000x10 size"}]

{"sheet":"Extract word from range","index":11,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Extracting word from range"]
["Range of cells",null,"Word number","Result"]
["Can anyone give me advice... ?",null,1,{"$f":"ExtractWord($A$3:$A$13, C3)","v":"Can"}]
["What to do with computer mice?",null,2,{"$f":"ExtractWord($A$3:$A$13, C4)","v":"anyone"}]
["At night they come out",null,16,{"$f":"ExtractWord($A$3:$A$13, C5)","v":"come"}]
["And race all about.",null,19,{"$f":"ExtractWord($A$3:$A$13, C6)","v":"race"}]
["Each mouse and it's spouse",null,20,{"$f":"ExtractWord($A$3:$A$13, C7)","v":"all"}]
["Invading my house.",null,30,{"$f":"ExtractWord($A$3:$A$13, C8)","v":"They"}]
["They wreck my office",null,40,{"$f":"ExtractWord($A$3:$A$13, C9)","v":"to"}]
["And they're not too nice.",null,-2,{"$f":"ExtractWord($A$3:$A$13, C10)","v":"computer"}]
["What to do with computer mice?",null,-1,{"$f":"ExtractWord($A$3:$A$13, C11)","v":"cat!"}]
["Wait, I hadn't thought about that -"]
["Perhaps, I'll get a computer cat!"]