How to remove paragraph spacing in a cell (Excel 2007)

[will~]

Excel 2007 on Windows XP PC

Please could you advice how I could format a column in Excel so that all the
paragraphs spacing are removed, and replaced by a 'space'?

In a Excel worksheet there are hundreds of rows of data. One of the column
contains a few lines of text. However, each lines are separated by a
paragraph spacing.

Many thanks in advance,

Will

 

[Gord Dibben]

Maybe the paragraph spacings are in-cell linefeeds?

Edit>Replace

What: CTRL + j

With: space

Replace all.


Gord Dibben MS Excel MVP

 

[will~]

Many thanks for your quick reply. It works perfectly.