Hi,

Thanks for your help!
But, as i said, I never know what will be the number of digits in the cell
and that value could have digits after, eg:

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

Anyhow, in the first example the formula does not works well ...
Can you help again?

"Sheeloo" escreveu:

If your numbers within the cell are always of the form #.### then use this in
B2
=MID(A2,FIND(".",A2)-1,5)

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