On Sat, 8 Nov 2008 07:40:01 -0800, André Lopes -Brazil <André Lopes
wrote:

Hi,

My name is André Lopes and i am writing from Brazil.
I have a big problem and i am nedding help ...
I have in a cell (For example "A2") the following:

"Este é um teste e a taxa do USD é USD - 1.667"

And i need to extract only the value that will be, ever, *.***, where *
means any number.
Please note that i never know what will be the number of digits in the cell,
being that the value could have digits after it too.


Because of the examples you have provided in subsequent posts, I think you may
be misusing the term "digits" (digitos ou numera).

If there are truly "digitos" after the number you are trying to extract, we
need some examples so as to figure out a way to differentiate.

From what you have provided, it appears as if the string you are looking for is
the first word after a hyphen.

If that is the case, it can be extracted with this formula:

=LEFT(TRIM(MID(A1,FIND("-",A1)+1,99))&" ",
FIND(" ",TRIM(MID(A1,FIND("-",A1)+1,99))&" ")-1)



--ron