View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andre
 
Posts: n/a
Default Delete Carriage Returns

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.