Some thoughts. You can actually slant everything to be text comparisons
instead of numeric comparisons. From the sample data that you posted, that
seems to me the better route. LEFT per se will return everything as text, so
those returns are fine n ready for you to compare as text. What you need to
do is to switch the other formula to be text comparisons, eg compare other
lookup values as text. Eg: use = vlookup(A2&"", ...) instead of =vlookup(A2,
....) if A2 might contain real numbers. Any worth? hit YES below
--
Max
Singapore
---
"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.