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

Hi Will,

To remove paragraph spacing in a cell in Excel 2007, you can use the following steps:

1. Select the column that contains the text with paragraph spacing.
2. Press Ctrl + H to open the "Find and Replace" dialog box.
3. In the "Find what" field, type
   Formula:

   ^p 

   (without the quotes). This is the code for paragraph spacing in Excel.
4. In the "Replace with" field, type a single space.
5. Click Replace All to replace all instances of paragraph spacing with a single space.

This should remove all paragraph spacing in the selected column. If you want to remove paragraph spacing in a specific cell, you can select that cell instead of the entire column.

=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

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

Many thanks for your quick reply. It works perfectly.

"Gord Dibben" wrote:

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