By J.D.A.Wiseman of www.jdawiseman.com.
	In Excel, the author often uses unicode characters.
	Also, there is a script that parses formulae, seeking things that could be hidden #NAME! errors.
	Alas, VBA interacts imperfectly with unicode.
	So it helps if formulae are pure ASCII.
	Hence I prefer that unicode characters be range-name constants.
	And consistent naming helps with formula-sharing.
	
	Paste-as-special-text-only this file into an otherwise empty tab, named TextConstants.
	Select the left two columns, and create the range names, names at left.
	Then select in turn each of the six blocks, including their column names at top.
	For each create the range names, names at top.
	Each block will ask about replacing the one name that wrongly points to its right: accept each.
	The naming of the blocks allows formulae of the form Index(Chr_ccy.Char, Match("*_GBP", Chr_ccy.Name, 0)).

	Source files:
	www.jdawiseman.com/papers/trivia/Chr_definitions_for_Excel.txt
	www.jdawiseman.com/papers/trivia/characters-copy-paste.html


Chr_frac.Name	Chr_frac.Char		This row to be range names for columns below
Chr.frac_1_8	= UniChar(8539)  &  Rept("⅛",0)
Chr.frac_1_4	= UniChar(188)  &  Rept("¼",0)
Chr.frac_3_8	= UniChar(8540)  &  Rept("⅜",0)
Chr.frac_1_2	= UniChar(189)  &  Rept("½",0)
Chr.frac_5_8	= UniChar(8541)  &  Rept("⅝",0)
Chr.frac_3_4	= UniChar(190)  &  Rept("¾",0)
Chr.frac_7_8	= UniChar(8542)  &  Rept("⅞",0)

Chr_ccy.Name	Chr_ccy.Char		This row to be range names for columns below
Chr.ccy_USD	= UniChar(36)
Chr.ccy_GBP	= UniChar(163)  &  Rept("£",0)
Chr.ccy_EUR	= UniChar(8364)  &  Rept("€",0)
Chr.ccy_JPY	= UniChar(165)  &  Rept("¥",0)
Chr.ccy_CNY	= UniChar(20803)
Chr.ccy_KRW	= UniChar(8361)
Chr.ccy_RUB	= UniChar(8381)
Chr.ccy_TRY	= UniChar(8378)
Chr.ccy_INR	= UniChar(8377)
Chr.ccy_THB	= UniChar(3647)
Chr.ccy_ILS	= UniChar(8362)
Chr.ccy_NGN	= UniChar(8358)
Chr.ccy_VND	= UniChar(8363)
Chr.ccy_GHS	= UniChar(8373)
Chr.ccy_XBT	= UniChar(8383)
Chr.ccy_cent	= UniChar(162)  &  Rept("¢",0)
Chr.ccy_rupee	= UniChar(8360)
Chr.ccy_peso	= UniChar(8369)
Chr.ccy_generic	= UniChar(164)  &  Rept("¤",0)

Chr_sup.Name	Chr_sup.Char		This row to be range names for columns below
Chr.sup_0	= UniChar(8304)
Chr.sup_1	= UniChar(185)  &  Rept("¹",0)
Chr.sup_2	= UniChar(178)  &  Rept("²",0)
Chr.sup_3	= UniChar(179)  &  Rept("³",0)
Chr.sup_4	= UniChar(8308)
Chr.sup_5	= UniChar(8309)
Chr.sup_6	= UniChar(8310)
Chr.sup_7	= UniChar(8311)
Chr.sup_8	= UniChar(8312)
Chr.sup_9	= UniChar(8313)
Chr.sup_Plus	= UniChar(8314)
Chr.sup_Minus	= UniChar(8315)
Chr.sup_Divide	= UniChar(5151)  &  Rept("Actually 'Canadian Syllabics Final Acute'", 0)
Chr.sup_Equal	= UniChar(8316)
Chr.sup_LeftParen	= UniChar(8317)
Chr.sup_RightParen	= UniChar(8318)

Chr_sub.Name	Chr_sub.Char		This row to be range names for columns below
Chr.sub_0	= UniChar(8320)
Chr.sub_1	= UniChar(8321)
Chr.sub_2	= UniChar(8322)
Chr.sub_3	= UniChar(8323)
Chr.sub_4	= UniChar(8324)
Chr.sub_5	= UniChar(8325)
Chr.sub_6	= UniChar(8326)
Chr.sub_7	= UniChar(8327)
Chr.sub_8	= UniChar(8328)
Chr.sub_9	= UniChar(8329)

Chr_smallCap.Name	Chr_smallCap.Char		This row to be range names for columns below
Chr.smallCap_A	= UniChar(7424)
Chr.smallCap_B	= UniChar(665)
Chr.smallCap_C	= UniChar(7428)
Chr.smallCap_D	= UniChar(7429)
Chr.smallCap_E	= UniChar(7431)
Chr.smallCap_F	= UniChar(42800)  &  Rept("Often, an ill-fitting glyph is chosen", 0)
Chr.smallCap_G	= UniChar(610)
Chr.smallCap_H	= UniChar(668)
Chr.smallCap_I	= UniChar(618)
Chr.smallCap_J	= UniChar(7434)
Chr.smallCap_K	= UniChar(7435)
Chr.smallCap_L	= UniChar(671)
Chr.smallCap_M	= UniChar(7437)
Chr.smallCap_N	= UniChar(628)
Chr.smallCap_O	= UniChar(7439)
Chr.smallCap_P	= UniChar(7448)
Chr.smallCap_Q	= UniChar(42927)  &  Rept("Often missing", 0)
Chr.smallCap_R	= UniChar(640)
Chr.smallCap_S	= UniChar(42801)  &  Rept("Often, an ill-fitting glyph is chosen", 0)
Chr.smallCap_T	= UniChar(7451)
Chr.smallCap_U	= UniChar(7452)
Chr.smallCap_V	= UniChar(7456)
Chr.smallCap_W	= UniChar(7457)
Chr.smallCap_Y	= UniChar(655)
Chr.smallCap_Z	= UniChar(7458)
Chr.smallCap_Eth	= UniChar(7430)
Chr.smallCap_AE	= UniChar(7425)
Chr.smallCap_OE	= UniChar(630)

Chr_circled.Name	Chr_circled.Char		This row to be range names for columns below
Chr.circled__1	= UniChar(9312)
Chr.circled__2	= UniChar(9313)
Chr.circled__3	= UniChar(9314)
Chr.circled__4	= UniChar(9315)
Chr.circled__5	= UniChar(9316)
Chr.circled__6	= UniChar(9317)
Chr.circled__7	= UniChar(9318)
Chr.circled__8	= UniChar(9319)
Chr.circled__9	= UniChar(9320)
Chr.circled_10	= UniChar(9321)
Chr.circled_11	= UniChar(9322)
Chr.circled_12	= UniChar(9323)
Chr.circled_13	= UniChar(9324)
Chr.circled_14	= UniChar(9325)
Chr.circled_15	= UniChar(9326)
Chr.circled_16	= UniChar(9327)
Chr.circled_17	= UniChar(9328)
Chr.circled_18	= UniChar(9329)
Chr.circled_19	= UniChar(9330)
Chr.circled_20	= UniChar(9331)


Chr.greekUpper_Alpha	= UniChar(913)  &  Rept("Α",0)
Chr.greekUpper_Beta	= UniChar(914)  &  Rept("Β",0)
Chr.greekUpper_Gamma	= UniChar(915)  &  Rept("Γ",0)
Chr.greekUpper_Delta	= UniChar(916)  &  Rept("Δ",0)
Chr.greekUpper_Epsilon	= UniChar(917)  &  Rept("Ε",0)
Chr.greekUpper_Zeta	= UniChar(918)  &  Rept("Ζ",0)
Chr.greekUpper_Eta	= UniChar(919)  &  Rept("Η",0)
Chr.greekUpper_Theta	= UniChar(920)  &  Rept("Θ",0)
Chr.greekUpper_Iota	= UniChar(921)  &  Rept("Ι",0)
Chr.greekUpper_Kappa	= UniChar(922)  &  Rept("Κ",0)
Chr.greekUpper_Lambda	= UniChar(923)  &  Rept("Λ",0)
Chr.greekUpper_Mu	= UniChar(924)  &  Rept("Μ",0)
Chr.greekUpper_Nu	= UniChar(925)  &  Rept("Ν",0)
Chr.greekUpper_Xi	= UniChar(926)  &  Rept("Ξ",0)
Chr.greekUpper_Omicron	= UniChar(927)  &  Rept("Ο",0)
Chr.greekUpper_Pi	= UniChar(928)  &  Rept("Π",0)
Chr.greekUpper_Rho	= UniChar(929)  &  Rept("Ρ",0)
Chr.greekUpper_Sigma	= UniChar(931)  &  Rept("Σ",0)
Chr.greekUpper_Tau	= UniChar(932)  &  Rept("Τ",0)
Chr.greekUpper_Upsilon	= UniChar(933)  &  Rept("Υ",0)
Chr.greekUpper_Phi	= UniChar(934)  &  Rept("Φ",0)
Chr.greekUpper_Chi	= UniChar(935)  &  Rept("Χ",0)
Chr.greekUpper_Psi	= UniChar(936)  &  Rept("Ψ",0)
Chr.greekUpper_Omega	= UniChar(937)  &  Rept("Ω",0)

Chr.greekLower_alpha	= UniChar(945)  &  Rept("α",0)
Chr.greekLower_beta	= UniChar(946)  &  Rept("β",0)
Chr.greekLower_gamma	= UniChar(947)  &  Rept("γ",0)
Chr.greekLower_delta	= UniChar(948)  &  Rept("δ",0)
Chr.greekLower_epsilon	= UniChar(949)  &  Rept("ε",0)
Chr.greekLower_zeta	= UniChar(950)  &  Rept("ζ",0)
Chr.greekLower_eta	= UniChar(951)  &  Rept("η",0)
Chr.greekLower_theta	= UniChar(952)  &  Rept("θ",0)
Chr.greekLower_iota	= UniChar(953)  &  Rept("ι",0)
Chr.greekLower_kappa	= UniChar(954)  &  Rept("κ",0)
Chr.greekLower_lambda	= UniChar(955)  &  Rept("λ",0)
Chr.greekLower_mu	= UniChar(956)  &  Rept("μ",0)
Chr.greekLower_nu	= UniChar(957)  &  Rept("ν",0)
Chr.greekLower_xi	= UniChar(958)  &  Rept("ξ",0)
Chr.greekLower_omicron	= UniChar(959)  &  Rept("ο",0)
Chr.greekLower_pi	= UniChar(960)  &  Rept("π",0)
Chr.greekLower_rho	= UniChar(961)  &  Rept("ρ",0)
Chr.greekLower_sigma	= UniChar(963)  &  Rept("σ",0)
Chr.greekLower_tau	= UniChar(964)  &  Rept("τ",0)
Chr.greekLower_upsilon	= UniChar(965)  &  Rept("υ",0)
Chr.greekLower_phi	= UniChar(966)  &  Rept("φ",0)
Chr.greekLower_chi	= UniChar(967)  &  Rept("χ",0)
Chr.greekLower_psi	= UniChar(968)  &  Rept("ψ",0)
Chr.greekLower_omega	= UniChar(969)  &  Rept("ω",0)


Chr.Multiply	= UniChar(215)  &  Rept("×",0)
Chr.Divide	= UniChar(247)  &  Rept("÷",0)
Chr.Minus	= UniChar(8722)  &  Rept("−",0)
Chr.Sum	= UniChar(8721)  &  Rept("∑",0)
Chr.Product	= UniChar(8719)  &  Rept("∏",0)
Chr.Infinity	= UniChar(8734)  &  Rept("∞",0)
Chr.Not	= UniChar(172)  &  Rept("¬",0)
Chr.QED	= UniChar(8718)
Chr.PlusMinus	= UniChar(177)  &  Rept("±",0)
Chr.MinusPlus	= UniChar(8723)  &  Rept("∓",0)
Chr.Equals	= UniChar(61)  &  Rept("=",0)
Chr.EqNot	= UniChar(8800)  &  Rept("≠",0)
Chr.EqLT	= UniChar(8804)  &  Rept("≤",0)
Chr.EqGT	= UniChar(8805)  &  Rept("≥",0)
Chr.Equivalent	= UniChar(8781)  &  Rept("≍",0)
Chr.EqIdentical	= UniChar(8801)  &  Rept("≡",0)
Chr.Proportional	= UniChar(8733)  &  Rept("∝",0)
Chr.EqApprox	= UniChar(8776)  &  Rept("≈",0)
Chr.EqApproxLT	= UniChar(10885)  &  Rept("⪅",0)
Chr.EqApproxGT	= UniChar(10886)  &  Rept("⪆",0)
Chr.LLT	= UniChar(8810)  &  Rept("≪",0)
Chr.GGT	= UniChar(8811)  &  Rept("≫",0)
Chr.LLLT	= UniChar(8920)  &  Rept("&lll;",0)
Chr.GGGT	= UniChar(8921)  &  Rept("⋙",0)

Chr.DashFigure	= UniChar(8210)
Chr.DashEn	= UniChar(8211)  &  Rept("–",0)
Chr.DashEm	= UniChar(8212)  &  Rept("—",0)
Chr.Dash2Em	= UniChar(11834)  &  Rept("&;",0)
Chr.Dash3Em	= UniChar(11835)  &  Rept("&;",0)
Chr.HyphenNonBreak	= UniChar(8209)

Chr.SpNonBr	= UniChar(160)  &  Rept(" ",0)
Chr.SpNarrowNonBr	= UniChar(8239)  &  Rept("&;",0)
Chr.SpEmQuad	= UniChar(8193)
Chr.SpEm	= UniChar(8195)  &  Rept(" ",0)
Chr.SpFigure	= UniChar(8199)  &  Rept(" ",0)
Chr.SpThin	= UniChar(8201)  &  Rept(" ",0)
Chr.SpHair	= UniChar(8202)  &  Rept(" ",0)
Chr.SpZeroWidth	= UniChar(8203)  &  Rept("​",0)

Chr.lsquo	= UniChar(8216)  &  Rept("‘",0)
Chr.rsquo	= UniChar(8217)  &  Rept("’",0)
Chr.ldquo	= UniChar(8220)  &  Rept("“",0)
Chr.rdquo	= UniChar(8221)  &  Rept("”",0)
Chr.PrimeSingle	= UniChar(8242)  &  Rept("′",0)
Chr.PrimeDouble	= UniChar(8243)  &  Rept("″",0)
Chr.PrimeTriple	= UniChar(8244)  &  Rept("‴",0)
Chr.Ellipsis	= UniChar(8230)  &  Rept("…",0)
Chr.Pilcrow	= UniChar(182)  &  Rept("¶",0)
Chr.Section	= UniChar(167)  &  Rept("§",0)

Chr.MidDot	= UniChar(183)  &  Rept("·",0)
Chr.Bullet	= UniChar(8226)  &  Rept("•",0)
Chr.Lozenge	= UniChar(9674)  &  Rept("◊",0)
Chr.LozengeBlack	= UniChar(10731)  &  Rept("⧫",0)
Chr.LozengeSquare	= UniChar(8977)

Chr.ArrowRightSingle	= UniChar(8594)  &  Rept("→",0)
Chr.ArrowRightTriangle	= UniChar(10141)
Chr.ArrowRightDouble	= UniChar(8658)  &  Rept("⇒",0)
Chr.ArrowRightDoubleLong	= UniChar(10233)  &  Rept("⟹",0)
Chr.ArrowRightHalfWidth	= UniChar(65515)
Chr.ArrowLeftSingle	= UniChar(8592)  &  Rept("←",0)
Chr.ArrowLeftDouble	= UniChar(8656)  &  Rept("⇐",0)
Chr.ArrowLeftDoubleLong	= UniChar(10232)  &  Rept("⟸",0)
Chr.ArrowLeftHalfWidth	= UniChar(65513)
Chr.ArrowUpSingle	= UniChar(8593)  &  Rept("↑",0)
Chr.ArrowUpDouble	= UniChar(8657)  &  Rept("⇑",0)
Chr.ArrowUpHalfWidth	= UniChar(65514)
Chr.ArrowDownSingle	= UniChar(8595)  &  Rept("↓",0)
Chr.ArrowDownDouble	= UniChar(8659)  &  Rept("⇓",0)
Chr.ArrowDownHalfWidth	= UniChar(65516)

Chr.CheckHeavy	= UniChar(10004)
Chr.BallotHeavyX	= UniChar(10008)
Chr.ExclamationHeavy	= UniChar(10082)
Chr.HeartBlackHeavy	= UniChar(10084)

Chr.LeafNorthEast	= UniChar(128594)  &  Rept("Sometimes missing", 0)



Str.Eighths	= Rept("%" & Chr.frac_1_8 & Chr.frac_1_4 & Chr.frac_3_8 & Chr.frac_1_2 & Chr.frac_5_8 & Chr.frac_3_4 & Chr.frac_7_8, 2)
Str.EighthsUK	= Rept("%EQRHFTS", 2)
Str.FuturesMonths	= Rept("FGHJKMNQUVXZ", 2)

Str.rate_SOFR	= ("S" & Chr.smallCap_O & Chr.smallCap_F & Chr.smallCap_R)  &  Rept("USD-denominated Secured Overnight Financing Rate",0)
Str.rate_ESTR	= (Chr.ccy_EUR & Chr.smallCap_S & Chr.smallCap_T & Chr.smallCap_R)  &  Rept("Euro Short-Term Rate",0)
Str.rate_SONIA	= ("S" & Chr.smallCap_O & Chr.smallCap_N & Chr.smallCap_I & Chr.smallCap_A)  &  Rept("Sterling Over-Night Index Average",0)
Str.rate_TONAR	= ("T" & Chr.smallCap_O & Chr.smallCap_N & Chr.smallCap_A & Chr.smallCap_R)  &  Rept("Tokyo Over-Night Average Rate",0)
Str.rate_SARON	= ("S" & Chr.smallCap_A & Chr.smallCap_R & Chr.smallCap_O & Chr.smallCap_N)  &  Rept("Swiss Average Rate Over-Night",0)
Str.rate_CORRA	= ("C" & Chr.smallCap_O & Chr.smallCap_R & Chr.smallCap_R & Chr.smallCap_A)  &  Rept("Canadian Overnight Repo Rate Average",0)
Str.rate_STINA	= ("S" & Chr.smallCap_T & Chr.smallCap_I & Chr.smallCap_N & Chr.smallCap_A)  &  Rept("Stockholm Tomorrow-Next Interbank Average",0)
Str.rate_JIBAR	= ("J" & Chr.smallCap_I & Chr.smallCap_B & Chr.smallCap_A & Chr.smallCap_R)  &  Rept("Johannesburg Inter-Bank Average Rate",0)
Str.rate_SORA	= ("S" & Chr.smallCap_O & Chr.smallCap_R & Chr.smallCap_A)  &  Rept("Singapore Overnight Rate Average",0)
Str.rate_TIIE	= ("T" & Chr.smallCap_I & Chr.smallCap_I & Chr.smallCap_E)  &  Rept("MXN-denominated Tasa de Inter" & UniChar(233) & "s Interbancaria de Equilibrio",0)
Str.rate_LIBOR	= ("L" & Chr.smallCap_I & Chr.smallCap_B & Chr.smallCap_O & Chr.smallCap_R)  &  Rept("London Inter-Bank Offered Rate",0)

Str.GreenBondSuffix	= Chr.LeafNorthEast

Str.NaN	= Chr.smallCap_N & "a" & Chr.smallCap_N
Str.NaS	= Chr.MidDot
Str.Error	= Chr.ExclamationHeavy & Chr.BallotHeavyX & " Error " & Chr.BallotHeavyX & Chr.ExclamationHeavy