Andre

Carriage returns are usually Char(10) or Char(13)

Try EditReplace

What: hold down ALT key and enter 0010 from the numpad

With: leave blank or type a space

Replace all.


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 08:58:28 -0800, "Andre"
wrote:

I'm trying to import data into SQL server from Excel, but some of the fields
have carriage returns in them. I have been going thru each record and
manually deleting the carriage returns. I've been trying to do find/replace
but can not seem be able to input the carriage return in find/replace. Can
anyone give me an idea what would be easier then manually going thru each
record and delete any carriage return.