How to Remove All Carriage Returns

Written by nick davis
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Remove All Carriage Returns
There are a number of ways to remove carriage returns. (ANSI image by DBX60 from Fotolia.com)

A carriage return is an invisible code placed at the end of a line of text that tells the computer to start a new line for the next series of characters. Carriage returns are formatting codes present in word processing, spreadsheet and other application files. You can remove the codes manually, even though the code itself is invisible in most programs, or by using an automated feature built into applications. Once removed, carriage returns can be reinserted, if desired.

Skill level:
Easy

Other People Are Reading

Things you need

  • Word processing application or text editor
  • Spreadsheet application

Show MoreHide

Instructions

  1. 1

    Open your computer's word processing or text editor.

  2. 2

    Open the document you want to remove carriage returns from by navigating to the directory containing the document and double clicking on the file's name.

  3. 3

    Place your cursor at the end of the line of characters.

  4. 4

    Press the "Delete" key on your computer's keyboard until the line below the one you are on has moved up next to your cursor.

  5. 5

    Repeat Steps 3 and 4 for each carriage return code you want to remove.

  1. 1

    Open your computer's word processing or text editor.

  2. 2

    Open the document you want to remove carriage returns from by navigating to the directory containing the document and double clicking on the file's name.

  3. 3

    Place your cursor at the end of the line of characters. Highlight the area with your mouse to the beginning of the next line of characters.

  4. 4

    Press and hold the "CTRL" key on your computer's keyboard. Press the "C" key to copy the contents highlighted, if using Windows. If using a Mac, press and hold the "Apple" key and press "C."

  5. 5

    Click "Edit," "Find & Replace" to open the Find & Replace utility.

  6. 6

    Click in the box under the heading "Find What" or "Search For." Press and hold the "CTRL" key. Press the "C" key to paste the contents highlighted if using Windows. If using a Mac, press and hold the "Apple" key and press "V."

    If using Microsoft Word or OpenOffice, place "^p" in the "Find What" or "Search For." box.

  7. 7

    Leave the "Replace With" box blank. Click on "Replace All." All carriage return codes are now removed from your document.

  1. 1

    Open the spreadsheet you want to remove carriage returns from by navigating to the directory containing the spreadsheet and double clicking on the file's name.

  2. 2

    Enter "=SUBSTITUTE(XX,CHAR(13),"")" in any blank cell of your spreadsheet. Replace the "XX" with the "Column" letter and "Row" number of the cell containing the carriage return you want to remove. Note, the "13" is the ASCII code for a carriage return on both Windows and Mac systems.

  3. 3

    Press the "Enter" or "Return" key on your computer's keyboard to execute the formula.

  4. 4

    Change the "Column" and "Row" values for each cell you want to remove carriage returns from. Press the "Enter" or "Return" key to execute the formula.

Tips and warnings

  • After the carriage returns are removed, save your document or spreadsheet under a different file name, if you need to use or print the original file containing the carriage returns later.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.