Retrieve class and stakes from data .

[Sunline]

Hello all ,

Im wanting to get a function that can get the results I have in cols B and C from
the data in col A .

I already have functions to get the 1400m and F1 as in cell A2 etc .

Thanks .

Excel Workbook
	A	B	C
1	Data	Class	Stakes
2	Mdn 3yo $6K 1400m F1	Mdn 3yo	$6K
3	OPN HCP C/WGT 1000 S	OPN HCP C/WGT
4	HCP $58K 1110m G	HCP	$58K
5	GRAZIA STYLE $177K 1100m G	GRAZIA STYLE	$177K
6	0 - 91 $80K 1200m G	0 - 91	$80K
7	Rating 70 SW+P $10K 1400m G3	Rating 70 SW+P	$10K
8	MDN 2YO C/WGT 450 D	MDN 2YO C/WGT
9	OPN HCP $100K 1400m H10	OPN HCP	$100K
10	Mdn & JMP HWT $6K 2100m G2	Mdn & JMP HWT	$6K
Sheet1

 

[mjbeam]

Try this for column B:

=IF(ISERR(FIND(" $",A2)),LEFT(A2,FIND(" C/WGT ",A2)+5),LEFT(A2,FIND(" $",A2)-1))

and this for column C:

=IF(ISERR(FIND(" $",A2)),"",MID(A2,FIND(" $",A2)+1,FIND(" ",A2,FIND(" $",A2)+2)-(FIND(" $",A2)+1)))

 

[Sunline]

Thanks mjbeam , they both work great .

Can I push my limits here and ask for a function to get from the data in col A here .

Mostly all left of the word "of" in col A , except row 6 .

Thanks again .

Excel Workbook
	A	B
1	Data	Result from data
2	17 days 2nd up 11 of 13	11
3	14 days 6th up F of 12	F
4	u/p of 8	u/p
5	13 days 4th up 1st of 9	1
6	28 days 5th up 4th	4
7	2 of 7	2
8	154 days 1st up 10th of 12	10
9	9 days 14th up L of 7	L
10	1st of 13	1
11	29 days 3rd up 8 of 0	8
Sheet1