How can i extract a variable number of characters from the rhs and keep the result as a string?

[JeffGrant]

Hi All, I have csv files that look like this.

GetAllScratchingsText.csv
	A
1	Auto Scratchings File
2	Scr,210710awapuni01,H,7,
3	Scr,210710awapuni02,H,
4	Scr,210710awapuni03,H,
5	Scr,210710awapuni04,H,
6	Scr,210710awapuni05,H,5,
7	Scr,210710awapuni06,H,1,
8	Scr,210710awapuni07,H,15,16,
9	Scr,210710awapuni08,H,
10	Scr,210710awapuni09,H,
11	Scr,210710awapuni10,H,
12	Scr,210710awapuni11,H,
13	Scr,210710awapuni12,H,
14	Scr,210711ballarat01,H,6,7,9,
15	Scr,210711ballarat02,H,2,
16	Scr,210711ballarat03,H,
17	Scr,210711ballarat04,H,7,
18	Scr,210711ballarat05,H,
19	Scr,210711ballarat06,H,
20	Scr,210711ballarat07,H,
21	Scr,210711ballarat08,H,
22	Scr,210711ballarat09,H,
23	Scr,210711ballarat10,H,
24	Scr,210711ballarat11,H,
25	Scr,210711ballarat12,H,
26	Scr,210711ballarat synthetic01,H,6,7,9,
27	Scr,210711ballarat synthetic02,H,2,
28	Scr,210711ballarat synthetic03,H,
29	Scr,210711ballarat synthetic04,H,7,
30	Scr,210711ballarat synthetic05,H,
31	Scr,210711ballarat synthetic06,H,
32	Scr,210711ballarat synthetic07,H,
33	Scr,210711ballarat synthetic08,H,
34	Scr,210711ballarat synthetic09,H,
35	Scr,210711ballarat synthetic10,H,
36	Scr,210711ballarat synthetic11,H,
37	Scr,210711ballarat synthetic12,H,
38	Scr,210713ballina01,H,
39	Scr,210713ballina02,H,7,
40	Scr,210713ballina03,H,
41	Scr,210713ballina04,H,12,
42	Scr,210713ballina05,H,
43	Scr,210713ballina06,H,7,
44	Scr,210713ballina07,H,
45	Scr,210713ballina08,H,
46	Scr,210713ballina09,H,
47	Scr,210713ballina10,H,
48	Scr,210713ballina11,H,
49	Scr,210713ballina12,H,
50	Scr,210710beaudesert01,H,
51	Scr,210710beaudesert02,H,5,12,
52	Scr,210710beaudesert03,H,6,
53	Scr,210710beaudesert04,H,1,
54	Scr,210710beaudesert05,H,7,9,
55	Scr,210710beaudesert06,H,4,
56	Scr,210710beaudesert07,H,7,11,
57	Scr,210710beaudesert08,H,3,13,
58	Scr,210710beaudesert09,H,
59	Scr,210710beaudesert10,H,
60	Scr,210710beaudesert11,H,
61	Scr,210710beaudesert12,H,
62	Scr,210710beaumont01,D,1,
63	Scr,210710beaumont02,D,
64	Scr,210710beaumont03,D,1,
65	Scr,210710beaumont04,D,12,
66	Scr,210710beaumont05,D,3,4,6,
67	Scr,210710beaumont06,D,
68	Scr,210710beaumont07,D,
69	Scr,210710beaumont08,D,11,
70	Scr,210710beaumont09,D,
71	Scr,210710beaumont10,D,
72	Scr,210710beaumont11,D,
73	Scr,210710beaumont12,D,
74	Scr,210710belmont01,S,
75	Scr,210710belmont02,S,7,13,
76	Scr,210710belmont03,S,
77	Scr,210710belmont04,S,
78	Scr,210710belmont05,S,
79	Scr,210710belmont06,S,
80	Scr,210710belmont07,S,
81	Scr,210710belmont08,S,
82	Scr,210710belmont09,S,2,17,
83	Scr,210710belmont10,S,10,18,
84	Scr,210710belmont11,S,
85	Scr,210710belmont12,S,
86	Scr,210710belmont park01,S,
87	Scr,210710belmont park02,S,7,13,
88	Scr,210710belmont park03,S,
89	Scr,210710belmont park04,S,
90	Scr,210710belmont park05,S,
91	Scr,210710belmont park06,S,
92	Scr,210710belmont park07,S,
93	Scr,210710belmont park08,S,
94	Scr,210710belmont park09,S,2,17,
95	Scr,210710belmont park10,S,10,18,
96	Scr,210710belmont park11,S,
97	Scr,210710belmont park12,S,
98	Scr,210710broome01,G,
99	Scr,210710broome02,G,
100	Scr,210710broome03,G,
101	Scr,210710broome04,G,
102	Scr,210710broome05,G,
103	Scr,210710broome06,G,1,
104	Scr,210710broome07,G,
105	Scr,210710broome08,G,
106	Scr,210710broome09,G,
107	Scr,210710broome10,G,
108	Scr,210710broome11,G,
109	Scr,210710broome12,G,
110	Scr,210710caulfield01,D,1,8,
111	Scr,210710caulfield02,D,10,
112	Scr,210710caulfield03,D,2,11,
113	Scr,210710caulfield04,D,2,5,11,12,
114	Scr,210710caulfield05,D,5,10,11,12,
115	Scr,210710caulfield06,D,
116	Scr,210710caulfield07,D,1,5,
117	Scr,210710caulfield08,D,
118	Scr,210710caulfield09,D,11,20,
119	Scr,210710caulfield10,D,
120	Scr,210710caulfield11,D,
121	Scr,210710caulfield12,D,
122	Scr,210710cowra01,S,12,
123	Scr,210710cowra02,S,
124	Scr,210710cowra03,S,8,9,
125	Scr,210710cowra04,S,10,
126	Scr,210710cowra05,S,
127	Scr,210710cowra06,S,7,8,
128	Scr,210710cowra07,S,
129	Scr,210710cowra08,S,
130	Scr,210710cowra09,S,
131	Scr,210710cowra10,S,
132	Scr,210710cowra11,S,
133	Scr,210710cowra12,S,
134	Scr,210710darwin01,G,
135	Scr,210710darwin02,G,
136	Scr,210710darwin03,G,
137	Scr,210710darwin04,G,
138	Scr,210710darwin05,G,
139	Scr,210710darwin06,G,11,
140	Scr,210710darwin07,G,
141	Scr,210710darwin08,G,
142	Scr,210710darwin09,G,
143	Scr,210710darwin10,G,
144	Scr,210710darwin11,G,
145	Scr,210710darwin12,G,
146	Scr,210711devonport synthetic01,G,6,
147	Scr,210711devonport synthetic02,G,
148	Scr,210711devonport synthetic03,G,5,
149	Scr,210711devonport synthetic04,G,
150	Scr,210711devonport synthetic05,G,
151	Scr,210711devonport synthetic06,G,
152	Scr,210711devonport synthetic07,G,
153	Scr,210711devonport synthetic08,G,
154	Scr,210711devonport synthetic09,G,2,
155	Scr,210711devonport synthetic10,G,
156	Scr,210711devonport synthetic11,G,
157	Scr,210711devonport synthetic12,G,
158	Scr,210710doomben01,S,
159	Scr,210710doomben02,S,3,5,11,
160	Scr,210710doomben03,S,4,5,9,10,14,
161	Scr,210710doomben04,S,1,4,7,10,
162	Scr,210710doomben05,S,2,10,13,14,17,19,
163	Scr,210710doomben06,S,
164	Scr,210710doomben07,S,9,12,15,
165	Scr,210710doomben08,S,6,12,
166	Scr,210710doomben09,S,10,
167	Scr,210710doomben10,S,
168	Scr,210710doomben11,S,
169	Scr,210710doomben12,S,
170	Scr,210710esk01,D,
171	Scr,210710esk02,D,3,
172	Scr,210710esk03,D,
173	Scr,210710esk04,D,
174	Scr,210710esk05,D,
175	Scr,210710esk06,D,3,5,
176	Scr,210710esk07,D,4,10,13,14,
177	Scr,210710esk08,D,1,3,14,
178	Scr,210710esk09,D,
179	Scr,210710esk10,D,
180	Scr,210710esk11,D,
181	Scr,210710esk12,D,
182	Scr,210710fannie bay01,G,
183	Scr,210710fannie bay02,G,
184	Scr,210710fannie bay03,G,
185	Scr,210710fannie bay04,G,
186	Scr,210710fannie bay05,G,
187	Scr,210710fannie bay06,G,11,
188	Scr,210710fannie bay07,G,
189	Scr,210710fannie bay08,G,
190	Scr,210710fannie bay09,G,
191	Scr,210710fannie bay10,G,
192	Scr,210710fannie bay11,G,
193	Scr,210710fannie bay12,G,
194	Scr,210710gawler01,D,8,
195	Scr,210710gawler02,D,1,14,
196	Scr,210710gawler03,D,
197	Scr,210710gawler04,D,6,
198	Scr,210710gawler05,D,3,9,12,
199	Scr,210710gawler06,D,
200	Scr,210710gawler07,D,1,
201	Scr,210710gawler08,D,4,7,8,12,
202	Scr,210710gawler09,D,2,4,
203	Scr,210710gawler10,D,
204	Scr,210710gawler11,D,
205	Scr,210710gawler12,D,
206	Scr,210709goulburn01,S,3,7,
207	Scr,210709goulburn02,S,7,11,
208	Scr,210709goulburn03,S,5,11,
209	Scr,210709goulburn04,S,3,11,
210	Scr,210709goulburn05,S,10,12,
211	Scr,210709goulburn06,S,1,4,11,
212	Scr,210709goulburn07,S,1,3,11,13,
213	Scr,210709goulburn08,S,5,6,8,10,11,13,15,17,
214	Scr,210709goulburn09,S,
215	Scr,210709goulburn10,S,
216	Scr,210709goulburn11,S,
217	Scr,210709goulburn12,S,
218	Scr,210711grafton01,S,
219	Scr,210711grafton02,S,10,13,
220	Scr,210711grafton03,S,8,
221	Scr,210711grafton04,S,
222	Scr,210711grafton05,S,1,2,
223	Scr,210711grafton06,S,1,
224	Scr,210711grafton07,S,
225	Scr,210711grafton08,S,7,17,
226	Scr,210711grafton09,S,
227	Scr,210711grafton10,S,
228	Scr,210711grafton11,S,
229	Scr,210711grafton12,S,
230	Scr,210711hawkesbury01,S,6,
231	Scr,210711hawkesbury02,S,
232	Scr,210711hawkesbury03,S,4,
233	Scr,210711hawkesbury04,S,
234	Scr,210711hawkesbury05,S,
235	Scr,210711hawkesbury06,S,
236	Scr,210711hawkesbury07,S,
237	Scr,210711hawkesbury08,S,5,17,18,19,
238	Scr,210711hawkesbury09,S,
239	Scr,210711hawkesbury10,S,
240	Scr,210711hawkesbury11,S,
241	Scr,210711hawkesbury12,S,
242	Scr,210710home hill01,D,
243	Scr,210710home hill02,D,7,
244	Scr,210710home hill03,D,
245	Scr,210710home hill04,D,
246	Scr,210710home hill05,D,
247	Scr,210710home hill06,D,
248	Scr,210710home hill07,D,
249	Scr,210710home hill08,D,
250	Scr,210710home hill09,D,
251	Scr,210710home hill10,D,
252	Scr,210710home hill11,D,
253	Scr,210710home hill12,D,
254	Scr,210712moruya01,S,
255	Scr,210712moruya02,S,
256	Scr,210712moruya03,S,
257	Scr,210712moruya04,S,10,
258	Scr,210712moruya05,S,
259	Scr,210712moruya06,S,
260	Scr,210712moruya07,S,
261	Scr,210712moruya08,S,
262	Scr,210712moruya09,S,
263	Scr,210712moruya10,S,
264	Scr,210712moruya11,S,
265	Scr,210712moruya12,S,
266	Scr,210710mount isa01,G,
267	Scr,210710mount isa02,G,5,
268	Scr,210710mount isa03,G,
269	Scr,210710mount isa04,G,
270	Scr,210710mount isa05,G,
271	Scr,210710mount isa06,G,
272	Scr,210710mount isa07,G,
273	Scr,210710mount isa08,G,
274	Scr,210710mount isa09,G,
275	Scr,210710mount isa10,G,
276	Scr,210710mount isa11,G,
277	Scr,210710mount isa12,G,
278	Scr,210710newcastle01,D,1,
279	Scr,210710newcastle02,D,
280	Scr,210710newcastle03,D,1,
281	Scr,210710newcastle04,D,12,
282	Scr,210710newcastle05,D,3,4,6,
283	Scr,210710newcastle06,D,
284	Scr,210710newcastle07,D,
285	Scr,210710newcastle08,D,11,
286	Scr,210710newcastle09,D,
287	Scr,210710newcastle10,D,
288	Scr,210710newcastle11,D,
289	Scr,210710newcastle12,D,
290	Scr,210710racing.com park syn01,G,
291	Scr,210710racing.com park syn02,G,1,10,
292	Scr,210710racing.com park syn03,G,1,5,8,11,14,
293	Scr,210710racing.com park syn04,G,
294	Scr,210710racing.com park syn05,G,
295	Scr,210710racing.com park syn06,G,9,
296	Scr,210710racing.com park syn07,G,
297	Scr,210710racing.com park syn08,G,
298	Scr,210710racing.com park syn09,G,
299	Scr,210710racing.com park syn10,G,
300	Scr,210710racing.com park syn11,G,
301	Scr,210710racing.com park syn12,G,
302	Scr,210710randwick01,S,3,6,14,
303	Scr,210710randwick02,S,
304	Scr,210710randwick03,S,7,13,17,
305	Scr,210710randwick04,S,
306	Scr,210710randwick05,S,5,
307	Scr,210710randwick06,S,5,8,
308	Scr,210710randwick07,S,
309	Scr,210710randwick08,S,10,
310	Scr,210710randwick09,S,6,15,
311	Scr,210710randwick10,S,6,10,15,
312	Scr,210710randwick11,S,
313	Scr,210710randwick12,S,
314	Scr,210710randwick-kensington01,S,3,6,14,
315	Scr,210710randwick-kensington02,S,
316	Scr,210710randwick-kensington03,S,7,13,17,
317	Scr,210710randwick-kensington04,S,
318	Scr,210710randwick-kensington05,S,5,
319	Scr,210710randwick-kensington06,S,8,
320	Scr,210710randwick-kensington07,S,
321	Scr,210710randwick-kensington08,S,10,
322	Scr,210710randwick-kensington09,S,6,15,
323	Scr,210710randwick-kensington10,S,6,10,15,
324	Scr,210710randwick-kensington11,S,
325	Scr,210710randwick-kensington12,S,
326	Scr,210709rockhampton01,D,4,12,
327	Scr,210709rockhampton02,D,6,7,9,
328	Scr,210709rockhampton03,D,3,
329	Scr,210709rockhampton04,D,3,
330	Scr,210709rockhampton05,D,5,
331	Scr,210709rockhampton06,D,4,
332	Scr,210709rockhampton07,D,9,13,15,
333	Scr,210709rockhampton08,D,3,4,13,
334	Scr,210709rockhampton09,D,
335	Scr,210709rockhampton10,D,
336	Scr,210709rockhampton11,D,
337	Scr,210709rockhampton12,D,
338	Scr,210710rockhampton01,D,5,6,8,
339	Scr,210710rockhampton02,D,3,
340	Scr,210710rockhampton03,D,1,
341	Scr,210710rockhampton04,D,1,
342	Scr,210710rockhampton05,D,3,14,
343	Scr,210710rockhampton06,D,2,5,8,
344	Scr,210710rockhampton07,D,
345	Scr,210710rockhampton08,D,2,7,12,
346	Scr,210710rockhampton09,D,
347	Scr,210710rockhampton10,D,
348	Scr,210710rockhampton11,D,
349	Scr,210710rockhampton12,D,
350	Scr,210710roebourne01,G,
351	Scr,210710roebourne02,G,
352	Scr,210710roebourne03,G,
353	Scr,210710roebourne04,G,
354	Scr,210710roebourne05,G,12,
355	Scr,210710roebourne06,G,
356	Scr,210710roebourne07,G,
357	Scr,210710roebourne08,G,
358	Scr,210710roebourne09,G,
359	Scr,210710roebourne10,G,
360	Scr,210710roebourne11,G,
361	Scr,210710roebourne12,G,
362	Scr,210709sale01,D,1,2,3,7,18,20,
363	Scr,210709sale02,D,5,6,7,10,11,15,
364	Scr,210709sale03,D,5,8,10,
365	Scr,210709sale04,D,2,5,8,9,12,14,15,16,18,19,
366	Scr,210709sale05,D,8,11,
367	Scr,210709sale06,D,7,8,11,12,
368	Scr,210709sale07,D,4,11,14,
369	Scr,210709sale08,D,9,12,14,16,17,18,19,20,
370	Scr,210709sale09,D,
371	Scr,210709sale10,D,
372	Scr,210709sale11,D,
373	Scr,210709sale12,D,
374	Scr,210709scone01,H,13,15,17,18,
375	Scr,210709scone02,H,1,5,8,12,14,18,20,
376	Scr,210709scone03,H,6,
377	Scr,210709scone04,H,3,4,16,
378	Scr,210709scone05,H,2,11,
379	Scr,210709scone06,H,10,11,
380	Scr,210709scone07,H,2,11,14,
381	Scr,210709scone08,H,7,8,10,17,19,20,
382	Scr,210709scone09,H,
383	Scr,210709scone10,H,
384	Scr,210709scone11,H,
385	Scr,210709scone12,H,
386	Scr,210711sunshine coast01,H,
387	Scr,210711sunshine coast02,H,
388	Scr,210711sunshine coast03,H,
389	Scr,210711sunshine coast04,H,7,
390	Scr,210711sunshine coast05,H,
391	Scr,210711sunshine coast06,H,
392	Scr,210711sunshine coast07,H,17,
393	Scr,210711sunshine coast08,H,
394	Scr,210711sunshine coast09,H,11,16,
395	Scr,210711sunshine coast10,H,
396	Scr,210711sunshine coast11,H,
397	Scr,210711sunshine coast12,H,
398	Scr,210713sunshine coast01,H,
399	Scr,210713sunshine coast02,H,5,7,
400	Scr,210713sunshine coast03,H,
401	Scr,210713sunshine coast04,H,
402	Scr,210713sunshine coast05,H,4,14,
403	Scr,210713sunshine coast06,H,4,13,
404	Scr,210713sunshine coast07,H,
405	Scr,210713sunshine coast08,H,
406	Scr,210713sunshine coast09,H,
407	Scr,210713sunshine coast10,H,
408	Scr,210713sunshine coast11,H,
409	Scr,210713sunshine coast12,H,
410	Scr,210711sunshine coast cushion01,H,
411	Scr,210711sunshine coast cushion02,H,
412	Scr,210711sunshine coast cushion03,H,
413	Scr,210711sunshine coast cushion04,H,7,
414	Scr,210711sunshine coast cushion05,H,
415	Scr,210711sunshine coast cushion06,H,
416	Scr,210711sunshine coast cushion07,H,17,
417	Scr,210711sunshine coast cushion08,H,
418	Scr,210711sunshine coast cushion09,H,11,16,
419	Scr,210711sunshine coast cushion10,H,
420	Scr,210711sunshine coast cushion11,H,
421	Scr,210711sunshine coast cushion12,H,
422	Scr,210713sunshine coast cushion01,H,
423	Scr,210713sunshine coast cushion02,H,5,7,
424	Scr,210713sunshine coast cushion03,H,
425	Scr,210713sunshine coast cushion04,H,
426	Scr,210713sunshine coast cushion05,H,4,14,
427	Scr,210713sunshine coast cushion06,H,4,13,
428	Scr,210713sunshine coast cushion07,H,
429	Scr,210713sunshine coast cushion08,H,
430	Scr,210713sunshine coast cushion09,H,
431	Scr,210713sunshine coast cushion10,H,
432	Scr,210713sunshine coast cushion11,H,
433	Scr,210713sunshine coast cushion12,H,
434	Scr,210711te aroha01,U,4,
435	Scr,210711te aroha02,U,8,
436	Scr,210711te aroha03,U,
437	Scr,210711te aroha04,U,5,
438	Scr,210711te aroha05,U,1,
439	Scr,210711te aroha06,U,8,
440	Scr,210711te aroha07,U,
441	Scr,210711te aroha08,U,6,
442	Scr,210711te aroha09,U,
443	Scr,210711te aroha10,U,
444	Scr,210711te aroha11,U,
445	Scr,210711te aroha12,U,
446	Scr,210710te rapa01,H,
447	Scr,210710te rapa02,H,
448	Scr,210710te rapa03,H,2,19,
449	Scr,210710te rapa04,H,
450	Scr,210710te rapa05,H,
451	Scr,210710te rapa06,H,
452	Scr,210710te rapa07,H,22,
453	Scr,210710te rapa08,H,19,
454	Scr,210710te rapa09,H,
455	Scr,210710te rapa10,H,
456	Scr,210710te rapa11,H,
457	Scr,210710te rapa12,H,
458	Scr,210710toowoomba01,S,
459	Scr,210710toowoomba02,S,21,
460	Scr,210710toowoomba03,S,11,13,
461	Scr,210710toowoomba04,S,1,3,
462	Scr,210710toowoomba05,S,4,
463	Scr,210710toowoomba06,S,
464	Scr,210710toowoomba07,S,6,9,
465	Scr,210710toowoomba08,S,4,13,
466	Scr,210710toowoomba09,S,
467	Scr,210710toowoomba10,S,
468	Scr,210710toowoomba11,S,
469	Scr,210710toowoomba12,S,
470	Scr,210710toowoomba cushion01,S,
471	Scr,210710toowoomba cushion02,S,21,
472	Scr,210710toowoomba cushion03,S,11,13,
473	Scr,210710toowoomba cushion04,S,1,3,
474	Scr,210710toowoomba cushion05,S,4,
475	Scr,210710toowoomba cushion06,S,
476	Scr,210710toowoomba cushion07,S,6,9,
477	Scr,210710toowoomba cushion08,S,4,13,
478	Scr,210710toowoomba cushion09,S,
479	Scr,210710toowoomba cushion10,S,
480	Scr,210710toowoomba cushion11,S,
481	Scr,210710toowoomba cushion12,S,
482	Scr,210710toowoomba cushion track01,S,
483	Scr,210710toowoomba cushion track02,S,21,
484	Scr,210710toowoomba cushion track03,S,11,13,
485	Scr,210710toowoomba cushion track04,S,1,3,
486	Scr,210710toowoomba cushion track05,S,4,
487	Scr,210710toowoomba cushion track06,S,
488	Scr,210710toowoomba cushion track07,S,6,9,
489	Scr,210710toowoomba cushion track08,S,4,13,
490	Scr,210710toowoomba cushion track09,S,
491	Scr,210710toowoomba cushion track10,S,
492	Scr,210710toowoomba cushion track11,S,
493	Scr,210710toowoomba cushion track12,S,
494	Scr,210709waverley01,H,
495	Scr,210709waverley02,H,
496	Scr,210709waverley03,H,
497	Scr,210709waverley04,H,15,16,17,18,19,20,
498	Scr,210709waverley05,H,5,
499	Scr,210709waverley06,H,13,16,17,18,19,20,
500	Scr,210709waverley07,H,4,13,14,15,16,
501	Scr,210709waverley08,H,13,14,15,16,
502	Scr,210709waverley09,H,13,14,15,16,17,18,
503	Scr,210709waverley10,H,10,14,15,16,17,18,
504	Scr,210709waverley11,H,
505	Scr,210709waverley12,H,
506	Scr,210711wodonga01,H,
507	Scr,210711wodonga02,H,9,
508	Scr,210711wodonga03,H,
509	Scr,210711wodonga04,H,2,13,
510	Scr,210711wodonga05,H,
511	Scr,210711wodonga06,H,5,
512	Scr,210711wodonga07,H,1,
513	Scr,210711wodonga08,H,
514	Scr,210711wodonga09,H,
515	Scr,210711wodonga10,H,
516	Scr,210711wodonga11,H,
517	Scr,210711wodonga12,H,
518	End
GetAllScratchingsText

What I need to be able to do is extract the characters from the RHS after the "H," or "S," or "G," or whatever letter, but I need to keep the result as string for later use.

So from "Scr,210710awapuni03,H," the result would be null, while from "Scr,210711ballarat01,H,6,7,9," the result would be 6,7,9 - without any leading or trailing commas.

I guess I could parse them into separate cells, then add them back to together later, but that just seems inefficient.

Any guidance would be great.

Thanks in advance

 

[Dermot]

try this for A2
=LEFT(MID(A2,FIND(",",A2,10)+3,99),LEN(MID(A2,FIND(",",A2,10)+3,99))-1)
if you didn't need to get rid of the trailing comma, it would be simpler
=MID(A2,FIND(",",A2,10)+3,99)

If you have Office 365, you could try
=LET(txt,MID(A2,FIND(",",A2,10)+3,99),LEFT(txt,LEN(txt)-1))

 

[Toadstool]

Hi JeffGrant,

As @Dermot says, that training comma makes it messy but here's my approach.

JeffGrant.xlsx
	A	B
1	Auto Scratchings File
2	Scr,210710awapuni01,H,7,	7
3	Scr,210710awapuni02,H,
4	Scr,210710awapuni03,H,
5	Scr,210710awapuni04,H,
6	Scr,210710awapuni05,H,5,	5
7	Scr,210710awapuni06,H,1,	1
8	Scr,210710awapuni07,H,15,16,	15,16
9	Scr,210710awapuni08,H,
10	Scr,210710awapuni09,H,
Sheet1

Cell Formulas
Range	Formula
B2:B10	B2	=SUBSTITUTE(LEFT(A2,LEN(A2)-1),LEFT(LEFT(A2,LEN(A2)-1),SEARCH(",",LEFT(A2,LEN(A2)-1),5)+2),"")

 

[JeffGrant]

Thanks Toadstool and Dermot. All three solutions work great and I am glad to see more than one way to solve this one. Because I have 365, I will use Dermot's 365 solution wrapped in an Iferror statement.

Have a good weekend.