Need to print values after a certain text-string

[expense]

Hi All,
First time poster. I have a cell with the following text string:
01/20/15 01 PERSON ITEM MONTH15 MISC. US 4,140.99


I have thousands of these, and need to simply print 4,140.99 in a new column. I tried using the =RIGHT function to print the right most characters, but that doesn't work, because some dollar amounts are only 25.00 and some are 50,000. Is there a function I can use that will only print whatever comes after the MISC. US text?

Thanks

[Special-K]

This works
=TRIM(SUBSTITUTE(RIGHT(SUBSTITUTE(A1," ",REPT(" ",500)),500)," ",""))+0

It expects the value to be the last piece of data in the string and must be preceded with a space.

[JieJenn]

Can you provide more than 1 sample. Perhaps 10 samples?

[expense]

can you provide more than 1 sample. Perhaps 10 samples?

01/20/15 01 person item month15 misc. Us 4,140.99
01/20/15 01 person item month15 misc. Us 18,140.99
01/22/15 01 person item month15 misc. Us .01
01/20/15 01 person exchange month15 misc. Us 300.25
01/24/15 01 person item month15 misc. Us 9,140.99
01/25/15 01 person item month15 misc. Us 335,140.99

[candybg]

You could break up the data using TEXT-TO-COLUMNS and end up with all numbers in a single column.

[newdoverman]

IF your actual text is as given, this will extract the currency amount from the right of the cell. I have the text strings in column A starting at A1 and the formula in B1 and filled down. Format as currency if desired.

Please Login or Register  to view this content.

	A	B
1	01/20/15 01 person item month15 misc. Us 4,140.99	$4,140.99
2	01/20/15 01 person item month15 misc. Us 18,140.99	$18,140.99
3	01/22/15 01 person item month15 misc. Us .01	$0.01
4	01/20/15 01 person exchange month15 misc. Us 300.25	$300.25
5	01/24/15 01 person item month15 misc. Us 9,140.99	$9,140.99
6	01/25/15 01 person item month15 misc. Us 335,140.99	$335,140.99