function - cell value (text and numbers) number is between x and y?

[Armitage2k]

Hi,

anyone can help me out of this. I need an approach towards a cell with both text and number to determine of the number is between a certain range and then display an "@" symbol.

example:
A1: "Michael - 6"
The function needs to determine if the number content (6) is between bigger or equal to 2 and smaller than 10. If yes, then display an "@" symbol.

I couldnt do it with FIND and a normal IF approach brings no luck since there is also text in the cell.

Any idea? VBA can be an alternative...
A2k

[Domski]

Hi,

Maybe: =IF(TRIM(RIGHT(A1,LEN(A1)-FIND("-",A1)))*1>=2,"@","")

Dom

[Armitage2k]

and a very big thanks goes to the Domski

A2k