Line wrap character in formula editor

[Danster]

Gday all,

I'm writing a long formula which needs to be on a single line.
What is the character in the formula editor which will allow me to continue the code on the next line?

Or is their a word wrap function like Notepad?

Thanks

 

[vidru]

If you're using Crystal syntax for your formula, there isn't one. Just hit the [ENTER] key wherever you want to start a new line. As long as your syntax is valid, it doesn't seem to care that you're on a new line.

For Basic syntax, use the underscore ( _ ) to continue onto the next line:

formula = "Here is some text from line one " & _
    "that is continued on line two."

-dave

 

[Danster]

Thx Dave.

I'm using Crystal syntax & it seems to matter. Using your example, if it didn't matter, this would be a valid statement..

formula = "Here is some text
that is continued on line two"

 

[Madawc]

Individual elements of a formula cannot be broken between lines. You could have said

"Here is some text" &
" that is continued on line two"

Apart
from
that, you can
use as many lines as
you please.

Madawc Williams (East Anglia, UK)