Hi,

Thanks for your help!
I know how to make it manually, but I need this in a formula ...

"ShaneDevenshire" escreveu:

Hi,

In many case the best way to break up data that is in one cell into two or
more cells is to use the Text to Columns Wizard.

1. Select a single column of cells which you want to split.
2. Choose the command Data, Text to Columns,
3. Choose Delimited and click Next
4. Choose one of the delimiter or define one of your own in the Other box,
and then click Next
5. In many cases there is nothing you need to do at this step, so just click
Finish.

If this information helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"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.