Laboratory Information System

Laboratory Administration 2558
http://www.mediafire.com/view/92375s32ko1lb66/Laboratory_Information_System_2015-08.pdf

Remove Carriage Returns manually

From https://www.ablebits.com/office-addins-blog/2013/12/03/remove-carriage-returns-excel/

Remove Carriage Returns manually

Pros: the fastest way.
Cons: no any additional features :(.

Please find the steps for eliminating line breaks using Find and Replace:

1. Select all cells where you want to remove or replace carriage returns.
2. Press Ctrl+H to open the Find & Replace dialog box.
3. In the Find What field enter Ctrl+J. It will look empty, but you will see a tiny dot.
4. In the Replace With field, enter any value to replace carriage returns. Usually, it is space to avoid 2 words join accidentally. If all you need is deleting the line breaks, leave the "Replace With" field empty.
5. Press the Replace All button and enjoy the result!

Handle both Windows and UNIX carriage return/ line feeds combinations.
=SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),""),CHAR(10),"")
The next formula will help you replace line break with any other symbol (comma+space). In this case lines will not join and extra spaces will not appear.
=TRIM(SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),""),CHAR(10),", ")
If you want to remove all nonprintable characters from text, including line breaks:
=CLEAN(B2)