{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["filterHTML","Output","_prefs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":115,"comments":1,"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":"filterHTML","index":0,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Since neither bro"]
[{"$f":"G2:J2","v":"Super"},"Normal","Super","Subscripted",null,null,"Super","Normal","Super","Subscripted",null,{"$f":"IF(_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(M2))),\"\")","v":""},{"$f":"_xlfn.BYROW(range(G2),_xlfn.LAMBDA(_xlpm.a,_xlfn.TEXTJOIN(\"\",,\"<sup>\"&INDEX(_xlpm.a,,1)&\"</sup>\",INDEX(_xlpm.a,,2),\"<sup>\"&INDEX(_xlpm.a,,3)&\"</sup>\",\"<sub>\"&INDEX(_xlpm.a,,4)&\"</sub>\")))","v":"<sup>Super</sup>Normal<sup>Super</sup><sub>Subscripted</sub>"},null,{"$f":"IF(_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(M2))),\"\")","v":""}]
[":question_mark:4:right_raised_omission_bracket:24:bed:","SOME",":heavy_dollar_sign:549;:fork_and_knife_with_plate::heavy_multiplication_x::question_mark::receipt::heavy_dollar_sign:43;",":heavy_dollar_sign:394:fork_and_knife_with_plate::heavy_multiplication_x::question_mark:",null,{"$f":"IF(_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(G3))),\"\")","v":""},{"$f":"_xlfn.LET(_xlpm.a,range(A3),_xlfn.MAKEARRAY(ROWS(_xlpm.a),COLUMNS(_xlpm.a),_xlfn.LAMBDA(_xlpm.r,_xlpm.c,replaceWords(INDEX(_xlpm.a,_xlpm.r,_xlpm.c),Table1[Name in text],Table1[HTML]))))","v":":&#65311;:4:&#11789;:24:&#128719;:"},"SOME",":&#128178;:549;:&#127860;_with_plate::&#10006;::&#65311;::&#129534;::&#128178;:43;",":&#128178;:394:&#127860;_with_plate::&#10006;::&#65311;:",null,"","<sup>:&#65311;:4:&#11789;:24:&#128719;:</sup>SOME<sup>:&#128178;:549;:&#127860;_with_plate::&#10006;::&#65311;::&#129534;::&#128178;:43;</sup><sub>:&#128178;:394:&#127860;_with_plate::&#10006;::&#65311;:</sub>",null,""]
["Up","Normal","Up","Down",null,"","Up","Normal","Up","Down",null,"","<sup>Up</sup>Normal<sup>Up</sup><sub>Down</sub>",null,""]

{"sheet":"Output","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Output"]
[]
[null,"¬ That cell is named htmlTarget"]

{"sheet":"_prefs","index":2,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Preferences",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"{\"30 jul 2023\";\"https//techcommunity.microsoft.com/t5/excel/lookup-to-include-formatting-with-its-return-value-non-vba/m-p/3883049#M199322\";\"bo.sinander@powerpage.se\";\"https://www.codetable.net/decimal/65025\"}","v":"30 jul 2023"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https//techcommunity.microsoft.com/t5/excel/lookup-to-include-formatting-with-its-return-value-non-vba/m-p/3883049#M199322"]
["Replacements",null,null,null,null,null,null,"Misc remains - can be deleted",null,null,null,null,null,null,"bo.sinander@powerpage.se"]
["Name in text","Hex Code","Unichar","HTML",null,null,null,null,"Identify special chars in string",null,null,null,null,null,"https://www.codetable.net/decimal/65025"]
["airplane","1F6E7",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"🛧"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#128743;"},null,null,null,null,"plate:️:heavy"]
["airplane → ",2708,{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"✈"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#9992;"},null,null,null,{"$f":"_xlfn.FORMULATEXT(I6:I7)","v":"=unicodes(I5)"},{"$f":"unicodes(I5)","v":"p = U+70 | l = U+6C | a = U+61 | t = U+74 | e = U+65 | : = U+3A | ️ = U+FE0F | : = U+3A | h = U+68 | e = U+65 | a = U+61 | v = U+76 | y = U+79"}]
["bed","1F6CF",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"🛏"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#128719;"},null,null,null,"=unicodes(I5;256)",{"$f":"unicodes(I5,256)","v":"️ = U+FE0F"}]
["bed","u+1f6cf",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"🛏"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#128719;"}]
["document","1f5ce",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"🗎"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#128462;"},null,null,null,null,"LAMBDA: unicodes"]
["fork_and_knife","U+1F374",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"🍴"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#127860;"},null,null,null,null,{"$f":"_xlfn.LAMBDA(_xlpm.string,_xlop.min_unicode,\n\n_xlfn.LET(_xlpm.params, MAX(1,\n                    2*NOT(_xlfn.ISOMITTED(_xlpm.min_unicode)) ),\n_xlpm.minUnicode,IF(_xlpm.params=1,0,_xlpm.min_unicode),\n_xlpm.seq,_xlfn.SEQUENCE(LEN(_xlpm.string)),\n_xlpm.char,MID(_xlpm.string,_xlpm.seq,1),\n_xlpm.number,_xlfn.UNICODE(_xlpm.char),\n_xlpm.result,IFERROR(\n  IF(_xlpm.number<_xlpm.minUnicode,\n    \"\",\n    _xlpm.char & \" = U+\"&DEC2HEX(_xlpm.number)),\n  \"(#N/A Unichar)\"),\n_xlpm.output,_xlfn.TEXTJOIN(\" | \",,_xlpm.result),\n_xlpm.output\n)\n\n)(I5,256)","v":"️ = U+FE0F"}]
["fork_and_knife_with_plate","1f37d",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"🍽"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#127869;"}]
["heavy_dollar_sign","1f4b2",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"💲"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#128178;"},null,null,null,null,"LAMBDA: replaceWords"]
["heavy_multiplication_x",2716,{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"✖"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#10006;"},null,null,null,null,{"$f":"_xlfn.LAMBDA(_xlpm.text,_xlpm.oldText,_xlpm.newText,\n  IF(ROWS(_xlpm.oldText)=1,_xlpm.text,\n    replaceWords(\n      SUBSTITUTE(_xlpm.text,INDEX(_xlpm.oldText,1),INDEX(_xlpm.newText,1)),\n      _xlfn.DROP(_xlpm.oldText,1),\n      _xlfn.DROP(_xlpm.newText,1)\n    )\n  )\n)(filterHTML!A3:D3,Table1[Name in text],Table1[HTML])","v":":&#65311;:4:&#11789;:24:&#128719;:"},"SOME",":&#128178;:549;:&#127860;_with_plate::&#10006;::&#65311;::&#129534;::&#128178;:43;",":&#128178;:394:&#127860;_with_plate::&#10006;::&#65311;:"]
["horse","1f40e",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"🐎"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#128014;"}]
["question_mark","ff1f",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"？"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#65311;"},null,null,null,null,"SCAN as an alternative calculation method"]
["receipt","1F9FE",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"🧾"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#129534;"},null,null,null,null,{"$f":"_xlfn.TAKE(\n_xlfn.SCAN(filterHTML!A3,_xlfn.SEQUENCE(ROWS(Table1[#Data])),\n  _xlfn.LAMBDA(_xlpm.a,_xlpm.b,\n    SUBSTITUTE(_xlpm.a,\":\" & INDEX(Table1[Name in text],_xlpm.b) & \":\",INDEX(Table1[Unichar],_xlpm.b))\n  )\n),-1)","v":"？4⸍24🛏"}]
["right_raised_omission_bracket","2E0D",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"⸍"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#11789;"}]
["variation_selector-16","fe0f",{"$f":"_xlfn.UNICHAR(HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")))","v":"️"},{"$f":"\"&#\" & HEX2DEC(SUBSTITUTE(UPPER(Table1[[#This Row],[Hex Code]]),\"U+\",\"\")) & \";\"","v":"&#65039;"}]
[]
[]
[null,null,null,null,null,null,null,"Get unicodes - help when unichar is known"]
[null,null,null,null,null,null,null,null,"Copy and paste as value in Table1"]
[null,null,null,null,null,null,null,"Unichar","DEC2HEX"]
[null,null,null,null,null,null,null,"⸍",{"$f":"DEC2HEX(_xlfn.UNICODE(Table2[[#This Row],[Unichar]]))","v":"2E0D"}]
[null,null,null,null,null,null,null,"🧾",{"$f":"DEC2HEX(_xlfn.UNICODE(Table2[[#This Row],[Unichar]]))","v":"1F9FE"}]
[null,null,null,null,null,null,null,"🛧",{"$f":"DEC2HEX(_xlfn.UNICODE(Table2[[#This Row],[Unichar]]))","v":"1F6E7"}]