# How to add line breaks in calculated columns without going into data view?

Just wondering how to create a list with line breaks in a calculated column without using data view.

-

social.technet.microsoft.com suggests that this can be achieved with " Shift + Enter "

Worth a try?

Steve

-
This works for sure inside =CONCATENATE() –  121315 Jul 6 '12 at 12:42

I suppose it depends on what you want the business rules to be around where the line breaks should appear and in how many places (all pages, just a single view, just on the forms, etc.). You could probably do this with script added to the page(s).

-

I've had a play around and I'm afraid I can't see a way to do this. The only two options I can think of are:

=CONCATENATE("A","
","B")


Which outputs A B because actual new lines are ignored by the HTML rendering.

or

=CONCATENATE("A","<br/>","B")


Which outputs A<br/>B because HTML output is escaped by SharePoint.

-

You could use <br/> in your column to indicate a line break. Then, add a script to your page to insert that text as html so that <br/> becomes an html line break.

<script src="http://code.jquery.com/jquery-1.6.1.min.js"></script>
<script language="javascript" type="text/javascript">
function insertLineBreaks() {
$("table.ms-listviewtable").find("td.ms-vb2").filter(":contains(<br/>)").each( function(){$(this).html('<div>'+\$(this).text()+'</div>');
});
}