🦔 RegEx Do

	B	D	E	F	G	J
1	RegexDo					👀More formulas!
2
3	Does your Lambda with text if text mathces RegEx	(?i)hell
4				lower
5		Hello World!	→	hello world!	=INDEX(REGEXDO(D5:D10,D3,LAMBDA(x,LOWER(x))))
6		Hello Max	→	hello max
7		Hello Liu		hello liu
8		Goood day, everybody		Goood day, everybody
9		Augh no!		Augh no!
10		Say hello!		say hello!
11
12				upper
13			→	HELLO WORLD!	=INDEX(REGEXDO(D5:D10,D3,LAMBDA(x,UPPER(x))))
14			→	HELLO MAX
15				HELLO LIU
16				Goood day, everybody
17				Augh no!
18				SAY HELLO!
19
20				add text
21			→	👋🏼Hello World!	=INDEX(REGEXDO(D5:D10,D3,LAMBDA(x,"👋🏼" & x)))
22			→	👋🏼Hello Max
23				👋🏼Hello Liu
24				Goood day, everybody
25				Augh no!
26				👋🏼Say hello!
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