If function to ignore '+' & "-" symbols

So I'm doing an IF to bring back a value if the number contained in a cell is greater than the number in my formula:

=IF(N7>=8,"Y","N")

Nice & easy, The number values are only one to nine.

However the issue is some of these numbers have a '+' or "-" symbol after the number. (So a value could be '8+' or '8-', for example)

My IF then ignores this value entirely as it doesn't pick it up as a number.

So i need my formula to ignore the +/- symbol.

Try...
=IF(LEFT(N7,LEN(N7)-1)*1>=8,"Y","N")

You could try it like this:

=IF(--SUBSTITUTE(SUBSTITUTE(N7,"+",""),"-","")>=8,"Y","N")

Hope this helps.

Pete

Try this ...

=IF(SUBSTITUTE(SUBSTITUTE(N7,"+",""),"-","")+0>=8,"Y","N")

Thanks all substitute worked best.