ATEXTSPLIT

[Xlambda]

ATEXTSPLIT array text split by any delimiter,(one or more chars), fine-tuned for complex scenarios.
Wrote this function inspired by MrExcel video: Excel TEXTJOIN And The Need For TEXTSPLIT with Ann K. Emery - 2407
The idea was to create a function that is clean and robust, does not call other functions, non-recursive, no FILTERXML, and uses same arguments as TEXTJOIN. What TEXTJOIN joins, ATEXTSPLIT should be able to split it back like it was, with same arguments. When we join, we choose the delimiter, but when we split imported data, things can go quite tricky.
ar: array 1D vertical, dl: delimiter, any string , ea: empty argument , 0 or omitted - ignores empty ; 1 - does not ignore empty
Note: There are 2 special characters in the formula, (h,"º",d,"ª"), first variables after "LET" . These should be changed if any of them is found on the array of strings. Formula advises if this happens.

=LAMBDA(ar,dl,ea,
    LET(h,"º",d,"ª",ch,ISNUMBER(SEARCH(CHOOSE({1,2},h,d),ar)),
       a,SUBSTITUTE(ar,dl,d),b,IF(ea,a,SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(a," ",h),d," "))," ",d),h," ")),
       n,LEN(b)-LEN(SUBSTITUTE(b,d,""))+1,c,MAX(n),sc,SEQUENCE(,c),
       x,SEARCH(h,SUBSTITUTE(d&b,d,h,sc)),y,SEARCH(h,SUBSTITUTE(b&d,d,h,sc)),m,IFERROR(MID(b,x,y-x),""),
       IF(OR(ch),"change special chars",IFERROR(--m,m))
    )
)

LAMBDA 7.0.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
1						TEXTJOIN		ATEXTSPLIT
2								empty ignored						empty not ignored						2 chars				empty ignored
3						empty not ignored		ea arg.=0						ea arg.=1						delimiter				ea arg.=0
4	sample					=TEXTJOIN(",",0,A5:D5)		=ATEXTSPLIT(F5:F7,",",)						=ATEXTSPLIT(F5:F7,",",1)										=ATEXTSPLIT(T5:T7,"><",)					LEN check
5	a	4		c		a,4,,c		a	4	c				a	4		c			a><6.8><t				a	6.8	t			1	3	1
6	d			0.5		d,,,0.5		d	0.5					d			0.5			><2.4 w><				2.4 w					6	0	0
7	g h	i 2	k l	3 n		g h,i 2,k l,3 n		g h	i 2	k l	3 n			g h	i 2	k l	3 n			<Ac4><gh>< ><				<Ac4	gh				4	2	1
8																															space
9						empty ignored		ea arg.=0						ea arg.=1										empty not ignored
10						=TEXTJOIN(",",,A5:D5)		=ATEXTSPLIT(F11:F13,",",)						=ATEXTSPLIT(F11:F13,",",1)										ea arg.=1
11						a,4,c		a	4	c				a	4	c								=ATEXTSPLIT(T5:T7,"><",1)					LEN check
12						d,0.5		d	0.5					d	0.5									a	6.8	t			1	3	1	0
13						g h,i 2,k l,3 n		g h	i 2	k l	3 n			g h	i 2	k l	3 n								2.4 w				0	6	0	0
14																								<Ac4	gh				4	2	1	0
15						Complex scenario																							space followed by an empty string
16								empty ignored						empty not ignored
17								ea arg.=0						ea arg.=1										error debug.
18						sample		=ATEXTSPLIT(F19:F22,",",)						=ATEXTSPLIT(F19:F22,",",1)												=ATEXTSPLIT(X19,",",)
19						a,b,c,2.3,,d e,		a	b	c	2.3	d e		a	b	c	2.3		d e					a,ºb,c		change special chars
20						,,g,,h, ,1.8		g	h		1.8					g		h		1.8						=ATEXTSPLIT(X21,",",1)
21						, k m, ,4.9, ,p		k m		4.9		p			k m		4.9		p					a,ªb,c		change special chars
22						, ,,x 4, ,,			x 4								x 4
23
24	Important Obs.: -two delimiters next to each other ( ,, ) , hold an empty string between them that can be ignored or not depending of "ea" argument
25	-two delimiters sep by space ( , , ) , hold a space between them, and can not be ignored, no matter of "ea" argument
26	We can check this behaviour with LEN function. (same rule applies for leading or trailing delimiters)
27
28								=LEN(H19#)						=LEN(N19#)
29								1	1	1	3	3		1	1	1	3	0	3	0
30								1	1	1	3	0		0	0	1	0	1	1	3
31								4	1	3	1	1		0	4	1	3	1	1	0
32								1	5	1	0	0		0	1	0	5	1	0	0
33
34	- if values themselves embed inner spaces, could be important to keep them (like special codes with fixed length that follow a pattern),TRIM tweaks can not be used
35
36	ex. code pattern					sample		=ATEXTSPLIT(F37:F38,"/",)						=LEN(H37#)
37	fixed with 4 pos.					a bc/a b/ bcd		a bc	a b	bcd				4	4	4
38	/_	_	_	_ /		ab d/ d/a		ab d	d	a				4	4	4
39	/x	x	x	x/										check:pattern is kept
40
ATEXTSPLIT post

Cell Formulas
Range	Formula
H4,N36,H36,N28,H28,Z18,Z20,N18,H18,F10,X11,N10,H10,F4,X4,N4	H4	=FORMULATEXT(H5)
H5:K7,H11:K13	H5	=ATEXTSPLIT(F5:F7,",",)
N5:Q7,N11:Q13	N5	=ATEXTSPLIT(F5:F7,",",1)
X5:Z7	X5	=ATEXTSPLIT(T5:T7,"><",)
AC5:AE7,AC12:AF14	AC5	=LEN(X5#)
F5:F7	F5	=TEXTJOIN(",",0,A5:D5)
X12:AA14	X12	=ATEXTSPLIT(T5:T7,"><",1)
F11:F13	F11	=TEXTJOIN(",",,A5:D5)
H19:L22	H19	=ATEXTSPLIT(F19:F22,",",)
N19:T22	N19	=ATEXTSPLIT(F19:F22,",",1)
Z19	Z19	=ATEXTSPLIT(X19,",",)
Z21	Z21	=ATEXTSPLIT(X21,",",1)
H29:L32,N29:T32	H29	=LEN(H19#)
H37:J38	H37	=ATEXTSPLIT(F37:F38,"/",)
N37:P38	N37	=LEN(H37#)
Dynamic array formulas.

 

[Xlambda]

Leading 0's, trailing 0's, leading and trailing 0's with a separator.
This one is inspired by Leila's today's YT shorts:

text-and-values.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1				leading 0's
2				=TEXT(B3:B7,REPT(0,MAX(LEN(B3:B7))))				or	=LET(a,B3:B7,REPLACE(a,1,,REPT(0,MAX(LEN(a))-LEN(a))))
3		1		000001					000001
4		123456		123456					123456
5				000000					000000
6		123		000123					000123
7		12		000012					000012
8
9				trailing 0's
10				=LET(a,B11:B15,l,LEN(a),REPLACE(a,l+1,,REPT(0,MAX(l)-l)))
11		1		100000
12		123456		123456
13				000000
14		123		123000
15		12		120000
16
17					leading and trailing 0's
18
19		1|1			000001|100000
20		123|1			000123|100000
21		12|1234			000012|123400
22		123456|123456			123456|123456
23					000000|000000
24		|123			000000|123000
25		1234|			001234|000000
26		12|12			000012|120000
27
28		E19:
29		=LET( a,B18:B25, t,ATEXTSPILL(a,LAMBDA(x,TEXTSPLIT(x,"|"))), aa,INDEX(t,,1),ab,INDEX(t,,2), ac,IF(aa="",0,aa),ad,IF(ab="",0,ab), x,TEXT(ac,REPT(0,MAX(LEN(ac)))), l,LEN(ad), y,REPLACE(ad,l+1,,REPT(0,MAX(l)-l)), x&"|"&y )
30
31
32
33
34
35
36
37
38
39
40
leila leading 0

Cell Formulas
Range	Formula
D2,D10,I2	D2	=FORMULATEXT(D3)
D3:D7	D3	=TEXT(B3:B7,REPT(0,MAX(LEN(B3:B7))))
I3:I7	I3	=LET(a,B3:B7,REPLACE(a,1,,REPT(0,MAX(LEN(a))-LEN(a))))
D11:D15	D11	=LET(a,B11:B15,l,LEN(a),REPLACE(a,l+1,,REPT(0,MAX(l)-l)))
E19:E26	E19	=LET(a,B19:B26,t,ATEXTSPILL(a,LAMBDA(x,TEXTSPLIT(x,"|"))),aa,INDEX(t,,1),ab,INDEX(t,,2),ac,IF(aa="",0,aa),ad,IF(ab="",0,ab),x,TEXT(ac,REPT(0,MAX(LEN(ac)))),l,LEN(ad),y,REPLACE(ad,l+1,,REPT(0,MAX(l)-l)),x&"|"&y)
Dynamic array formulas.

 

[Xlambda]

It's Sunday, some fun with modular lambda "programming" (when a structure of lambdas is assembled/called by a final lambda).
Inspired by today's home page article: Spell Out Numbers in Excel
Module functions DE, SH, SN (Digits in English, Spell Hundreds, Spell Numbers)
Final function SPELLNR
SPELLNR can handle any 2D arrays, positive or negative numbers with decimals or not (2 decimals approximation), ignoring text, blanks, and numbers that in absolute value are bigger than 1 quadrillion.
DE() Digits in English, argument free or lambda constants function, can be also a defined name

=LAMBDA(
    {
        0, 10, "", "", "ten";
        1, 11, "one", "", "eleven";
        2, 12, "two", "twenty", "twelve";
        3, 13, "three", "thirty", "thirteen";
        4, 14, "four", "forty", "fourteen";
        5, 15, "five", "fifty", "fifteen";
        6, 16, "six", "sixty", "sixteen";
        7, 17, "seven", "seventy", "seventeen";
        8, 18, "eight", "eighty", "eighteen";
        9, 19, "nine", "ninety", "nineteen"
    }
)

spell numbers.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2		=DE()
3		0	10			ten
4		1	11	one		eleven
5		2	12	two	twenty	twelve
6		3	13	three	thirty	thirteen
7		4	14	four	forty	fourteen
8		5	15	five	fifty	fifteen
9		6	16	six	sixty	sixteen
10		7	17	seven	seventy	seventeen
11		8	18	eight	eighty	eighteen
12		9	19	nine	ninety	nineteen
13
14		Note: If we want spelling in other language only this we have to change with the correspondent translations.
15
SPELLNR 1

Cell Formulas
Range	Formula
B2	B2	=FORMULATEXT(B3)
B3:F12	B3	=DE()
Dynamic array formulas.

 

[Xlambda]

SH(a) Spell Hundreds, spells any positive integer that has max 3 digits. Calls DE()
a: any array of max 3 digits positive integers

=LAMBDA(a,
    LET(
        s, " ",
        h, "hundred",
        t, TEXT(a, "000"),
        l, VLOOKUP(--LEFT(t, 1), DE(), 3, 0),
        ra, IFNA(VLOOKUP(--RIGHT(t, 2), DROP(DE(), , 1), 4, 0), ""),
        rb, VLOOKUP(--MID(t, 2, 1), DE(), 4, 0),
        r, VLOOKUP(--RIGHT(t, 1), DE(), 3, 0),
        TRIM(IF(l = "", "", l & s & h) & s & IF(ra = "", rb & s & r, ra))
    )
)

spell numbers.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1		a			a			a			a
2		=SEQUENCE(50)-1			=SEQUENCE(50,,50)			=SEQUENCE(50,,100)			=SEQUENCE(50,,950)
3		↓↓	=SH(B4#)		↓↓	=SH(E4#)		↓↓	=SH(H4#)		↓↓	=SH(K4#)
4		0			50	fifty		100	one hundred		950	nine hundred fifty
5		1	one		51	fifty one		101	one hundred one		951	nine hundred fifty one		a
6		2	two		52	fifty two		102	one hundred two		952	nine hundred fifty two		2	17
7		3	three		53	fifty three		103	one hundred three		953	nine hundred fifty three		777	901
8		4	four		54	fifty four		104	one hundred four		954	nine hundred fifty four
9		5	five		55	fifty five		105	one hundred five		955	nine hundred fifty five		=SH(N6:O7)
10		6	six		56	fifty six		106	one hundred six		956	nine hundred fifty six		two	seventeen
11		7	seven		57	fifty seven		107	one hundred seven		957	nine hundred fifty seven		seven hundred seventy seven	nine hundred one
12		8	eight		58	fifty eight		108	one hundred eight		958	nine hundred fifty eight
13		9	nine		59	fifty nine		109	one hundred nine		959	nine hundred fifty nine
14		10	ten		60	sixty		110	one hundred ten		960	nine hundred sixty
15		11	eleven		61	sixty one		111	one hundred eleven		961	nine hundred sixty one
16		12	twelve		62	sixty two		112	one hundred twelve		962	nine hundred sixty two
17		13	thirteen		63	sixty three		113	one hundred thirteen		963	nine hundred sixty three
18		14	fourteen		64	sixty four		114	one hundred fourteen		964	nine hundred sixty four
19		15	fifteen		65	sixty five		115	one hundred fifteen		965	nine hundred sixty five
20		16	sixteen		66	sixty six		116	one hundred sixteen		966	nine hundred sixty six
21		17	seventeen		67	sixty seven		117	one hundred seventeen		967	nine hundred sixty seven
22		18	eighteen		68	sixty eight		118	one hundred eighteen		968	nine hundred sixty eight
23		19	nineteen		69	sixty nine		119	one hundred nineteen		969	nine hundred sixty nine
24		20	twenty		70	seventy		120	one hundred twenty		970	nine hundred seventy
25		21	twenty one		71	seventy one		121	one hundred twenty one		971	nine hundred seventy one
26		22	twenty two		72	seventy two		122	one hundred twenty two		972	nine hundred seventy two
27		23	twenty three		73	seventy three		123	one hundred twenty three		973	nine hundred seventy three
28		24	twenty four		74	seventy four		124	one hundred twenty four		974	nine hundred seventy four
29		25	twenty five		75	seventy five		125	one hundred twenty five		975	nine hundred seventy five
30		26	twenty six		76	seventy six		126	one hundred twenty six		976	nine hundred seventy six
31		27	twenty seven		77	seventy seven		127	one hundred twenty seven		977	nine hundred seventy seven
32		28	twenty eight		78	seventy eight		128	one hundred twenty eight		978	nine hundred seventy eight
33		29	twenty nine		79	seventy nine		129	one hundred twenty nine		979	nine hundred seventy nine
34		30	thirty		80	eighty		130	one hundred thirty		980	nine hundred eighty
35		31	thirty one		81	eighty one		131	one hundred thirty one		981	nine hundred eighty one
36		32	thirty two		82	eighty two		132	one hundred thirty two		982	nine hundred eighty two
37		33	thirty three		83	eighty three		133	one hundred thirty three		983	nine hundred eighty three
38		34	thirty four		84	eighty four		134	one hundred thirty four		984	nine hundred eighty four
39		35	thirty five		85	eighty five		135	one hundred thirty five		985	nine hundred eighty five
40		36	thirty six		86	eighty six		136	one hundred thirty six		986	nine hundred eighty six
41		37	thirty seven		87	eighty seven		137	one hundred thirty seven		987	nine hundred eighty seven
42		38	thirty eight		88	eighty eight		138	one hundred thirty eight		988	nine hundred eighty eight
43		39	thirty nine		89	eighty nine		139	one hundred thirty nine		989	nine hundred eighty nine
44		40	forty		90	ninety		140	one hundred forty		990	nine hundred ninety
45		41	forty one		91	ninety one		141	one hundred forty one		991	nine hundred ninety one
46		42	forty two		92	ninety two		142	one hundred forty two		992	nine hundred ninety two
47		43	forty three		93	ninety three		143	one hundred forty three		993	nine hundred ninety three
48		44	forty four		94	ninety four		144	one hundred forty four		994	nine hundred ninety four
49		45	forty five		95	ninety five		145	one hundred forty five		995	nine hundred ninety five
50		46	forty six		96	ninety six		146	one hundred forty six		996	nine hundred ninety six
51		47	forty seven		97	ninety seven		147	one hundred forty seven		997	nine hundred ninety seven
52		48	forty eight		98	ninety eight		148	one hundred forty eight		998	nine hundred ninety eight
53		49	forty nine		99	ninety nine		149	one hundred forty nine		999	nine hundred ninety nine
54
SPELLNR 2

Cell Formulas
Range	Formula
B2,K2,H2,E2	B2	=FORMULATEXT(B4)
C3,N9,L3,I3,F3	C3	=FORMULATEXT(C4)
B4:B53	B4	=SEQUENCE(50)-1
C4:C53,L4:L53,I4:I53,F4:F53	C4	=SH(B4#)
E4:E53	E4	=SEQUENCE(50,,50)
H4:H53	H4	=SEQUENCE(50,,100)
K4:K53	K4	=SEQUENCE(50,,950)
N10:O11	N10	=SH(N6:O7)
Dynamic array formulas.

 

[Xlambda]

SN(a,[cy]) Spelling Numbers. Calls SH(a)
a: single value or cell reference of positive number (with decimals or not)
[cy]: currency argument, if omitted, empty string ""

=LAMBDA(a, [cy],
    LET(
        c, IF(cy = "", "", cy),
        s, " ",
        t, {"trillion"; "billion"; "million"; "thousand"; ""},
        nd, ROUNDUP(a, 2),
        n, TEXT(TEXTBEFORE(nd, ".", , , 1), "000000000000000"),
        dd, TEXTAFTER(nd, ".", , , 1),
        d, IF(LEN(dd) = 1, dd & 0, dd),
        m, SH(MID(n, SEQUENCE(5, , , 3), 3)),
        x, IF(m = "", "", m & s & t),
        v, TEXTJOIN(", ", , x),
        y, IF(c = "", v, IF(v = "", "no " & c, v & s & c)),
        z, IF(d = "", "", IF(y = "", "", " and ") & SH(d) & " cents"),
        TRIM(y & z)
    )
)

spell numbers.xlsx
	A	B	C	D	E
1				cy,omitted
2			formulas C2:C26	=SN(C3)
3			0
4			0.1	ten cents
5			0.9	ninety cents
6			0.123	thirteen cents
7			0.125	thirteen cents
8			0.126	thirteen cents
9			0.123456	thirteen cents
10			10.986	ten and ninety nine cents
11			11.776	eleven and seventy eight cents
12			19.99	nineteen and ninety nine cents
13			19.999	twenty
14			101	one hundred one
15			1001	one thousand, one
16			10001	ten thousand, one
17			100000	one hundred thousand
18			1000001	one million, one
19			10000000	ten million
20	what really is in cell		100000001	one hundred million, one
21	=VALUETOTEXT(C22:C27)		999999999.9	nine hundred ninety nine million, nine hundred ninety nine thousand, nine hundred ninety nine and ninety four cents
22	1000000000000.01	→→	1E+12	one trillion and one cents
23	10000000000000.1	→→	1E+13	ten trillion and ten cents
24	100000000000000	→→	1E+14	one hundred trillion
25	999999999999999	→→	1E+15	nine hundred ninety nine trillion, nine hundred ninety nine billion, nine hundred ninety nine million, nine hundred ninety nine thousand, nine hundred ninety nine
26	10000000023.49	→→	10000000023	ten billion, twenty three and forty nine cents
27	190000000000003	→→	1.9E+14	one hundred ninety trillion, three
28
SPELLNR 3

Cell Formulas
Range	Formula
E3	E3	=SN(C3)
A21,D2	A21	=FORMULATEXT(A22)
A22:A27	A22	=VALUETOTEXT(C22:C27)
D3:D27	D3	=SN(C3)
Dynamic array formulas.

 

[Xlambda]

spell numbers.xlsx
	A	B	C	D	E
1				cy,"euros"
2			formulas C3:C28	=SN(C3,"euros")
3			0	no euros
4			0.1	no euros and ten cents
5			0.9	no euros and ninety cents
6			0.123	no euros and thirteen cents
7			0.125	no euros and thirteen cents
8			0.126	no euros and thirteen cents
9			0.123456	no euros and thirteen cents
10			10.986	ten euros and ninety nine cents
11			11.776	eleven euros and seventy eight cents
12			19.99	nineteen euros and ninety nine cents
13			19.999	twenty euros
14			978.44	nine hundred seventy eight euros and forty four cents
15			7562003.8	seven million, five hundred sixty two thousand, three euros and eighty cents
16			200101.03	two hundred thousand, one hundred one euros and three cents
17			555555555.5	five hundred fifty five million, five hundred fifty five thousand, five hundred fifty five euros and fifty cents
18			2222.22	two thousand, two hundred twenty two euros and twenty two cents
19			33333.33	thirty three thousand, three hundred thirty three euros and thirty three cents
20			444444.44	four hundred forty four thousand, four hundred forty four euros and forty four cents
21			5555555.55	five million, five hundred fifty five thousand, five hundred fifty five euros and fifty five cents
22	=VALUETOTEXT(C23:C28)		66666666.66	sixty six million, six hundred sixty six thousand, six hundred sixty six euros and sixty six cents
23	777777777.77	→→	777777777.8	seven hundred seventy seven million, seven hundred seventy seven thousand, seven hundred seventy seven euros and seventy seven cents
24	8888888888.88	→→	8888888889	eight billion, eight hundred eighty eight million, eight hundred eighty eight thousand, eight hundred eighty eight euros and eighty eight cents
25	99999999999.9	→→	1E+11	ninety nine billion, nine hundred ninety nine million, nine hundred ninety nine thousand, nine hundred ninety nine euros and ninety cents
26	100000000000	→→	1E+11	one hundred billion euros
27	100000000000000	→→	1E+14	one hundred trillion euros
28	999000000000001	→→	9.99E+14	nine hundred ninety nine trillion, one euros
29
SPELLNR 4

Cell Formulas
Range	Formula
A22,D2	A22	=FORMULATEXT(A23)
A23:A28	A23	=VALUETOTEXT(C23:C28)
D3:D28	D3	=SN(C3,"euros")
Dynamic array formulas.

 

[Xlambda]

SPELLNR(ar,[cy]) Spell Numbers. Calls SN(a,[cy])
a: any array
[cy]: currency argument, if omitted, empty string ""

=LAMBDA(ar, [cy],
    LET(
        r, IF(ar = "", "", ar),
        a, IFERROR(ABS(r), ""),
        c, ISNUMBER(a) * (a < 1000000000000000),
        y, IF(c, a, ""),
        g, LEFT(ar, 1),
        m, MAP(y, LAMBDA(x, IF(x = "", "", SN(x, cy)))),
        ca, (g = "-") * (m <> ""),
        z, IF(ca, "negative " & m, m),
        IF(z = "", r, z)
    )
)

spell numbers.xlsx
	A	B	C	D	E
1
2		=RANDARRAY(60,,-999999,999999)		single cell lambda
3		↓↓	single cell lambda	cy,"dollars"
4		↓↓	=SPELLNR(B5#)	=SPELLNR(B5#,"dollars")
5		827025.9511	eight hundred twenty seven thousand, twenty five and ninety six cents	eight hundred twenty seven thousand, twenty five dollars and ninety six cents
6		967190.8414	nine hundred sixty seven thousand, one hundred ninety and eighty five cents	nine hundred sixty seven thousand, one hundred ninety dollars and eighty five cents
7		-942990.1307	negative nine hundred forty two thousand, nine hundred ninety and fourteen cents	negative nine hundred forty two thousand, nine hundred ninety dollars and fourteen cents
8		973607.4679	nine hundred seventy three thousand, six hundred seven and forty seven cents	nine hundred seventy three thousand, six hundred seven dollars and forty seven cents
9		-474929.3543	negative four hundred seventy four thousand, nine hundred twenty nine and thirty six cents	negative four hundred seventy four thousand, nine hundred twenty nine dollars and thirty six cents
10		184486.2849	one hundred eighty four thousand, four hundred eighty six and twenty nine cents	one hundred eighty four thousand, four hundred eighty six dollars and twenty nine cents
11		-684815.8461	negative six hundred eighty four thousand, eight hundred fifteen and eighty five cents	negative six hundred eighty four thousand, eight hundred fifteen dollars and eighty five cents
12		687994.0197	six hundred eighty seven thousand, nine hundred ninety four and two cents	six hundred eighty seven thousand, nine hundred ninety four dollars and two cents
13		354397.5686	three hundred fifty four thousand, three hundred ninety seven and fifty seven cents	three hundred fifty four thousand, three hundred ninety seven dollars and fifty seven cents
14		542401.1714	five hundred forty two thousand, four hundred one and eighteen cents	five hundred forty two thousand, four hundred one dollars and eighteen cents
15		-409379.2076	negative four hundred nine thousand, three hundred seventy nine and twenty one cents	negative four hundred nine thousand, three hundred seventy nine dollars and twenty one cents
16		468130.7616	four hundred sixty eight thousand, one hundred thirty and seventy seven cents	four hundred sixty eight thousand, one hundred thirty dollars and seventy seven cents
17		274897.5428	two hundred seventy four thousand, eight hundred ninety seven and fifty five cents	two hundred seventy four thousand, eight hundred ninety seven dollars and fifty five cents
18		952624.8789	nine hundred fifty two thousand, six hundred twenty four and eighty eight cents	nine hundred fifty two thousand, six hundred twenty four dollars and eighty eight cents
19		-301276.5422	negative three hundred one thousand, two hundred seventy six and fifty five cents	negative three hundred one thousand, two hundred seventy six dollars and fifty five cents
20		-227509.427	negative two hundred twenty seven thousand, five hundred nine and forty three cents	negative two hundred twenty seven thousand, five hundred nine dollars and forty three cents
21		11786.84995	eleven thousand, seven hundred eighty six and eighty five cents	eleven thousand, seven hundred eighty six dollars and eighty five cents
22		784848.5872	seven hundred eighty four thousand, eight hundred forty eight and fifty nine cents	seven hundred eighty four thousand, eight hundred forty eight dollars and fifty nine cents
23		-58175.2977	negative fifty eight thousand, one hundred seventy five and thirty cents	negative fifty eight thousand, one hundred seventy five dollars and thirty cents
24		894871.2297	eight hundred ninety four thousand, eight hundred seventy one and twenty three cents	eight hundred ninety four thousand, eight hundred seventy one dollars and twenty three cents
25		-804604.9034	negative eight hundred four thousand, six hundred four and ninety one cents	negative eight hundred four thousand, six hundred four dollars and ninety one cents
26		899840.2359	eight hundred ninety nine thousand, eight hundred forty and twenty four cents	eight hundred ninety nine thousand, eight hundred forty dollars and twenty four cents
27		659820.9247	six hundred fifty nine thousand, eight hundred twenty and ninety three cents	six hundred fifty nine thousand, eight hundred twenty dollars and ninety three cents
28		234891.8114	two hundred thirty four thousand, eight hundred ninety one and eighty two cents	two hundred thirty four thousand, eight hundred ninety one dollars and eighty two cents
29		-753338.7395	negative seven hundred fifty three thousand, three hundred thirty eight and seventy four cents	negative seven hundred fifty three thousand, three hundred thirty eight dollars and seventy four cents
30		-46511.586	negative forty six thousand, five hundred eleven and fifty nine cents	negative forty six thousand, five hundred eleven dollars and fifty nine cents
31		892110.4368	eight hundred ninety two thousand, one hundred ten and forty four cents	eight hundred ninety two thousand, one hundred ten dollars and forty four cents
32		-976080.4727	negative nine hundred seventy six thousand, eighty and forty eight cents	negative nine hundred seventy six thousand, eighty dollars and forty eight cents
33		-382185.2579	negative three hundred eighty two thousand, one hundred eighty five and twenty six cents	negative three hundred eighty two thousand, one hundred eighty five dollars and twenty six cents
34		-535319.9342	negative five hundred thirty five thousand, three hundred nineteen and ninety four cents	negative five hundred thirty five thousand, three hundred nineteen dollars and ninety four cents
35		990369.7093	nine hundred ninety thousand, three hundred sixty nine and seventy one cents	nine hundred ninety thousand, three hundred sixty nine dollars and seventy one cents
36		-166673.6204	negative one hundred sixty six thousand, six hundred seventy three and sixty three cents	negative one hundred sixty six thousand, six hundred seventy three dollars and sixty three cents
37		13649.43095	thirteen thousand, six hundred forty nine and forty four cents	thirteen thousand, six hundred forty nine dollars and forty four cents
38		-377885.0568	negative three hundred seventy seven thousand, eight hundred eighty five and six cents	negative three hundred seventy seven thousand, eight hundred eighty five dollars and six cents
39		-551332.3562	negative five hundred fifty one thousand, three hundred thirty two and thirty six cents	negative five hundred fifty one thousand, three hundred thirty two dollars and thirty six cents
40		-246979.6525	negative two hundred forty six thousand, nine hundred seventy nine and sixty six cents	negative two hundred forty six thousand, nine hundred seventy nine dollars and sixty six cents
41		783339.9629	seven hundred eighty three thousand, three hundred thirty nine and ninety seven cents	seven hundred eighty three thousand, three hundred thirty nine dollars and ninety seven cents
42		-373118.696	negative three hundred seventy three thousand, one hundred eighteen and seventy cents	negative three hundred seventy three thousand, one hundred eighteen dollars and seventy cents
43		-452089.6908	negative four hundred fifty two thousand, eighty nine and seventy cents	negative four hundred fifty two thousand, eighty nine dollars and seventy cents
44		311082.0227	three hundred eleven thousand, eighty two and three cents	three hundred eleven thousand, eighty two dollars and three cents
45		849946.2659	eight hundred forty nine thousand, nine hundred forty six and twenty seven cents	eight hundred forty nine thousand, nine hundred forty six dollars and twenty seven cents
46		-614049.3494	negative six hundred fourteen thousand, forty nine and thirty five cents	negative six hundred fourteen thousand, forty nine dollars and thirty five cents
47		423451.1556	four hundred twenty three thousand, four hundred fifty one and sixteen cents	four hundred twenty three thousand, four hundred fifty one dollars and sixteen cents
48		748526.8031	seven hundred forty eight thousand, five hundred twenty six and eighty one cents	seven hundred forty eight thousand, five hundred twenty six dollars and eighty one cents
49		-764905.1543	negative seven hundred sixty four thousand, nine hundred five and sixteen cents	negative seven hundred sixty four thousand, nine hundred five dollars and sixteen cents
50		830786.7686	eight hundred thirty thousand, seven hundred eighty six and seventy seven cents	eight hundred thirty thousand, seven hundred eighty six dollars and seventy seven cents
51		933814.8802	nine hundred thirty three thousand, eight hundred fourteen and eighty nine cents	nine hundred thirty three thousand, eight hundred fourteen dollars and eighty nine cents
52		522546.4019	five hundred twenty two thousand, five hundred forty six and forty one cents	five hundred twenty two thousand, five hundred forty six dollars and forty one cents
53		562837.7008	five hundred sixty two thousand, eight hundred thirty seven and seventy one cents	five hundred sixty two thousand, eight hundred thirty seven dollars and seventy one cents
54		621399.4858	six hundred twenty one thousand, three hundred ninety nine and forty nine cents	six hundred twenty one thousand, three hundred ninety nine dollars and forty nine cents
55		884890.6126	eight hundred eighty four thousand, eight hundred ninety and sixty two cents	eight hundred eighty four thousand, eight hundred ninety dollars and sixty two cents
56		666756.6951	six hundred sixty six thousand, seven hundred fifty six and seventy cents	six hundred sixty six thousand, seven hundred fifty six dollars and seventy cents
57		-823222.371	negative eight hundred twenty three thousand, two hundred twenty two and thirty eight cents	negative eight hundred twenty three thousand, two hundred twenty two dollars and thirty eight cents
58		-418770.8902	negative four hundred eighteen thousand, seven hundred seventy and ninety cents	negative four hundred eighteen thousand, seven hundred seventy dollars and ninety cents
59		-977571.1008	negative nine hundred seventy seven thousand, five hundred seventy one and eleven cents	negative nine hundred seventy seven thousand, five hundred seventy one dollars and eleven cents
60		-343443.0269	negative three hundred forty three thousand, four hundred forty three and three cents	negative three hundred forty three thousand, four hundred forty three dollars and three cents
61		-212901.8229	negative two hundred twelve thousand, nine hundred one and eighty three cents	negative two hundred twelve thousand, nine hundred one dollars and eighty three cents
62		-431349.9871	negative four hundred thirty one thousand, three hundred forty nine and ninety nine cents	negative four hundred thirty one thousand, three hundred forty nine dollars and ninety nine cents
63		-345083.8729	negative three hundred forty five thousand, eighty three and eighty eight cents	negative three hundred forty five thousand, eighty three dollars and eighty eight cents
64		-573884.7048	negative five hundred seventy three thousand, eight hundred eighty four and seventy one cents	negative five hundred seventy three thousand, eight hundred eighty four dollars and seventy one cents
65
SPELLNR 5

Cell Formulas
Range	Formula
B2	B2	=FORMULATEXT(B5)
C4:D4	C4	=FORMULATEXT(C5)
B5:B64	B5	=RANDARRAY(60,,-999999,999999)
C5:C64	C5	=SPELLNR(B5#)
D5:D64	D5	=SPELLNR(B5#,"dollars")
Dynamic array formulas.

 

[Xlambda]

SPELLNR can deal with positive/negative numbers which in absolute values are less than 1 quadrillion (1E+15), ignoring the rest, text, blanks/empty strings, numbers n that abs(n )>1E+15

spell numbers.xlsx
	A	B	C	D	E	F	G	H	I
1
2						cy,omitted
3		ar				=SPELLNR(B4:D6)
4		23876.29	-text	-0.12		twenty three thousand, eight hundred seventy six and twenty nine cents	-text	negative twelve cents
5		2675213.47		-532009.17		two million, six hundred seventy five thousand, two hundred thirteen and forty seven cents		negative five hundred thirty two thousand, nine and seventeen cents
6		-1000001.01	1.23457E+16	90000009.09		negative one million, one and one cents	1.23457E+16	ninety million, nine and nine cents
7
8						cy,"units"
9		text				=SPELLNR(B4:D6,"units")
10		blank/empty string				twenty three thousand, eight hundred seventy six units and twenty nine cents	-text	negative no units and twelve cents
11		lrg nr.> 1 quadrillion (1E+15)				two million, six hundred seventy five thousand, two hundred thirteen units and forty seven cents		negative five hundred thirty two thousand, nine units and seventeen cents
12						negative one million, one units and one cents	1.23457E+16	ninety million, nine units and nine cents
13
SPELLNR 6

Cell Formulas
Range	Formula
F3,F9	F3	=FORMULATEXT(F4)
F4:H6	F4	=SPELLNR(B4:D6)
F10:H12	F10	=SPELLNR(B4:D6,"units")
Dynamic array formulas.

 

[Xlambda]

Fun fact: No number less than 1000 contains the letter "a"

spell numbers.xlsx
	A	B	C	D	E	F	G	H	I
1
2		=SPELLNR(SEQUENCE(999))		=SEARCH("a",B3#)		=--ISERR(D3#)		=SUM(F3#)
3		one		#VALUE!		1		999
4		two		#VALUE!		1
5		three		#VALUE!		1
6		four		#VALUE!		1
7		five		#VALUE!		1
8		six		#VALUE!		1
9		seven		#VALUE!		1
10		eight		#VALUE!		1
11		nine		#VALUE!		1
12		ten		#VALUE!		1
13		eleven		#VALUE!		1
14		twelve		#VALUE!		1
15		thirteen		#VALUE!		1
16		fourteen		#VALUE!		1
17		fifteen		#VALUE!		1
18		sixteen		#VALUE!		1
19		seventeen		#VALUE!		1
20		eighteen		#VALUE!		1
21		nineteen		#VALUE!		1
22		twenty		#VALUE!		1
23		twenty one		#VALUE!		1
24		twenty two		#VALUE!		1
25		twenty three		#VALUE!		1
26		twenty four		#VALUE!		1
27		twenty five		#VALUE!		1
28		twenty six		#VALUE!		1
29		twenty seven		#VALUE!		1
30		twenty eight		#VALUE!		1
31		twenty nine		#VALUE!		1
32		thirty		#VALUE!		1
33		thirty one		#VALUE!		1
34		thirty two		#VALUE!		1
35		thirty three		#VALUE!		1
36		thirty four		#VALUE!		1
37		thirty five		#VALUE!		1
38		thirty six		#VALUE!		1
39		thirty seven		#VALUE!		1
40		thirty eight		#VALUE!		1
41		thirty nine		#VALUE!		1
42		forty		#VALUE!		1
43		forty one		#VALUE!		1
44		forty two		#VALUE!		1
45		forty three		#VALUE!		1
46		forty four		#VALUE!		1
47		forty five		#VALUE!		1
48		forty six		#VALUE!		1
49		forty seven		#VALUE!		1
50		forty eight		#VALUE!		1
51		forty nine		#VALUE!		1
52		fifty		#VALUE!		1
53		fifty one		#VALUE!		1
54		fifty two		#VALUE!		1
55		fifty three		#VALUE!		1
56		fifty four		#VALUE!		1
57		fifty five		#VALUE!		1
58		fifty six		#VALUE!		1
59		fifty seven		#VALUE!		1
60		fifty eight		#VALUE!		1
61		fifty nine		#VALUE!		1
62		sixty		#VALUE!		1
63		sixty one		#VALUE!		1
64		sixty two		#VALUE!		1
65		sixty three		#VALUE!		1
66		sixty four		#VALUE!		1
67		sixty five		#VALUE!		1
68		sixty six		#VALUE!		1
69		sixty seven		#VALUE!		1
70		sixty eight		#VALUE!		1
71		sixty nine		#VALUE!		1
72		seventy		#VALUE!		1
73		seventy one		#VALUE!		1
74		seventy two		#VALUE!		1
75		seventy three		#VALUE!		1
76		seventy four		#VALUE!		1
77		seventy five		#VALUE!		1
78		seventy six		#VALUE!		1
79		seventy seven		#VALUE!		1
80		seventy eight		#VALUE!		1
81		seventy nine		#VALUE!		1
82		eighty		#VALUE!		1
83		eighty one		#VALUE!		1
84		eighty two		#VALUE!		1
85		eighty three		#VALUE!		1
86		eighty four		#VALUE!		1
87		eighty five		#VALUE!		1
88		eighty six		#VALUE!		1
89		eighty seven		#VALUE!		1
90		eighty eight		#VALUE!		1
91		eighty nine		#VALUE!		1
92		ninety		#VALUE!		1
93		ninety one		#VALUE!		1
94		ninety two		#VALUE!		1
95		ninety three		#VALUE!		1
96		ninety four		#VALUE!		1
97		ninety five		#VALUE!		1
98		ninety six		#VALUE!		1
99		ninety seven		#VALUE!		1
100		ninety eight		#VALUE!		1
101		ninety nine		#VALUE!		1
102		one hundred		#VALUE!		1
103		one hundred one		#VALUE!		1
104		one hundred two		#VALUE!		1
105		one hundred three		#VALUE!		1
106		one hundred four		#VALUE!		1
107		one hundred five		#VALUE!		1
108		one hundred six		#VALUE!		1
109		one hundred seven		#VALUE!		1
110		one hundred eight		#VALUE!		1
111		one hundred nine		#VALUE!		1
112		one hundred ten		#VALUE!		1
113		one hundred eleven		#VALUE!		1
114		one hundred twelve		#VALUE!		1
115		one hundred thirteen		#VALUE!		1
116		one hundred fourteen		#VALUE!		1
117		one hundred fifteen		#VALUE!		1
118		one hundred sixteen		#VALUE!		1
119		one hundred seventeen		#VALUE!		1
120		one hundred eighteen		#VALUE!		1
121		one hundred nineteen		#VALUE!		1
122		one hundred twenty		#VALUE!		1
123		one hundred twenty one		#VALUE!		1
124		one hundred twenty two		#VALUE!		1
125		one hundred twenty three		#VALUE!		1
126		one hundred twenty four		#VALUE!		1
127		one hundred twenty five		#VALUE!		1
128		one hundred twenty six		#VALUE!		1
129		one hundred twenty seven		#VALUE!		1
130		one hundred twenty eight		#VALUE!		1
131		one hundred twenty nine		#VALUE!		1
132		one hundred thirty		#VALUE!		1
133		one hundred thirty one		#VALUE!		1
134		one hundred thirty two		#VALUE!		1
135		one hundred thirty three		#VALUE!		1
136		one hundred thirty four		#VALUE!		1
137		one hundred thirty five		#VALUE!		1
138		one hundred thirty six		#VALUE!		1
139		one hundred thirty seven		#VALUE!		1
140		one hundred thirty eight		#VALUE!		1
141		one hundred thirty nine		#VALUE!		1
142		one hundred forty		#VALUE!		1
143		one hundred forty one		#VALUE!		1
144		one hundred forty two		#VALUE!		1
145		one hundred forty three		#VALUE!		1
146		one hundred forty four		#VALUE!		1
147		one hundred forty five		#VALUE!		1
148		one hundred forty six		#VALUE!		1
149		one hundred forty seven		#VALUE!		1
150		one hundred forty eight		#VALUE!		1
151		one hundred forty nine		#VALUE!		1
152		one hundred fifty		#VALUE!		1
153		one hundred fifty one		#VALUE!		1
154		one hundred fifty two		#VALUE!		1
155		one hundred fifty three		#VALUE!		1
156		one hundred fifty four		#VALUE!		1
157		one hundred fifty five		#VALUE!		1
158		one hundred fifty six		#VALUE!		1
159		one hundred fifty seven		#VALUE!		1
160		one hundred fifty eight		#VALUE!		1
161		one hundred fifty nine		#VALUE!		1
162		one hundred sixty		#VALUE!		1
163		one hundred sixty one		#VALUE!		1
164		one hundred sixty two		#VALUE!		1
165		one hundred sixty three		#VALUE!		1
166		one hundred sixty four		#VALUE!		1
167		one hundred sixty five		#VALUE!		1
168		one hundred sixty six		#VALUE!		1
169		one hundred sixty seven		#VALUE!		1
170		one hundred sixty eight		#VALUE!		1
171		one hundred sixty nine		#VALUE!		1
172		one hundred seventy		#VALUE!		1
173		one hundred seventy one		#VALUE!		1
174		one hundred seventy two		#VALUE!		1
175		one hundred seventy three		#VALUE!		1
176		one hundred seventy four		#VALUE!		1
177		one hundred seventy five		#VALUE!		1
178		one hundred seventy six		#VALUE!		1
179		one hundred seventy seven		#VALUE!		1
180		one hundred seventy eight		#VALUE!		1
181		one hundred seventy nine		#VALUE!		1
182		one hundred eighty		#VALUE!		1
183		one hundred eighty one		#VALUE!		1
184		one hundred eighty two		#VALUE!		1
185		one hundred eighty three		#VALUE!		1
186		one hundred eighty four		#VALUE!		1
187		one hundred eighty five		#VALUE!		1
188		one hundred eighty six		#VALUE!		1
189		one hundred eighty seven		#VALUE!		1
190		one hundred eighty eight		#VALUE!		1
191		one hundred eighty nine		#VALUE!		1
192		one hundred ninety		#VALUE!		1
193		one hundred ninety one		#VALUE!		1
194		one hundred ninety two		#VALUE!		1
195		one hundred ninety three		#VALUE!		1
196		one hundred ninety four		#VALUE!		1
197		one hundred ninety five		#VALUE!		1
198		one hundred ninety six		#VALUE!		1
199		one hundred ninety seven		#VALUE!		1
200		one hundred ninety eight		#VALUE!		1
201		one hundred ninety nine		#VALUE!		1
202		two hundred		#VALUE!		1
203		two hundred one		#VALUE!		1
204		two hundred two		#VALUE!		1
Sheet13

Cell Formulas
Range	Formula
D2,F2,H2,B2	D2	=FORMULATEXT(D3)
B3:B1001	B3	=SPELLNR(SEQUENCE(999))
D3:D1001	D3	=SEARCH("a",B3#)
F3:F1001	F3	=--ISERR(D3#)
H3	H3	=SUM(F3#)
Dynamic array formulas.

 

[Xlambda]

Redesigned all modules needed to spell numbers in a more compact form. Introduced all the key english words used for spelling numbers in one place, the initial DE function. Having them in one place and not spreaded through other functions, will make it easier to translate at one place only, if we need spelling in another language. Only the units name can be changed in the expression of last function, the main function, SPLNRS, as will see.
1st module: DE() Digits in English, argument free function template.

=LAMBDA(
    {
        0, "", "ten", "", " hundred ";
        1, "one", "eleven", "", " hundredth ";
        2, "two", "twelve", "twenty", "";
        3, "three", "thirteen", "thirty", "";
        4, "four", "fourteen", "forty", "";
        5, "five", "fifteen", "fifty", "";
        6, "six", "sixteen", "sixty", "";
        7, "seven", "seventeen", "seventy", "";
        8, "eight", "eighteen", "eighty", "";
        9, "nine", "nineteen", "ninety", "";
        " trillion ", " billion ", " million ", " thousands ", ""
    }
)

Important Note: " hundred ", " hundredth ", " trillion ", " billion ", " million ", and " thousands " words have leading and trailing spaces.
This design gimmick helped me make the functions shorter. This structure should be kept in case of using other languages.
All references to these words in the following functions will be made using INDEX(DE(),row,clm) and not explicitly.

SPLNRS.xlsx
	A	B	C	D	E	F	G
1
2		=DE()
3		0		ten		hundred
4		1	one	eleven		hundredth
5		2	two	twelve	twenty
6		3	three	thirteen	thirty
7		4	four	fourteen	forty
8		5	five	fifteen	fifty
9		6	six	sixteen	sixty
10		7	seven	seventeen	seventy
11		8	eight	eighteen	eighty
12		9	nine	nineteen	ninety
13		trillion	billion	million	thousands
14
15
16		=DE()
17		0		ten		hundred
18		1	one	eleven		hundredth
19		2	two	twelve	twenty
20		3	three	thirteen	thirty
21		4	four	fourteen	forty
22		5	five	fifteen	fifty
23		6	six	sixteen	sixty
24		7	seven	seventeen	seventy
25		8	eight	eighteen	eighty
26		9	nine	nineteen	ninety
27		trillion	billion	million	thousands
28
29		color codes
30			- leading and tailing spaces
31			- empty strings "" (not blanks)
32			- no leading or trailing spaces
33
DE()

Cell Formulas
Range	Formula
B2,B16	B2	=FORMULATEXT(B3)
B3:F13,B17:F27	B3	=DE()
Dynamic array formulas.

 

[Xlambda]

2nd module: SH(a) Spelling Hundreds function
a: array (single value, 1D or 2D arrays) , integers up to 3 digits.

=LAMBDA(a,
    LET(
        h, INDEX(DE(), 1, 5),
        t, TEXT(a, "000"),
        l, --LEFT(t, 1),
        m, --MID(t, 2, 1),
        r, --RIGHT(t, 1),
        x, VLOOKUP(l, DE(), 2),
        y, VLOOKUP(m, DE(), 4),
        z, IF(m = 1, VLOOKUP(r, DE(), 3), VLOOKUP(r, DE(), 2)),
        v, y & " " & z,
        IFERROR(TRIM(IF(x = "", v, x & h & v)), "")
    )
)

Spelling all possible 3 digits tops numbers 0-999 using as input array SEQUENCE(50,20)-1

SPLNRS.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1
2		=SH(SEQUENCE(50,20)-1)
3			one	two	three	four	five	six	seven	eight	nine	ten	eleven	twelve	thirteen	fourteen	fifteen	sixteen	seventeen	eighteen	nineteen
4		twenty	twenty one	twenty two	twenty three	twenty four	twenty five	twenty six	twenty seven	twenty eight	twenty nine	thirty	thirty one	thirty two	thirty three	thirty four	thirty five	thirty six	thirty seven	thirty eight	thirty nine
5		forty	forty one	forty two	forty three	forty four	forty five	forty six	forty seven	forty eight	forty nine	fifty	fifty one	fifty two	fifty three	fifty four	fifty five	fifty six	fifty seven	fifty eight	fifty nine
6		sixty	sixty one	sixty two	sixty three	sixty four	sixty five	sixty six	sixty seven	sixty eight	sixty nine	seventy	seventy one	seventy two	seventy three	seventy four	seventy five	seventy six	seventy seven	seventy eight	seventy nine
7		eighty	eighty one	eighty two	eighty three	eighty four	eighty five	eighty six	eighty seven	eighty eight	eighty nine	ninety	ninety one	ninety two	ninety three	ninety four	ninety five	ninety six	ninety seven	ninety eight	ninety nine
8		one hundred	one hundred one	one hundred two	one hundred three	one hundred four	one hundred five	one hundred six	one hundred seven	one hundred eight	one hundred nine	one hundred ten	one hundred eleven	one hundred twelve	one hundred thirteen	one hundred fourteen	one hundred fifteen	one hundred sixteen	one hundred seventeen	one hundred eighteen	one hundred nineteen
9		one hundred twenty	one hundred twenty one	one hundred twenty two	one hundred twenty three	one hundred twenty four	one hundred twenty five	one hundred twenty six	one hundred twenty seven	one hundred twenty eight	one hundred twenty nine	one hundred thirty	one hundred thirty one	one hundred thirty two	one hundred thirty three	one hundred thirty four	one hundred thirty five	one hundred thirty six	one hundred thirty seven	one hundred thirty eight	one hundred thirty nine
10		one hundred forty	one hundred forty one	one hundred forty two	one hundred forty three	one hundred forty four	one hundred forty five	one hundred forty six	one hundred forty seven	one hundred forty eight	one hundred forty nine	one hundred fifty	one hundred fifty one	one hundred fifty two	one hundred fifty three	one hundred fifty four	one hundred fifty five	one hundred fifty six	one hundred fifty seven	one hundred fifty eight	one hundred fifty nine
11		one hundred sixty	one hundred sixty one	one hundred sixty two	one hundred sixty three	one hundred sixty four	one hundred sixty five	one hundred sixty six	one hundred sixty seven	one hundred sixty eight	one hundred sixty nine	one hundred seventy	one hundred seventy one	one hundred seventy two	one hundred seventy three	one hundred seventy four	one hundred seventy five	one hundred seventy six	one hundred seventy seven	one hundred seventy eight	one hundred seventy nine
12		one hundred eighty	one hundred eighty one	one hundred eighty two	one hundred eighty three	one hundred eighty four	one hundred eighty five	one hundred eighty six	one hundred eighty seven	one hundred eighty eight	one hundred eighty nine	one hundred ninety	one hundred ninety one	one hundred ninety two	one hundred ninety three	one hundred ninety four	one hundred ninety five	one hundred ninety six	one hundred ninety seven	one hundred ninety eight	one hundred ninety nine
13		two hundred	two hundred one	two hundred two	two hundred three	two hundred four	two hundred five	two hundred six	two hundred seven	two hundred eight	two hundred nine	two hundred ten	two hundred eleven	two hundred twelve	two hundred thirteen	two hundred fourteen	two hundred fifteen	two hundred sixteen	two hundred seventeen	two hundred eighteen	two hundred nineteen
14		two hundred twenty	two hundred twenty one	two hundred twenty two	two hundred twenty three	two hundred twenty four	two hundred twenty five	two hundred twenty six	two hundred twenty seven	two hundred twenty eight	two hundred twenty nine	two hundred thirty	two hundred thirty one	two hundred thirty two	two hundred thirty three	two hundred thirty four	two hundred thirty five	two hundred thirty six	two hundred thirty seven	two hundred thirty eight	two hundred thirty nine
15		two hundred forty	two hundred forty one	two hundred forty two	two hundred forty three	two hundred forty four	two hundred forty five	two hundred forty six	two hundred forty seven	two hundred forty eight	two hundred forty nine	two hundred fifty	two hundred fifty one	two hundred fifty two	two hundred fifty three	two hundred fifty four	two hundred fifty five	two hundred fifty six	two hundred fifty seven	two hundred fifty eight	two hundred fifty nine
16		two hundred sixty	two hundred sixty one	two hundred sixty two	two hundred sixty three	two hundred sixty four	two hundred sixty five	two hundred sixty six	two hundred sixty seven	two hundred sixty eight	two hundred sixty nine	two hundred seventy	two hundred seventy one	two hundred seventy two	two hundred seventy three	two hundred seventy four	two hundred seventy five	two hundred seventy six	two hundred seventy seven	two hundred seventy eight	two hundred seventy nine
17		two hundred eighty	two hundred eighty one	two hundred eighty two	two hundred eighty three	two hundred eighty four	two hundred eighty five	two hundred eighty six	two hundred eighty seven	two hundred eighty eight	two hundred eighty nine	two hundred ninety	two hundred ninety one	two hundred ninety two	two hundred ninety three	two hundred ninety four	two hundred ninety five	two hundred ninety six	two hundred ninety seven	two hundred ninety eight	two hundred ninety nine
18		three hundred	three hundred one	three hundred two	three hundred three	three hundred four	three hundred five	three hundred six	three hundred seven	three hundred eight	three hundred nine	three hundred ten	three hundred eleven	three hundred twelve	three hundred thirteen	three hundred fourteen	three hundred fifteen	three hundred sixteen	three hundred seventeen	three hundred eighteen	three hundred nineteen
19		three hundred twenty	three hundred twenty one	three hundred twenty two	three hundred twenty three	three hundred twenty four	three hundred twenty five	three hundred twenty six	three hundred twenty seven	three hundred twenty eight	three hundred twenty nine	three hundred thirty	three hundred thirty one	three hundred thirty two	three hundred thirty three	three hundred thirty four	three hundred thirty five	three hundred thirty six	three hundred thirty seven	three hundred thirty eight	three hundred thirty nine
20		three hundred forty	three hundred forty one	three hundred forty two	three hundred forty three	three hundred forty four	three hundred forty five	three hundred forty six	three hundred forty seven	three hundred forty eight	three hundred forty nine	three hundred fifty	three hundred fifty one	three hundred fifty two	three hundred fifty three	three hundred fifty four	three hundred fifty five	three hundred fifty six	three hundred fifty seven	three hundred fifty eight	three hundred fifty nine
21		three hundred sixty	three hundred sixty one	three hundred sixty two	three hundred sixty three	three hundred sixty four	three hundred sixty five	three hundred sixty six	three hundred sixty seven	three hundred sixty eight	three hundred sixty nine	three hundred seventy	three hundred seventy one	three hundred seventy two	three hundred seventy three	three hundred seventy four	three hundred seventy five	three hundred seventy six	three hundred seventy seven	three hundred seventy eight	three hundred seventy nine
22		three hundred eighty	three hundred eighty one	three hundred eighty two	three hundred eighty three	three hundred eighty four	three hundred eighty five	three hundred eighty six	three hundred eighty seven	three hundred eighty eight	three hundred eighty nine	three hundred ninety	three hundred ninety one	three hundred ninety two	three hundred ninety three	three hundred ninety four	three hundred ninety five	three hundred ninety six	three hundred ninety seven	three hundred ninety eight	three hundred ninety nine
23		four hundred	four hundred one	four hundred two	four hundred three	four hundred four	four hundred five	four hundred six	four hundred seven	four hundred eight	four hundred nine	four hundred ten	four hundred eleven	four hundred twelve	four hundred thirteen	four hundred fourteen	four hundred fifteen	four hundred sixteen	four hundred seventeen	four hundred eighteen	four hundred nineteen
24		four hundred twenty	four hundred twenty one	four hundred twenty two	four hundred twenty three	four hundred twenty four	four hundred twenty five	four hundred twenty six	four hundred twenty seven	four hundred twenty eight	four hundred twenty nine	four hundred thirty	four hundred thirty one	four hundred thirty two	four hundred thirty three	four hundred thirty four	four hundred thirty five	four hundred thirty six	four hundred thirty seven	four hundred thirty eight	four hundred thirty nine
25		four hundred forty	four hundred forty one	four hundred forty two	four hundred forty three	four hundred forty four	four hundred forty five	four hundred forty six	four hundred forty seven	four hundred forty eight	four hundred forty nine	four hundred fifty	four hundred fifty one	four hundred fifty two	four hundred fifty three	four hundred fifty four	four hundred fifty five	four hundred fifty six	four hundred fifty seven	four hundred fifty eight	four hundred fifty nine
26		four hundred sixty	four hundred sixty one	four hundred sixty two	four hundred sixty three	four hundred sixty four	four hundred sixty five	four hundred sixty six	four hundred sixty seven	four hundred sixty eight	four hundred sixty nine	four hundred seventy	four hundred seventy one	four hundred seventy two	four hundred seventy three	four hundred seventy four	four hundred seventy five	four hundred seventy six	four hundred seventy seven	four hundred seventy eight	four hundred seventy nine
27		four hundred eighty	four hundred eighty one	four hundred eighty two	four hundred eighty three	four hundred eighty four	four hundred eighty five	four hundred eighty six	four hundred eighty seven	four hundred eighty eight	four hundred eighty nine	four hundred ninety	four hundred ninety one	four hundred ninety two	four hundred ninety three	four hundred ninety four	four hundred ninety five	four hundred ninety six	four hundred ninety seven	four hundred ninety eight	four hundred ninety nine
28		five hundred	five hundred one	five hundred two	five hundred three	five hundred four	five hundred five	five hundred six	five hundred seven	five hundred eight	five hundred nine	five hundred ten	five hundred eleven	five hundred twelve	five hundred thirteen	five hundred fourteen	five hundred fifteen	five hundred sixteen	five hundred seventeen	five hundred eighteen	five hundred nineteen
29		five hundred twenty	five hundred twenty one	five hundred twenty two	five hundred twenty three	five hundred twenty four	five hundred twenty five	five hundred twenty six	five hundred twenty seven	five hundred twenty eight	five hundred twenty nine	five hundred thirty	five hundred thirty one	five hundred thirty two	five hundred thirty three	five hundred thirty four	five hundred thirty five	five hundred thirty six	five hundred thirty seven	five hundred thirty eight	five hundred thirty nine
30		five hundred forty	five hundred forty one	five hundred forty two	five hundred forty three	five hundred forty four	five hundred forty five	five hundred forty six	five hundred forty seven	five hundred forty eight	five hundred forty nine	five hundred fifty	five hundred fifty one	five hundred fifty two	five hundred fifty three	five hundred fifty four	five hundred fifty five	five hundred fifty six	five hundred fifty seven	five hundred fifty eight	five hundred fifty nine
31		five hundred sixty	five hundred sixty one	five hundred sixty two	five hundred sixty three	five hundred sixty four	five hundred sixty five	five hundred sixty six	five hundred sixty seven	five hundred sixty eight	five hundred sixty nine	five hundred seventy	five hundred seventy one	five hundred seventy two	five hundred seventy three	five hundred seventy four	five hundred seventy five	five hundred seventy six	five hundred seventy seven	five hundred seventy eight	five hundred seventy nine
32		five hundred eighty	five hundred eighty one	five hundred eighty two	five hundred eighty three	five hundred eighty four	five hundred eighty five	five hundred eighty six	five hundred eighty seven	five hundred eighty eight	five hundred eighty nine	five hundred ninety	five hundred ninety one	five hundred ninety two	five hundred ninety three	five hundred ninety four	five hundred ninety five	five hundred ninety six	five hundred ninety seven	five hundred ninety eight	five hundred ninety nine
33		six hundred	six hundred one	six hundred two	six hundred three	six hundred four	six hundred five	six hundred six	six hundred seven	six hundred eight	six hundred nine	six hundred ten	six hundred eleven	six hundred twelve	six hundred thirteen	six hundred fourteen	six hundred fifteen	six hundred sixteen	six hundred seventeen	six hundred eighteen	six hundred nineteen
34		six hundred twenty	six hundred twenty one	six hundred twenty two	six hundred twenty three	six hundred twenty four	six hundred twenty five	six hundred twenty six	six hundred twenty seven	six hundred twenty eight	six hundred twenty nine	six hundred thirty	six hundred thirty one	six hundred thirty two	six hundred thirty three	six hundred thirty four	six hundred thirty five	six hundred thirty six	six hundred thirty seven	six hundred thirty eight	six hundred thirty nine
35		six hundred forty	six hundred forty one	six hundred forty two	six hundred forty three	six hundred forty four	six hundred forty five	six hundred forty six	six hundred forty seven	six hundred forty eight	six hundred forty nine	six hundred fifty	six hundred fifty one	six hundred fifty two	six hundred fifty three	six hundred fifty four	six hundred fifty five	six hundred fifty six	six hundred fifty seven	six hundred fifty eight	six hundred fifty nine
36		six hundred sixty	six hundred sixty one	six hundred sixty two	six hundred sixty three	six hundred sixty four	six hundred sixty five	six hundred sixty six	six hundred sixty seven	six hundred sixty eight	six hundred sixty nine	six hundred seventy	six hundred seventy one	six hundred seventy two	six hundred seventy three	six hundred seventy four	six hundred seventy five	six hundred seventy six	six hundred seventy seven	six hundred seventy eight	six hundred seventy nine
37		six hundred eighty	six hundred eighty one	six hundred eighty two	six hundred eighty three	six hundred eighty four	six hundred eighty five	six hundred eighty six	six hundred eighty seven	six hundred eighty eight	six hundred eighty nine	six hundred ninety	six hundred ninety one	six hundred ninety two	six hundred ninety three	six hundred ninety four	six hundred ninety five	six hundred ninety six	six hundred ninety seven	six hundred ninety eight	six hundred ninety nine
38		seven hundred	seven hundred one	seven hundred two	seven hundred three	seven hundred four	seven hundred five	seven hundred six	seven hundred seven	seven hundred eight	seven hundred nine	seven hundred ten	seven hundred eleven	seven hundred twelve	seven hundred thirteen	seven hundred fourteen	seven hundred fifteen	seven hundred sixteen	seven hundred seventeen	seven hundred eighteen	seven hundred nineteen
39		seven hundred twenty	seven hundred twenty one	seven hundred twenty two	seven hundred twenty three	seven hundred twenty four	seven hundred twenty five	seven hundred twenty six	seven hundred twenty seven	seven hundred twenty eight	seven hundred twenty nine	seven hundred thirty	seven hundred thirty one	seven hundred thirty two	seven hundred thirty three	seven hundred thirty four	seven hundred thirty five	seven hundred thirty six	seven hundred thirty seven	seven hundred thirty eight	seven hundred thirty nine
40		seven hundred forty	seven hundred forty one	seven hundred forty two	seven hundred forty three	seven hundred forty four	seven hundred forty five	seven hundred forty six	seven hundred forty seven	seven hundred forty eight	seven hundred forty nine	seven hundred fifty	seven hundred fifty one	seven hundred fifty two	seven hundred fifty three	seven hundred fifty four	seven hundred fifty five	seven hundred fifty six	seven hundred fifty seven	seven hundred fifty eight	seven hundred fifty nine
41		seven hundred sixty	seven hundred sixty one	seven hundred sixty two	seven hundred sixty three	seven hundred sixty four	seven hundred sixty five	seven hundred sixty six	seven hundred sixty seven	seven hundred sixty eight	seven hundred sixty nine	seven hundred seventy	seven hundred seventy one	seven hundred seventy two	seven hundred seventy three	seven hundred seventy four	seven hundred seventy five	seven hundred seventy six	seven hundred seventy seven	seven hundred seventy eight	seven hundred seventy nine
42		seven hundred eighty	seven hundred eighty one	seven hundred eighty two	seven hundred eighty three	seven hundred eighty four	seven hundred eighty five	seven hundred eighty six	seven hundred eighty seven	seven hundred eighty eight	seven hundred eighty nine	seven hundred ninety	seven hundred ninety one	seven hundred ninety two	seven hundred ninety three	seven hundred ninety four	seven hundred ninety five	seven hundred ninety six	seven hundred ninety seven	seven hundred ninety eight	seven hundred ninety nine
43		eight hundred	eight hundred one	eight hundred two	eight hundred three	eight hundred four	eight hundred five	eight hundred six	eight hundred seven	eight hundred eight	eight hundred nine	eight hundred ten	eight hundred eleven	eight hundred twelve	eight hundred thirteen	eight hundred fourteen	eight hundred fifteen	eight hundred sixteen	eight hundred seventeen	eight hundred eighteen	eight hundred nineteen
44		eight hundred twenty	eight hundred twenty one	eight hundred twenty two	eight hundred twenty three	eight hundred twenty four	eight hundred twenty five	eight hundred twenty six	eight hundred twenty seven	eight hundred twenty eight	eight hundred twenty nine	eight hundred thirty	eight hundred thirty one	eight hundred thirty two	eight hundred thirty three	eight hundred thirty four	eight hundred thirty five	eight hundred thirty six	eight hundred thirty seven	eight hundred thirty eight	eight hundred thirty nine
45		eight hundred forty	eight hundred forty one	eight hundred forty two	eight hundred forty three	eight hundred forty four	eight hundred forty five	eight hundred forty six	eight hundred forty seven	eight hundred forty eight	eight hundred forty nine	eight hundred fifty	eight hundred fifty one	eight hundred fifty two	eight hundred fifty three	eight hundred fifty four	eight hundred fifty five	eight hundred fifty six	eight hundred fifty seven	eight hundred fifty eight	eight hundred fifty nine
46		eight hundred sixty	eight hundred sixty one	eight hundred sixty two	eight hundred sixty three	eight hundred sixty four	eight hundred sixty five	eight hundred sixty six	eight hundred sixty seven	eight hundred sixty eight	eight hundred sixty nine	eight hundred seventy	eight hundred seventy one	eight hundred seventy two	eight hundred seventy three	eight hundred seventy four	eight hundred seventy five	eight hundred seventy six	eight hundred seventy seven	eight hundred seventy eight	eight hundred seventy nine
47		eight hundred eighty	eight hundred eighty one	eight hundred eighty two	eight hundred eighty three	eight hundred eighty four	eight hundred eighty five	eight hundred eighty six	eight hundred eighty seven	eight hundred eighty eight	eight hundred eighty nine	eight hundred ninety	eight hundred ninety one	eight hundred ninety two	eight hundred ninety three	eight hundred ninety four	eight hundred ninety five	eight hundred ninety six	eight hundred ninety seven	eight hundred ninety eight	eight hundred ninety nine
48		nine hundred	nine hundred one	nine hundred two	nine hundred three	nine hundred four	nine hundred five	nine hundred six	nine hundred seven	nine hundred eight	nine hundred nine	nine hundred ten	nine hundred eleven	nine hundred twelve	nine hundred thirteen	nine hundred fourteen	nine hundred fifteen	nine hundred sixteen	nine hundred seventeen	nine hundred eighteen	nine hundred nineteen
49		nine hundred twenty	nine hundred twenty one	nine hundred twenty two	nine hundred twenty three	nine hundred twenty four	nine hundred twenty five	nine hundred twenty six	nine hundred twenty seven	nine hundred twenty eight	nine hundred twenty nine	nine hundred thirty	nine hundred thirty one	nine hundred thirty two	nine hundred thirty three	nine hundred thirty four	nine hundred thirty five	nine hundred thirty six	nine hundred thirty seven	nine hundred thirty eight	nine hundred thirty nine
50		nine hundred forty	nine hundred forty one	nine hundred forty two	nine hundred forty three	nine hundred forty four	nine hundred forty five	nine hundred forty six	nine hundred forty seven	nine hundred forty eight	nine hundred forty nine	nine hundred fifty	nine hundred fifty one	nine hundred fifty two	nine hundred fifty three	nine hundred fifty four	nine hundred fifty five	nine hundred fifty six	nine hundred fifty seven	nine hundred fifty eight	nine hundred fifty nine
51		nine hundred sixty	nine hundred sixty one	nine hundred sixty two	nine hundred sixty three	nine hundred sixty four	nine hundred sixty five	nine hundred sixty six	nine hundred sixty seven	nine hundred sixty eight	nine hundred sixty nine	nine hundred seventy	nine hundred seventy one	nine hundred seventy two	nine hundred seventy three	nine hundred seventy four	nine hundred seventy five	nine hundred seventy six	nine hundred seventy seven	nine hundred seventy eight	nine hundred seventy nine
52		nine hundred eighty	nine hundred eighty one	nine hundred eighty two	nine hundred eighty three	nine hundred eighty four	nine hundred eighty five	nine hundred eighty six	nine hundred eighty seven	nine hundred eighty eight	nine hundred eighty nine	nine hundred ninety	nine hundred ninety one	nine hundred ninety two	nine hundred ninety three	nine hundred ninety four	nine hundred ninety five	nine hundred ninety six	nine hundred ninety seven	nine hundred ninety eight	nine hundred ninety nine
53
Sheet3

Cell Formulas
Range	Formula
B2	B2	=FORMULATEXT(B3)
B3:U52	B3	=SH(SEQUENCE(50,20)-1)
Dynamic array formulas.