Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
RLN RLN is offline
external usenet poster
 
Posts: 3
Default Combining paragraphs but preserving spaces

My database programmer recently provided me my database of letters in
spreadsheet format. Many of the letters have paragraphs that in their
original application were separated by a blank line. When the letters from
the db were downloaded to excel the paragraphs appeared in separate cells,
for example, 'Dear XXX' appeared in one cell, then a cell was skipped, then
the beginning of the first paragraph appeared in the third cell. When the
first paragraph ended, there was another blank cell before the second
paragraph began, etc.

I wish to combine all the text into one cell, but to preserve the space that
appears between the paragraphs, represented now by the empty cells.

Does anyone have a suggestion?

Hope to hear from you soon.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Paragraphs Mike Lang New Users to Excel 3 May 23rd 07 06:14 AM
how do I remove leading spaces and leave the remianing spaces w Debi Excel Worksheet Functions 6 February 28th 07 03:29 PM
Separate Paragraphs in a cell? Quin Excel Discussion (Misc queries) 4 May 4th 06 08:14 PM
how can i make paragraphs in side one cell in Excell? ashraf Excel Discussion (Misc queries) 2 March 17th 05 04:37 PM
Moving paragraphs from MS Word to Excel [email protected] Excel Discussion (Misc queries) 3 March 2nd 05 02:36 AM


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"