Is there a worksheet formula that will return the cell value's integer character only? For example, the cell value is "500+", I want to return the value "500". I know there are functions that will remove the "+" sign but I was wondering if there is a worksheet formula that will do that as well?
I've tried
=if(a1, "...+", value, 0) ?
If you're sure that extra character is always +, then use
=SUBSTITUTE(A1,"+","")
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments