removing new line in a text cell ?

I am working with gnumeric on a big excel file sended by a friend.
There is a column containing cells with a long text and this text contains new line caracters. Exporting this file in text format (for automatic parsing in shell and building html files) hangs as it works on lines and, because of these new line caracters in one cell, a gnumeric line is broken in an unknown number of lines.

I would like to remove these new line caracter (or replace them by "<BR>") in the text cell but I didn't success at this time. Replacing \n is not the solution...

Any idea ?


|  Equipe M.O.S.T.         |          |
|  Patrick BEGOU           |       ------------               |
|  LEGI                    | mailto:Patrick Begou hmg inpg fr |
|  BP 53 X                 | Tel 04 76 82 51 35               |
|  38041 GRENOBLE CEDEX    | Fax 04 76 82 52 71               |

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]