How to remove newlines from worksheet

[Bob Waite]

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 ?

 

[David Biddulph]

Edit/ Replace/ Alt-0010
Replace with/ whatever you want in place of the Alt-0010

Or =SUBSTITUTE(A1,CHAR(10)," ") [assuming that you want to replace by a
space; modify to suit]

If your CR/LF isn't a CHAR(10), check what it is, perhaps CHAR(13).
You can find what it is by using =CODE(MID(A1,position,1)) where position is
(for example) 15 if your CR/LF is the 15th character in the cell.

 

[Bob Waite]

Thank you David. I have managed to solve my problem using the SUBSTITUTE
function, as you suggested

Edit/ Replace/ Alt-0010
Replace with/ whatever you want in place of the Alt-0010

Or =SUBSTITUTE(A1,CHAR(10)," ") [assuming that you want to replace by a
space; modify to suit]

If your CR/LF isn't a CHAR(10), check what it is, perhaps CHAR(13).
You can find what it is by using =CODE(MID(A1,position,1)) where position is
(for example) 15 if your CR/LF is the 15th character in the cell.
--
David Biddulph

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 ?