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

W

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
 
G

Gord Dibben

Maybe the paragraph spacings are in-cell linefeeds?

Edit>Replace

What: CTRL + j

With: space

Replace all.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with MS Word paragraph and character styles: format getting messed up 2
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Merging from an Excel file with graphics 1
nk into onenote 2016 paragraph from excel 2016 cell 0
Working on birthday "book" for my wife and having layout/editing trouble 0
Excel 2007 - Sudden Disappearance of Character Spacing 2
Excel does not accept text format! 0
Mail merge - how to include variable paragraphs without unnecessary spacing? 0

Top