🦋Substitutes

	A	B	C	E	F	H	J	K	M	O	P	S	T	V	W	Y	AD	AE	AF	AG	AI	AM	AO	AP	AQ	AR	AT	AV
1	Made for 💡CoolTables.Onine Collection of Formulas										Substitutes_Re					Substitutes						Substitutes_Re2						Substitutes2

2										SUBSTITUTES_RE - Definition	=SUBSTITUTES_RE(C5:C,E5:E8,F5:F8)					=SUBSTITUTES(T5:T,V5:V,W5:W)						=SUBSTITUTES_RE2(AE5:AE,AF5:AF,AG5:AG,AI5)						=SUBSTITUTES2(AP5:AP,AQ5:AQ,AR5:AR,AT5)
3										=LAMBDA(data,re,with,BYROW(data,LAMBDA(r,if(r="","",REDUCE(r,SEQUENCE(counta(re)),LAMBDA(ini,v,REGEXREPLACE(ini,INDEX(re,v),INDEX(with,v))))))))(C5:C6,E5:E7,F5:F7)
4			List of Values	RegEx Replace	With					Hello 🌎<b>World</b>	Greetings 🌎<b>World</b>		List of Values	Substitute	With	b & a		List of Values	RegEx Replace	With	Delimiter	This is a ⛵ trip		List of Values	Replace	With	Delimiter	This is a ⛵ trip
5		1	Hello World	\b(World)\b	🌎<b>$1</b>	Step 1		Step 2	Step 3	Hello 🔵Max, 🟣Liu, 🟣Ann!	Greetings 🔵Max, 🟣Liu, 🟣Ann!	1	Beth & Ann	Beth	b	d and f	1	This is a boat trip	\bboat\b	⛵	🦋	I love 🚗s & 🛩️s	1	This is a boat trip	boat	⛵	🦋	I love 🚗s & 🛩️s
6		2	Hello Max, Liu, Ann!	\b(Max\|Sam\|Ray)\b	🔵$1	#1 Regex Method		Reduce	ByRow		Greetings 🔵Ray!	2	Diana and Fred	Diana	d	g, h, i	2	I love cars & planes	\bcar🦋\bplane	🚗🦋🛩️		I love 🛩️s & ⛵s	2	I love cars & planes	car🦋plane	🚗🦋🛩️		I love 🛩️s & ⛵s
7		3	Hello Ray!	\b(Liu\|Ann)\b	🟣$1	Hello Max, 🟣Liu, 🟣Ann!	1	Hello 🌎<b>World</b>	Hello 🌎<b>World</b>		Greetings 🟣Liu!	3	George, Henry, Iren	Fred	f	j+k, l+m	3	I love planes & boats	\bplane🦋\bboat	🛩️🦋⛵		I love ⛵boats & 🚗cars	3	I love planes & boats	plane🦋boat	🛩️🦋⛵		I love ⛵s & 🚗s
8		4	Hello Liu!	\b(Hello)\b	Greetings		2		Hello 🔵Max, 🟣Liu, 🟣Ann!		Greetings 🔵Sam, 🟣Ann!	4	Jake+Kate, Liu+Max	George	g	n & p	4	I love boats & cars	\b(car)🦋\b(boat)	🚗$1🦋⛵$1			4	I love boats & cars	car🦋boat	🚗🦋⛵
9		5	Hello Sam, Ann!				3				Greetings 🔵Ray!	5	Nata & Peter	Henry	h	ho ho ho
10		6	Hello Ray!								Greetings 🟣Ann, 🔵Ray!	6	ho ho ho	Iren	i	s + a
11		7	Hello Ann, Ray!									7	Sam + Ann	Jake	j
12														Kate	k
13														Liu	l
14														Max	m
15														Nata	n
16														Peter	p
17														Sam	s
18														Ann	a
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100