Looking for help on a formula/function that can do a dynamic strip of a value

[TheRock_82]

I've run into an issue where parsing out a file left me no choice but to have combined values and text string separated by a space. I'm trying to pull the values out of these cells but it needs to be dynamic since the values change in length. For example here are some of the cells:
6.11 CR
295.21 DB
12.30 CR
189.85 CR

Hoping there is a function or formula that could always pull the values out of these cells regardless of the length in the value but remove the trailing space and "CR" OR "DB"?

[AlKey]

Try this

=--LEFT(A1,FIND(" ",A1)-1)

Data Range

	A	B
1	6.11 CR	6.11
2	295.21 DB	295.21
3	12.30 CR	12.3
4	189.85 CR	189.85

[TheRock_82]

I thought I replied, but don't see it. That worked! What does the "--" before the LEFT function do?

[AlKey]

I thought I replied, but don't see it. That worked! What does the "--" before the LEFT function do?

-- will convert text to number.

[TheRock_82]

Cool! Thanks for your help! I love working with these human readable reports (insert sarcasm here!) I appreciate the tips!