Name Parse

S

Saxman

Would it be possible to parse these names so just the numbers remained.
Top of the list is cell A1.

D Tudhope 13.08
J Fanning 1
P McDonald 0.88
J J Doyle 6.15
Connor Beasley 1.41
P Makin 1.00
Neil Farley 0.69
Declan Cannon 0.69
J Quinn 0.81
T Hamilton 0.63
J Fanning 1.54
P Aspell 0.51
G Lee 1
D Fentiman 1
D Tudhope 1
Justin Newman 1
T Eaves 1
A Mullen 0.62
P McDonald 1
R Winston 1.62
P M Quinn 1
P Makin 0.95
J P Sullivan 1


TIA
 
C

Claus Busch

Hi,

Am Wed, 03 Jul 2013 16:15:54 +0100 schrieb Saxman:
Would it be possible to parse these names so just the numbers remained.
Top of the list is cell A1.

D Tudhope 13.08
J Fanning 1
P McDonald 0.88
J J Doyle 6.15
Connor Beasley 1.41
Click to expand...

in B1 try:
=LOOKUP(9^9,1*RIGHT(A1,COLUMN(1:1)))


Regards
Claus B.
 
S

Saxman

Hi,

Am Wed, 03 Jul 2013 16:15:54 +0100 schrieb Saxman:


in B1 try:
=LOOKUP(9^9,1*RIGHT(A1,COLUMN(1:1)))


Regards
Claus B.
Click to expand...


That works fine Claus. Thank you very much.
 
V

Vidcapper

Hi,

Am Wed, 03 Jul 2013 16:15:54 +0100 schrieb Saxman:


in B1 try:
=LOOKUP(9^9,1*RIGHT(A1,COLUMN(1:1)))
Click to expand...

A very handy formula - splitting out numbers is something I often need
to do. :)
 
Top