Good morning all,

I'm hoping with all your combined expertise you will be able to help me. I am currently trying to build a formula that will pull text from a cell with between specific amount of spaces.

Example of what I need...

"00118385 B L S SL 10G 13 24 29.58 384.54 01/03/2011"
"00135641 * W C B M CN 133 24 36.21 1194.93 01/03/2011"

The above is the data entered cells. I require a formula that will pull out the number 13 from the middle of the first example (number 133 from the 2nd), by counting the number of spaces between the text.

The formula needs to look at the data within the cell from the right, as the number required is always between the 4th and 5th spaces from the right. The info on the left hand side however is variable, and the number of spaces can change from cell to cell. The length of all the information is also interchangable, so unfortunately I can't simply use "=right(len(..."

I have toyed with 'right(search(" ",' to no avail. I like to think I'm pretty useful with functions, but I think this one is beyond me.

Hopefully someone can help me!

Thanks (in advance!!),

Carl.