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...


Popular posts from this blog

Assembly Microsoft.Dynamics.Service.Plugins.dll can not be loaded. Dynamics CRM 365 Engine version 9 - CRM User creation error

Exception caught instantiating TERADATA report server extension SQL Reporting Services

Could not load file or assembly 'System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified at Configuration class initiation in