Excel 2002 crashes when modifying a function

[Jorge]

I am entering a function (a lookup) into Excel and find
that when I try to modify it, Excel 2002 crashes
altogether. I've looked at the problem and it appears that
I've gone over the character limit for the function. Is
there any way around this problem without having to embed
it in a macro?

 

[Don Guillett]

You could assingn defined names to part of the formula
=vlookup(bill,joe,2,0)

 

[Tim Otero]

Or you could post the formula, tell us what you are attempting to accomplish
(briefly) and someone will try to help you shorten it. Could be you just
have an unnecesarily long formula.

tim