On Mon, 3 Mar 2008 11:04:16 -0800, billinr
wrote:

I have a few formulas resulting from a vlookup:
=IF(ISERROR(VLOOKUP(K17&" "&M17&" "&O17&"
"&Q17,J29:J73,1,FALSE)),"",VLOOKUP(K17&" "&M17&" "&O17&"
"&Q17,J29:J73,1,FALSE))

This returns the correct answer, but when I try to separate the result into
columns, all I can see is the formula in the text to columns work box.
Since I want to leave this formula in place to use for future changes, I
don't want to use a copy/ paste values and lose the formula.
Is there a way to work with the values and still keep the formula?

TIA

Do the copy/paste values to a different column -- then work there.

Or, depending on the kind of result, you could use a formula to return the
portion of the answer that you want to different columns.
--ron