View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Waite Bob Waite is offline
external usenet poster
 
Posts: 2
Default How to remove newlines from worksheet

We have a csv file which was exported by a database application. One column
contains text which includes newline characters (i.e carriage return+linefeed
characters). Is it possible to remove these newline characters from all cells
in the column, without having to edit the cells manually ?