Find number to right of cell .

[Sunline]

Hello all ,

I am just needing to get the number to the right of all data in col A .

I have supplied the first 15 results .

Thanks .

Excel Workbook
	A	B
1	Name	Result
2	Absolute Gem (R2)	2
3	Absolutely Sacred (AUS) (R13)	13
4	All About Fun (R9)	9
5	All Good Things (R11)	11
6	All The Way (R6)	6
7	All Zedin Done (R2)	2
8	Alphabet Street (R9)	9
9	Altai Rose (R10)	10
10	Amber Rayne (R3)	3
11	Ambrosini (R5)	5
12	Ambrosini (R6)	6
13	Ambrosini (R7)	7
14	Az Given (R6)	6
15	Bad Taste (R2)	2
16	Baseer (R9)
17	Belial (AUS) (R8)
18	Belinda's Girl (R3)
19	Bettorock (AUS) (R4)
20	Bettorock (AUS) (R6)
21	Biggin Hill (R8)
22	Billie Jean King (R3)
23	Blue Streak (R9)
24	Bohemian Lily (R5)
25	Boston Belle (R5)
26	Bronze Lass (R7)
27	Bronze Lass (R10)
28	Bulldozer (R9)
29	Caileag (R6)
30	Cape Mapperley (R3)
31	Captain Earnie (R2)
32	Carbonado (R1)
33	Carnavalito (R8)
34	Chasing Amy (R10)
35	Checkoutthemisses (R6)
36	Cheval Etoile (AUS) (R10)
37	Chloe Keeper (R2)
38	Chumana (R2)
39	Conrwin (R8)
40	Coolibah (R1)
41	Cornelius (R1)
42	Corundum (R7)
43	Cox Road (R2)
44	******* (R8)
45	Dartmoor (R4)
46	Dashin (R5)
47	De One Swat (R7)
48	Deebee Don (R9)
49	Delveen (AUS) (R8)
50	Diamond Citi (R7)
51	Doiknowyou (R8)
52	Dolores O'Riordan (R8)
53	Draw The Line (R9)
54	Dylan De Lago (R6)
55	Edward The Eighth (R1)
56	Eezemoova (R8)
57	El Corby (R1)
58	El Sparky (R10)
59	Elfee (R4)
60	Elfee (R7)
61	Embraceable You (R10)
62	Endorsement (AUS) (R8)
63	Fear Of God (AUS) (R2)
64	Fifty Shadz Famous (R4)
65	Fifty Shadz Famous (R5)
66	Fifty Shadz Famous (R6)
67	Florentina (R5)
68	Fort Street Dancer (R6)
69	Gateway (R8)
70	Gold Vault (R10)
71	Heeza Dreimer (R10)
72	High Tail It (R3)
73	Hot Mustard (R9)
74	Howzat (R5)
75	Ina Jam (R2)
76	Indian Giva (R4)
77	Istimagic (R9)
78	Iz (R1)
79	Izzanorange (R2)
80	Jafa Jill (R7)
81	Jovan (R6)
82	Just Enuff (R7)
83	Just The Deal (R7)
84	Justabout Ready (R10)
85	King Panamera (AUS) (R9)
86	Knight Court (R5)
87	Knockout (R4)
88	Lola Brigida (R3)
89	Los Vargas (R4)
90	Lulu Minosa (R10)
91	Makers Mark (R9)
92	Marcelle (R7)
93	Mary Quant (R4)
94	Mary Quant (R6)
95	Mary Quant (R7)
96	Mojave (R2)
97	Mongolian Hero (R4)
98	Moon Eclipse (R10)
99	Muscat Hills (R10)
100	Nancylee (R1)
101	Neutron Star (R8)
102	Nighean (R7)
103	No Tricks (R5)
104	No Tricks (R6)
105	No Tricks (R7)
106	Nulla Creek (R6)
107	Oompa (R9)
108	Our Queen Bee (R3)
109	Overnightsensation (R7)
110	Parisdotcon (R5)
111	Parisdotcon (R6)
112	Parisdotcon (R7)
113	Perfect Rose (R7)
114	Politicalnitemare (R2)
115	Promises (R4)
116	Pui Pui (AUS) (R8)
117	Rap N Tap (R9)
118	Red Robyn (R10)
119	Riot Act (R8)
120	Saavoya (R5)
121	Sacred Trust (AUS) (R4)
122	Scholes (R10)
123	Sea Of Speed (R4)
124	Sea Of Speed (R6)
125	Sea Of Speed (R7)
126	Secret Plan (R7)
127	Share The Wonder (R6)
128	Silver Tips (R6)
129	Sir Al Syd (R2)
130	Sisterhood (R5)
131	Smedley (R9)
132	Snaptoit (R4)
133	Snow Charm (R6)
134	Sonsy (R4)
135	Soul Keeper (R10)
136	Spy In The Huddle (R6)
137	Steffi's Secret (R3)
138	The Austrian Oak (R5)
139	The Good Duke (AUS) (R10)
140	Thewayyourave (R4)
141	Tremain (R9)
142	Trousseau (R8)
143	Varro (R2)
144	Vermeer (R5)
145	Victory Champion (R10)
146	Wadapleasure (R7)
147	Zah Best (R5)
148	Zah Best (R6)
149	Zah Best (R7)
150	Zaviera (AUS) (R10)
151	Zucchero (R10)
Sheet1

 

[Andrew Poulsom]

One way:

=-SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",99)),99)),"R","")+0

 

[XOR LX]

Hi.

=-SUBSTITUTE(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2)),"R","")

Regards

 

[Sunline]

Two great answers .
Thanks to you both .