removing text from numbers

[blacktour]

Is there a function that can clean up numbers that look like this

nt 347.14
a 47.14
679.44
c 547.14
88,888.55
bb 47.14

I want to remove the text from the startings of these numbers they are either the first, second, or third string from the left but it varies is there a RemoveText function

Thanks,
Mike

 

[Richard Schollar]

Hi Mike

Formula in B1 can be copied down as far as required:

Excel Workbook
	A	B
1	nt 347.14	347.14
2	a 47.14	47.14
3	679.44	679.44
4	c 547.14	547.14
5	88,888.55	88888.55
6	bb 47.14	47.14
7	golf
Sheet2