how to paste text with CR into one row
Sometimes you may suffer from copy from word (html table or any other text resource) and paste to the excel which results distribute single rows into consecutive sheet sequence. Use Microsoft Word 2010 or never version in order to replace unprinted character like carriage return etc. Here is the instruction; copy all texts from source paste to empty word document click ctrl+h replace menu will be displayed click "Find what:" find "Manual Line Break" through "Special" button bottom of the window type one space to the "Replace with:" click "Replace All" It is now ready to copy and paste to the excel. good luck...