ABCDEFGHIJKLMNOPQRSTUVWXYZ
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 Maxhello max
7
Hello Liuhello liu
8
Goood day, everybodyGoood 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