Is there any function in excel to do the opposite making TEXT function ? For example, TEXT function converts a value to text in a specific number format but I want converts text to value, how I can to do that ?
Initially I was thinking to do this using the "IF" but I'm 12 words and Excel 2003 supports up to 8 "IF's" in one formula.
Some help, please.