Find a carriage return in a worksheet

Giganews Newsgroups
Subject: Find a carriage return in a worksheet
Posted by:  VW (anonymo…@discussions.microsoft.com)
Date: Tue, 11 May 2004

I have a big Excel file that has been saved as a CSV file.
We need to upload this file to SAP. However, some cells
contain a carriage return (it is displayed as a square in
the cell). I need to fix all the rows that have the
carriage return. Is there a way to FIND a cell with
carriage return ? ie. by using the FIND function.

Replies