I have several thousand cells where I need to pull out some information at the end of each cell. So for the examples listed below, all the information resides in the "A" column.

For example:

M55116/14-5 CONN,RECEPT,6 PIN,U-228 TYPE B EA A AS 17 85.00 1,445.00

M39029/30-222 CONTACT,#0,RED-RED-RED B EA A AS 96-0327 46 6.75 310.50

M39029/44-288 CONTACT B EA A AS 93-0852 400 2.18 872.00

I am trying to pull off (starting from the end) all of the information after the first space and before the second space. From the example listed above, I now want to return the results 85.00, 6.75, 2.18.

Would someone please help me with this? I think with the answer provided to this problem I should be able to alter the Function equation to solve the rest of the issues that I have with pulling information out.

Thanks