Do you mean that you want to fix the values returned by the formula,
so that you no longer have the formula, or do you mean that you want
the numeric characters from the result of your formula (only), so that
09R4 would become 94, and 1099r would become 1099?

Pete

On Apr 21, 11:33*pm, Nadine wrote:
I need to convert cells of data to values. *The data is the result of the
following formula: =LEFT(D2,SEARCH(" ",D2)-1). *Example of data results:
1099r, 1073, 10866c, 09R4, etc. *I need Excel to see them as values in order
for a formula to recognize them. *It doesn't matter if the cell is formatted
as general, text, or number. *This is in Excel 2003.

Thanks so much.