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