View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martha Martha is offline
external usenet poster
 
Posts: 32
Default Hard line break displaying as rectangle on import from SQL

Hi,
Am pulling data from a company db via SQL and the hard line breaks in
several fields are coming is as that annoying little rectangle. Result is
that the report is pages and pages longer than it has to be. When try to use
the Replace function, Excel does not recognize the character. Any ideas on
how to control this short of going through the entire data set manually?

Thanks much for any ideas,