Look & return values, in cells with numbers & words

[Guest]

Hello
I have a problem in a table that has words and numbers:
ex.-> Puxador 3584.251 Jkf
I want that it reads only the 3 last numbers and returns to onother cell the designation:
ex.-> Puxador 3584.251 Jkf &( Designation i read and recognize as 251)
How can i do this?

Thanks in advance

 

[Andy B]

Hi

If the three numbers you are wanting are always preceeded by the only full
stop (period) in the cell you could use:
=MID(B10,FIND(".",B10)+1,3)
to return them. It really depends on if your cells are uniform in content.

 

[Andy B]

Hi

You'll need to use the VALUE function:
=VALUE(MID(B10,FIND(".",B10)+1,3))

 

[Guest]

Thanks a lot!!
I was searching in functions & find that too, this was what i done, and it works:
A25 B25
puxador 3541.600 fdsd =MID(B25;FIND(".";B25)+1;3

C25
=IF(VALUE(C25)=400;"Quatro";IF(VALUE(C25)=500;" Cinco";IF(VALUE(C25)=600;"seis";""))

D25
puxador 3541.600 fdsd seis

Is doing exactly like i want want (D25)!
As u said now is more easier cos instead of write everytime value it writes only once, & i'll do that!
Then i'll copy values only & substitute in col A.
Can i use Vlookup instead of using IF?

Thanks

P.S.- It's funny how i avoied Excell in last 7 Years and now since i was forced to work with it (2 months ago) i'm loving it thanks to all help from here

Portuguese saudations

"Andy B" escreveu:

 

[Andy B]

Thanks for the thanks

--
Andy.

Thanks a lot!!
I was searching in functions & find that too, this was what i done, and it works:
A25 B25
puxador 3541.600 fdsd =MID(B25;FIND(".";B25)+1;3

C25
=IF(VALUE(C25)=400;"Quatro";IF(VALUE(C25)=500;" Cinco";IF(VALUE(C25)=600;"seis";""))

D25
puxador 3541.600 fdsd seis

Is doing exactly like i want want (D25)!
As u said now is more easier cos instead of write everytime value it

writes only once, & i'll do that!

Then i'll copy values only & substitute in col A.
Can i use Vlookup instead of using IF?

Thanks

P.S.- It's funny how i avoied Excell in last 7 Years and now since i was

forced to work with it (2 months ago) i'm loving it thanks to all help
from here