How to Remove All Carriage Returns

Removing carriage returns manually - documents
1. Open your computer's word processing or text editor.
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. Place your cursor at the end of the line of characters.
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. Repeat Steps 3 and 4 for each carriage return code you want to remove.
Removing carriage returns using automation - documents
6. Open your computer's word processing or text editor.
7. 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.
8. 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.
9. 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.'
10. Click 'Edit,' 'Find Replace' to open the Find Replace utility.
11. 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.
12. Leave the 'Replace With' box blank. Click on 'Replace All.' All carriage return codes are now removed from your document.
Removing carriage returns using automation -- spreadsheets
13. 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.
14. 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.
15. Press the 'Enter' or 'Return' key on your computer's keyboard to execute the formula.
16. 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.