Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 247
Default Concatenate: Multi-Line Cell with 2 single line cells

Using Excel 2003, SP2:
The following is to allow a cut and paste of the required data into a text
file, while maintaining a "columner" look to the data.
FIRST:
Looking to Concatenate cell C?, (which could be anything from a single line
to perhaps, 25 lines long), with D? and E?, each of which will only be 1 line
long.

Is this possible? If so, is there any control as to which line the D and E
cells would line up with? If there is an option, the end result would be most
legible, if the D & E line up with the topmost line of C.

IF the above doesn't stop this project in its tracks, I will try to use
various formulas found in this ng from Dave Peterson, to see if I can get
Columns D and E spaced out, so that it still looks like a spread-sheet.
Thankyou

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
How do I show only the last portion of text in a multi line cell? Qwnuvhrts Excel Worksheet Functions 1 November 3rd 06 11:58 PM
More than one line in a single cell? u_gothope New Users to Excel 1 September 26th 06 06:47 PM
Multi line merged cell - adapting to different size input - possible? David Smithz Excel Discussion (Misc queries) 1 June 18th 06 04:21 PM
how can I paste multi-line/multi-paragraph data into ONE cell? Theano Excel Discussion (Misc queries) 3 June 7th 05 01:10 PM
How do I change multi-line entries to single line entries in Exce. CPOWEREQUIP Excel Worksheet Functions 3 April 14th 05 12:38 AM


All times are GMT +1. The time now is 12:27 AM.

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

About Us

"It's about Microsoft Excel"