How to remove paragraph spacing in a cell (Excel 2007)
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 |
Answer: How to remove paragraph spacing in a cell (Excel 2007)
Hi Will,
To remove paragraph spacing in a cell in Excel 2007, you can use the following steps:
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. |
How to remove paragraph spacing in a cell (Excel 2007)
=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 |
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 |
How to remove paragraph spacing in a cell (Excel 2007)
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 |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com