getting a specific string within a sentence

Hi! I was having trouble on getting a text string within a sentence..i hope someone can help me on this.

example:
in column A1:
1 - AMERICA 85 - 90 2 - CHINA

so i want to get only the 85 - 90 and it will shows on column A3..

hope you can help me on this one.

thanks

Hi
I'm not sure you are explaining exactly what you need. However based on the individual example this formula will extract what you need into A3. place the formula in A3:
=MID(A1,13,7)
Tony

As XOR LX says, you really need to provide a bigger list of possible variations but trying to make a generalised approach based on what I think your data might look like:
=MID(A1,FIND(" ",A1,FIND("- ",A1,1)+2)+1,FIND(" ",A1,FIND("- ",A1,FIND("- ",A1)+2)+2)-FIND(" ",A1,FIND("- ",A1,1)+2)-1)

sorry..here's another example:

A1 1-AMERICA 85 -90 2-CHINA

A2 3-USA 90 -60 4-ITALY

A3 5-CHINA 75 -60 6-SPAIN

SO i want to get:

A5 85 -90
A6 90 -60
A7 75 -60

Originally Posted by ragulduy

As XOR LX says, you really need to provide a bigger list of possible variations but trying to make a generalised approach based on what I think your data might look like:
=MID(A1,FIND(" ",A1,FIND("- ",A1,1)+2)+1,FIND(" ",A1,FIND("- ",A1,FIND("- ",A1)+2)+2)-FIND(" ",A1,FIND("- ",A1,1)+2)-1)

this one is working! thanks a lot!

thanks for all your answer guys!! i appreciate it.. sorry if i did not put more examples at first..im just new here and im not really used to ask questions on this kind of forum so i don't know how i am going to explain what i want to be the result, but thanks a lot on you guys for giving your ideas!

thanks

Thanks, although be careful - I don't think it will work on your examples in post #5!

Originally Posted by ragulduy

Thanks, although be careful - I don't think it will work on your examples in post #5!

i already tried it and i just adjust something on the formula and it worked so its fine.. thanks!