Maybe you can copy|paste special values into a different range?

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

--

Dave Peterson