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.

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.

Ok Great it got rid of the actual return but it is still leaving a rectangled
box where the return took place is there any way to get rid of that
rectangled box.


"Gord Dibben" wrote:

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.