examples-of-using-search-function.xlsx

	A	B	C	D	E	F
1	Text	Search	Result		Detailed description of the function:
2	Excel	X	2		https://exceltable.com/en/excel-functions/examples-of-using-search-function
3	Exceltable	Excel	1
4	Excel table	table	7
5
6
7	Text	Search	Result
8	Code: ОТРК	о	7
9
10
11	Text	Vendor code	letter part
12	Wineglass	K_76548	K
13	Plate	М_6523	М
14	Table	ABCDE_81230	ABCDE
15	Player	NMB_12189	NMB
16	TV	AZ_56457	AZ
17
18
19	Text	Vendor code	LEN	SEARCH	LEN-SEARCH	Numerical value
20	Wineglass	KLF_76548	9	4	5	76548
21	Plate	HGTF_6523	9	5	4	6523
22	Table	GD_81230	8	3	5	81230
23	Player	NMB_12189	9	4	5	12189
24	TV	AZ_56457	8	3	5	56457
25
26
27
28	Good	Vendor code	Numerical value
29	Wineglass	KLF_76548	76548
30	Plate	HGTF_6523	6523
31	Table	GD_81230	81230
32	Player	NMB_12189	12189
33	TV	AZ_56457	56457
34
35
36	Adress	Local
37	Cambridge CB2 1TJ	Local
38	65 The Close, Norwich NR1 4DH	Far
39	CHURCH St, Wymomdham NR18 0PH	Far
40	Hills Rd, Cambridge CB2 1JR	Local
41	Duke Street, Chelmsford CM1 1EH	Far
42	Quy Rd, Lode, Cambridge cb25 9ej	Local
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