On Thu, 23 Jul 2009 12:54:02 -0700, Tech_Wolf
wrote:

ok, I need to write a formula that will check a cell with several words and
numbers in it, take the highest number is that cell, and display it in a
seperate cell as a numerical value, so other formulas can use it. How can I
accomplish this?

Provide some examples of data and desired output, in a way that demonstrates
the types of numbers and formats you might be dealing with.
--ron