Separate number (with varying # number of characters) from text

[megera716]

I need to separate this dollar amount from its label. How do I do this? I know how to use text to columns but dollar amounts range from single digit dollars to hundreds so I can't use fixed width and I'm not great with the LEFT, RIGHT, MID functions

 

[DanteAmor]

If you always have a dot and 2 decimal places:

Dante Amor
	A	B
1	$156.24Salary Deferral	156.24
2	$31.25Match	31.25
3	$25.00Match	25.00
Hoja3

Cell Formulas
Range	Formula
B1:B3	B1	=LEFT(A1,SEARCH(".??",A1)+2)+0

 

[awoohaw]

Are you only looking to the the dollar amount out? With or without the dollar sign?
Try this:
=LEFT(A2,FIND(".",A2)+2)

 

[megera716]

Thank you @DanteAmor ! (And @awoohaw for also responding, I just saw/tried Dante's response first)