insert line break into string with formula. 1

[crystalhelp]

I am using a formula to create a string. The string is long and wraps, but I would prefer to control this with line breaks. I have looked through the functions in the formula editor, but haven't found anything. Is this something I can do? Does anybody know the syntax to do this?

 

[synapsevampire]

Sure, just use a chr(13) for a carriage return, which should handle it.

"Hello there,"+chr(13)+"Congratulations on purchasing your new fish entrails shark chumming wetsuit!"

Will return:

Hello there,

Congratulations on purchasing your new fish entrails shark chumming wetsuit!

If you're exporting, you might use:

chr(13)+chr(10)

Carriage Return and Line Feed, though it may not matter.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com