Formula editor

Hi all,

I have a huge formula for one of my columns. I ran out of room in the formula editor today. Is there anyway to expand the editor’s space/memory? Like maybe have it point to some txt file or something (=C:\My Documents\text.txt)? Thanks.


Listserv Archives (BOB member since 2002-06-25)

Neil,

Try creating pieces of the formula as variables, then reference these subformula variables in the formula to be displayed in the cell.

Steven Jones
Consultant to BT Office Products International sjones@btopi.com


Listserv Archives (BOB member since 2002-06-25)