DEV4 Blog

  • Home
  • /
  • Blog
  • /
  • Removing Carriage Returns from an MS Excel Spreadsheet

Carriage returns within text cells can often cause problems when you want to transfer data to another platform, such as a database.  An easy way to remove all carriage returns from a spreadsheet is to us the Excel Find and Replace function along with the special character for carriage returns:

Find and Replace:  Ctrl + h

Special character for carriage returns Ctrl + j

This video shows you an example:

Published on 28 Oct 2020 by Dev4

Add new comment...