Hi,

Yes! That is right!
I could have more text after the 1.667 and i could find more numbers too.
The value could be at the end of the cell or in another position.
Ever we can find a dash and space in front of the number.

eg:

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

Can you help again?

"Rick Rothstein" escreveu:

What did you mean when you said "being that the value could have digits
after it too"? Did that mean you could have more text after the 1.667 some
of which could be digits? Or is the value you are after ALWAYS at the end of
the text? Also, is there ALWAYS a dash and space in front of the number?

--
Rick (MVP - Excel)


"André Lopes -Brazil" <André Lopes wrote
in message ...
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.