How to remove paragraph spacing in a cell (Excel 2007)
Maybe the paragraph spacings are in-cell linefeeds?
EditReplace
What: CTRL + j
With: space
Replace all.
Gord Dibben MS Excel MVP
On Tue, 23 Sep 2008 11:04:01 -0700, will~
wrote:
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
|