Trim Class , Distance , Stakes .

[Sunline]

Hello all ,

I am wanting to get some functions that can give me the results I have in cols B C and D

The asterix * must also appear in the results if mentioned in col A .

Many thanks .

Excel Workbook
	A	B	C	D
1	Col A	Class	Dist	Stakes
2	WFA 1600m - $200,000	WFA	1600	200000
3	OPN HCP 2000m - $40,000	OPN HCP	2000	40000
4	Rating 85 Benchmark 1400m - $8,000	Rating 85 Benchmark	1400	8000
5	Rating 65 Benchmark* 2200m - $30,000	Rating 65 Benchmark*	2200	30000
6	SP COND 1300m - $150,000	SP COND	1300	150000
7	3YOF SW 1200m - $70,000	3YOF SW	1200	70000
8	MDN 1400m - $30,000	MDN	1400	30000
9	OPN HCP 2500m - $2,500,000	OPN HCP	2500	2500000
10	Rating 65 Benchmark Fillies and Mares* 1400m - $7,000	Rating 65 Benchmark Fillies and Mares*	1400	7000
Sheet1

 

[Momentman]

Try

Excel 2010
	A	B	C	D
2	WFA 1600m - $200,000	WFA	1600	200000
3	OPN HCP 2000m - $40,000	OPN HCP	2000	40000
4	Rating 85 Benchmark 1400m - $8,000	Rating 85 Benchmark	1400	8000
5	Rating 65 Benchmark* 2200m - $30,000	Rating 65 Benchmark*	2200	30000
6	SP COND 1300m - $150,000	SP COND	1300	150000
7	3YOF SW 1200m - $70,000	3YOF SW	1200	70000
8	MDN 1400m - $30,000	MDN	1400	30000
9	OPN HCP 2500m - $2,500,000	OPN HCP	2500	2500000
10	Rating 65 Benchmark Fillies and Mares* 1400m - $7,000	Rating 65 Benchmark Fillies and Mares*	1400	7000
Sheet3

Cell Formulas
Range	Formula
B2	=LEFT(A2,FIND(C2&"m",A2)-2)
C2	=TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",99)),FIND("m ",SUBSTITUTE(A2," ",REPT(" ",99)))-99,99))+0
D2	=SUBSTITUTE(MID(A2,FIND("m - ",A2)+3,99),"$","")+0

 

[Sunline]

Perfect again Momentman , 100% .
Exactly what i needed .
Thanks .

 

[Momentman]

You are welcome