Corrections

	A	B	E	G	H	K	N	P	Q	R	S	T	W	X	Y	Z
1	Wrong	Right	Paste List Below	Corrected List	Corrected Data	Corrected List 2 (Newly Updated)		1) It gets split like this then vlookup() 2) The "♦" is where the spaces(" ") are and will be converted back into spaces(" ") later on since there is a delimiter of spaces(" ") used
2	ke	KE	J4ke aaa	J4ke aaa		Jake aba	♥J4ke♥♦♦♥aaa♥		J4ke	♦♦	aaa		Jake	♦♦	aba
3	J0hn	John	J0hn	John	X	John	♥J0hn♥		J0hn				John
4	Baech	Beach	Baech	Beach	X	Beach	♥Baech♥		Baech				Beach
5	Eleagnus	Elaeagnus	aaa	aba	X	aba	♥aaa♥		aaa				aba
6	Saacharinum	Saccharinum	J0hn	John	X	John	♥J0hn♥		J0hn				John
7	www	WWW	Baech qwwwq ewrewr	Baech qwwwq ewrewr		Beach QwwwQ ewrewr	♥Baech♥♦♥qwwwq♥♦ewrewr		Baech	♦	qwwwq	♦ewrewr	Beach	♦	QwwwQ	♦ewrewr
8	qwwwq	QwwwQ	bbb	bbb		bbb
9	j4ke	Jake	CCC	CCC		CCC
10	aaa	aba	ddd	ddd		ddd
11			EEE	EEE		EEE
12
13			AAA	aba	X	aba	♥AAA♥		AAA				aba
14
15			AAAB	AAAB		abaB	♥AAA♥B		AAA	B			aba	B
16			Baech Baech	Baech Baech		Beach Beach	♥Baech♥♦♥Baech♥		Baech	♦	Baech		Beach	♦	Beach
17
18			Elaeagnus	Elaeagnus		Elaeagnus
19
20			Eleagnus J0hn	Eleagnus J0hn		Elaeagnus John	♥Eleagnus♥♦♥J0hn♥		Eleagnus	♦	J0hn		Elaeagnus	♦	John
21
22
23			Saacharinum	Saccharinum	X	Saccharinum	♥Saacharinum♥		Saacharinum				Saccharinum
24
25			Saccharinum	Saccharinum		Saccharinum
26
27			Eleagnus	Elaeagnus	X	Elaeagnus	♥Eleagnus♥		Eleagnus				Elaeagnus
28
29
30			Saacharinum	Saccharinum	X	Saccharinum	♥Saacharinum♥		Saacharinum				Saccharinum
31
32			ke	KE		KE	♥ke♥		ke				KE
33
34	={"Corrected List 2";ArrayFormula(IF(LEN(TRIM(TRANSPOSE(QUERY(TRANSPOSE(IF(REGEXMATCH(E2:E,"("&TEXTJOIN("\|",1,FILTER("(?i)"&A2:A,LEN(A2:A)))&")"),REGEXREPLACE(E2:E,"("&TEXTJOIN("\|",1,FILTER("(?i)"&A2:A,LEN(A2:A)))&")","♥$1♥"),)),,1E+100)))),SUBSTITUTE(SUBSTITUTE(TRIM(TRANSPOSE(QUERY(TRANSPOSE(IFERROR(VLOOKUP(IFERROR(SPLIT(TRIM(TRANSPOSE(QUERY(TRANSPOSE(IF(REGEXMATCH(E2:E,"("&TEXTJOIN("\|",1,FILTER("(?i)"&A2:A,LEN(A2:A)))&")"),SUBSTITUTE(REGEXREPLACE(E2:E,"("&TEXTJOIN("\|",1,FILTER("(?i)"&A2:A,LEN(A2:A)))&")","♥$1♥")," ","♦"),)),,1E+100))),"♥",0,0)),{A2:A,B2:B},2,0),IFERROR(SPLIT(TRIM(TRANSPOSE(QUERY(TRANSPOSE(IF(REGEXMATCH(E2:E,"("&TEXTJOIN("\|",1,FILTER("(?i)"&A2:A,LEN(A2:A)))&")"),SUBSTITUTE(REGEXREPLACE(E2:E,"("&TEXTJOIN("\|",1,FILTER("(?i)"&A2:A,LEN(A2:A)))&")","♥$1♥")," ","♦"),)),,1E+100))),"♥",0,0)))),,1E+100)))," ",""),"♦"," "),E2:E))}
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