Share via

CHAR value for a Carriage Return

Anonymous
2015-05-15T06:54:57+00:00

I am trying to find the right CHAR value in Excel, so that when the information is copied into Word, it results in a Carriage Return (Paragraph Mark ¶).

Char(10), CHAR(11) & CHAR(13) all copy and result in a Line Break (Soft Return), but I'm unable to find a way to produce a ¶ (Hard Return).

Any help appreciated.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2015-05-15T08:06:37+00:00

    Hello,

    Use Paste Special in Word and paste as formatted text. That will turn both Char(10) and Char(13) into paragraph marks. 

    If you paste as HTML, then both Char(10) and Char(13) will be returned as soft line breaks.

    If you paste as unformatted text, both Char(10) and Char(11) bill be returned as paragraph marks, but the text will contain the quotes that you used in the formula to put together the string. 

    Pasting as formatted text will return all line breaks as paragraph breaks and strip quotes.

    2 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest