SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 1 down vote accepted suggests that this can be achieved with " Shift + Enter "

Worth a try?


share|improve this answer
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).

share|improve this answer

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:


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



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

share|improve this answer

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=""></script>
<script language="javascript" type="text/javascript">
  function insertLineBreaks() {
share|improve this answer
This looks like a solution! Can the script be inside a content editor web part or does it have to be located in the main page html? – 121315 Jul 25 '11 at 16:25
You should be able to put it in a Content Editor web part. – Laurie Jul 25 '11 at 16:36
@Laurie - code works great until you set up the view to group your line items. Then it breaks and shows "<br/>" again. How do you get around the grouping so the code can access the list items again? – user31626 Jul 16 '14 at 21:48
Is this solution taken from… ? – George Feb 5 '15 at 3:55

Use Char(10) as a line break character.

share|improve this answer

Include <br/> and return the calculated column as a number instead of a single line of text. For some reason, this returns html.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.