Embedding <CR>'s in formulas eases eye strain.

  • Thread starter Thread starter Jim Luedke
  • Start date Start date
J

Jim Luedke

Hey y'all, if didn't know this, I just discovered:

You can embed internal carriage returns (i.e. Enter's) in a formula.

Insert a <CR> into a cell with Alt-Enter, while in edit mode.

I have many calls to home-grown functions (UDFs) which I pass up to
dozens of parameters each. Worse, my params can be embedded functions,
with params, themselves.

So now my formulas look like:

=MyFunc(Subfunc1(Subparam1.1,...),
Subfunc2(Subparam2.1,...),
Subfunc3...etc.)

instead of the following mess. (Text wrap may be altered a bit by
Google by the time you read this):

=MyFunc(Subfunc1(Subparam1.1,...),Subfunc2
(Subparam2.1,...),Subfunc3...etc.)

Neat, huh?

***
 
Thanks for sharing, Jim. You can also do this with text in a formula,
just press Alt-Enter to force a line break.

--JP
 
Back
Top