Multi Substitution
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGH
1
TextExpectedby APLCustom functionShould work if there is guaranteed only one valid match?Same as col E, as an array formulaCustom function by Kishan
2
aaa0200000
3
red2dog
22222
4
dog
perrodog
dog
dog
dog
perro
5
homecasahomehomehomehomecasa
6
Red1a232221a
7
Black220BlackBlack010122
8
White123ca02WhiteWhite0202123ca
9
adddaaaaaaazaaazaaazaaadddaaaaaa
10
dogperrodogdogdogdogperro
11
homecasahomehomehomehomecasa
12
the home of the dog"dragon & gas" hellothe home of the dogthe home of the dogthe home of the dog"dragon & gas" hello
13
4 ØsterÃ¥gadeaeiou4 Østerågadethe home of the dog4 ØsterÃ¥gade4 ØsterÃ¥gadeaeiou
14
123123
15
11001100
16
1652AAA1652
17
dog
dog
18
homeaaahome
19
22
20
BlackBlack
21
WhiteWhite
22
azaaazaa
23
dogdog
24
homehome
25
the home of the dogthe home of the dog
26
4 Østerågade4 Østerågade
27
123123
28
ger den nn swe and 0110GE den nn swe and 0GEGE GEdGEeGEnGE GEnGEnGE GEGE GEaGEnGEdGE GE0GE110
29
ger den nn swe and 1165#NAME?GEGE GEdGEeGEnGE GEnGEnGE GEGE GEaGEnGEdGE GE1GEGEGE GEdGEeGEnGE GEnGEnGE GEGE GEaGEnGEdGE GE1GE165
30
145145145
31
3232
32
33
32#NAME?32
34
11214=6&entry.1975707177=6&entry.742827012=6&entry.632681597=6&entry.1565772396=6&entry#NAME?11214=6&entry.1975707177=6&entry.742827012=6&entry.632681597=6&entry.1565772396=6&entry
35
36
37
38
39
40
41
ger den nn swe and 0ger den nn swe and 0
42
ger den nn swe and 1ger den nn swe and 1
43
145145
44
3232
45
46
3232
47
11214=6&entry.1975707177=6&entry.742827012=6&entry.632681597=6&entry.1565772396=6&entry11214=6&entry.1975707177=6&entry.742827012=6&entry.632681597=6&entry.1565772396=6&entry
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
Loading...