Extract Data String

[kipper19]

Hi All.
Is it possible to extract the data from a string like these examples below, the data to be extracted is always after a number ie, 1 to 9 and always before the $ sign

11-Mar-23 2100m GOOD 4 R8 LR BUNBURY CUP $2, so in this example the data extracted would be LR BUNBURY CUP

29-Jul-23 1600m HEAVY 9 R7 RTG 66+ $43, this one would be RTG 66+

14-Jun-23 1650m SOFT 6 R1 2YO & 3YO 0MWLY $943 (of $32, this one would be 2YO & 3YO 0MWLY

 

[Phuoc]

Try this

Book1
	A	B
1	11-Mar-23 2100m GOOD 4 R8 LR BUNBURY CUP $2, so in this example the data extracted would be LR BUNBURY CUP	LR BUNBURY CUP
2	29-Jul-23 1600m HEAVY 9 R7 RTG 66+ $43, this one would be RTG 66+	RTG 66+
3	14-Jun-23 1650m SOFT 6 R1 2YO & 3YO 0MWLY $943 (of $32, this one would be 2YO & 3YO 0MWLY	2YO & 3YO 0MWLY
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=TRIM(LEFT(SUBSTITUTE(REPLACE(A1,1,AGGREGATE(14,6,SEARCH("R"&{1,2,3,4,5,6,7,8,9}&" ",A1),1)+2,""),"$",REPT(" ",500)),500))

 

[BrerRabbit]

Where B5 = 11-Mar-23 2100m GOOD 4 R8 LR BUNBURY CUP $2

MID(B5,FIND("R",B5,20)+3,(LEN(MID(B5,FIND("R",B5,20)+3,FIND("$",B5,15)))-(LEN(B5)-FIND("$",B5,15))-1))

 

[kipper19]

Try this

Book1
	A	B
1	11-Mar-23 2100m GOOD 4 R8 LR BUNBURY CUP $2, so in this example the data extracted would be LR BUNBURY CUP	LR BUNBURY CUP
2	29-Jul-23 1600m HEAVY 9 R7 RTG 66+ $43, this one would be RTG 66+	RTG 66+
3	14-Jun-23 1650m SOFT 6 R1 2YO & 3YO 0MWLY $943 (of $32, this one would be 2YO & 3YO 0MWLY	2YO & 3YO 0MWLY
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=TRIM(LEFT(SUBSTITUTE(REPLACE(A1,1,AGGREGATE(14,6,SEARCH("R"&{1,2,3,4,5,6,7,8,9}&" ",A1),1)+2,""),"$",REPT(" ",500)),500))

Thank You Phuoc, works well

 

[kipper19]

Where B5 = 11-Mar-23 2100m GOOD 4 R8 LR BUNBURY CUP $2

MID(B5,FIND("R",B5,20)+3,(LEN(MID(B5,FIND("R",B5,20)+3,FIND("$",B5,15)))-(LEN(B5)-FIND("$",B5,15))-1))

BrerRabbit - Your solution works as well, thank you

 

[Peter_SSs]

What about just this?

23 11 25.xlsm
	A	B
1	11-Mar-23 2100m GOOD 4 R8 LR BUNBURY CUP $2	LR BUNBURY CUP
2	29-Jul-23 1600m HEAVY 9 R7 RTG 66+ $43	RTG 66+
3	14-Jun-23 1650m SOFT 6 R1 2YO & 3YO 0MWLY $943	2YO & 3YO 0MWLY
Extract

Cell Formulas
Range	Formula
B1:B3	B1	=TEXTAFTER(TEXTBEFORE(A1," $")," R"&SEQUENCE(9)&" ")

 

[Peter_SSs]

Actually, based on your sample data, this even shorter one may be sufficient?

23 11 25.xlsm
	A	B
1	11-Mar-23 2100m GOOD 4 R8 LR BUNBURY CUP $2	LR BUNBURY CUP
2	29-Jul-23 1600m HEAVY 9 R7 RTG 66+ $43	RTG 66+
3	14-Jun-23 1650m SOFT 6 R1 2YO & 3YO 0MWLY $943	2YO & 3YO 0MWLY
Extract (2)

Cell Formulas
Range	Formula
B1:B3	B1	=TEXTAFTER(TEXTBEFORE(A1," $")," ",5)