=SUBSTITUTE(A1,CHAR(10)," ")
--
David Biddulph

"will~" wrote in message
...
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