This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I am adding a line break in a saved search formula where I combine 2 fields using a &lt;br&gt; tag. Looks good on the screen but when I export to Excel or PDF I am not getting the  line break. How can I have a line break also occur on the export?

I'm curios to know if this works. I'm guessing you want the line break inside your cell as opposed to creating a new line, right?

Hopefully NetSuite would escape this correctly but I wouldn't put any money on that

<@UER9Q3SGM> correct. Need the line break inside the cell.

<@U29QCJQF3> \n did not work unfortunatetly. I also tried CHAR(10) but that didn't work either.

Ok - so using chr(10) does work. You just need to go into the excel file and click in each cell for some reason. This is my formula:

`{name}||chr(10)||{number}`